Difference between revisions of "SQWareRepository:ingres"

From Wiki_dbSQWare
Jump to: navigation, search
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
{{SQWareRepositoryPresSgbd|Ingres|database|INGRES_SID}}
+
{{SQWareRepositoryPresSgbd|Ingres|database|INGRES_SID|ing}}
−
== Database content ==
+
== Specific database content for Ingres ==
−
{{SQWareRepositoryTables|tsqw_Repository|
 
−
<nowiki>Repository</nowiki>|
 
−
<pre>
 
−
/* Repository */
 
−
create table tsqw_Repository (
 
−
ingres_sid varchar(30) not null,
 
−
virt_host_name varchar (64) not null,
 
−
host_name varchar (64) not null,
 
−
username  varchar (60) not null,
 
−
port integer not null,
 
−
comments varchar(500),
 
−
contact varchar(100),
 
−
status varchar(10) default 'ON',
 
−
client varchar (60) default 'N.A',
 
−
upd_date datetime,
 
−
env  char(3)
 
−
)
 
−
engine InnoDb
 
−
;
 
−
grant all on tsqw_Repository to inddba;
 
−
alter table tsqw_Repository add ( constraint isqw_Repository_pk primary key (ingres_sid));
 
−
 
 
−
</pre>
 
−
}}
 
−
 
 
−
{{SQWareRepositoryTables|tsqw_RepositoryOther
 
−
|<nowiki>
 
−
Repository other
 
−
</nowiki>|
 
−
<pre>
 
−
/* Repository other */
 
−
create table tsqw_RepositoryOther (
 
−
ingres_sid varchar(30) not null,
 
−
virt_host_name varchar (64) not null,
 
−
host_name varchar(64) not null,
 
−
username  varchar(60) not null,
 
−
port integer not null,
 
−
comments varchar(500),
 
−
contact varchar(100),
 
−
status varchar(10) default 'XXX',
 
−
client varchar (60) default 'N.A',
 
−
upd_date datetime,
 
−
env  char(3)
 
−
)
 
−
engine InnoDb
 
−
;
 
−
grant all on tsqw_RepositoryOther to inddba;
 
−
 
 
−
</pre>
 
−
}}
 
−
 
 
−
{{SQWareRepositoryTables|tsqw_JobsExec
 
−
|<nowiki>
 
−
Jobs monitoring
 
−
</nowiki>|
 
−
<pre>
 
−
/* Jobs monitoring */
 
−
create table tsqw_JobsExec
 
−
(
 
−
ingres_sid varchar(50) not null,
 
−
beginning datetime not null,
 
−
script char(80) not null,
 
−
parameters varchar(400) not null,
 
−
end datetime,
 
−
duration char(8),
 
−
status integer
 
−
)
 
−
engine InnoDb
 
−
;
 
−
alter table tsqw_JobsExec add ( constraint isqw_JobsExec_pk primary key (ingres_sid, beginning, script, parameters) );
 
−
grant all on tsqw_JobsExec to inddba;
 
−
 
 
−
</pre>
 
−
}}
 
−
 
 
−
{{SQWareRepositoryTables|tsqw_VolFS
 
−
|<nowiki>
 
−
Volumetry TS
 
−
</nowiki>|
 
−
<pre>
 
−
/* Volumetry TS */
 
−
create table tsqw_VolFS (
 
−
ingres_sid varchar(30) not null,
 
−
gather_date datetime not null,
 
−
host_name varchar (64) not null,
 
−
filesystem varchar (200) not null,
 
−
size_fs integer not null,
 
−
used integer not null,
 
−
free integer not null,
 
−
rate integer not null,
 
−
mount varchar (200)
 
−
)
 
−
engine InnoDb
 
−
;
 
−
grant all on tsqw_VolFS to inddba;
 
−
alter table tsqw_VolFS add ( constraint isqw_VolFS_pk primary key (ingres_sid, gather_date,mount));
 
−
 
 
−
</pre>
 
−
}}
 
−
 
 
−
{{SQWareRepositoryTables|tsqw_VolFSThreshold
 
−
|<nowiki>
 
−
Specific FS threshold
 
−
</nowiki>|
 
−
<pre>
 
−
/* Specific FS threshold */
 
−
create table tsqw_VolFSThreshold (
 
−
ingres_sid varchar(30) not null,
 
−
mount varchar (200),
 
−
threshold_c integer not null,
 
−
threshold_w integer not null
 
−
)
 
−
engine InnoDb
 
−
;
 
−
grant all on tsqw_VolFSThreshold to inddba;
 
−
alter table tsqw_VolFSThreshold add ( constraint isqw_VolFSThreshold_pk primary key (ingres_sid, mount));
 
−
 
 
−
</pre>
 
−
}}
 
−
 
 
−
{{SQWareRepositoryTables|tsqw_VolFSThresholdDef
 
−
|<nowiki>
 
−
Default FS threshold
 
−
</nowiki>|
 
−
<pre>
 
−
/* Default FS threshold */
 
−
create table tsqw_VolFSThresholdDef (
 
−
size_fs integer not null,
 
−
threshold_c integer not null,
 
−
threshold_w integer not null
 
−
)
 
−
engine InnoDb
 
−
;
 
−
grant all on tsqw_VolFSThresholdDef to inddba;
 
−
alter table tsqw_VolFSThresholdDef add ( constraint isqw_VolFSThreshold_pk primary key (size_fs));
 
−
 
 
−
insert into tsqw_VolFSThresholdDef (size_fs,threshold_c,threshold_w) values (2048, 90, 80);
 
−
insert into tsqw_VolFSThresholdDef (size_fs,threshold_c,threshold_w) values (10240, 92, 85);
 
−
insert into tsqw_VolFSThresholdDef (size_fs,threshold_c,threshold_w) values (20480, 95, 90);
 
−
insert into tsqw_VolFSThresholdDef (size_fs,threshold_c,threshold_w) values (102400000, 99, 97);
 
−
 
 
−
</pre>
 
−
}}
 
−
 
 
−
{{SQWareRepositoryTables|tsqw_VolDb
 
−
|<nowiki>
 
−
Volumetry databases
 
−
</nowiki>|
 
−
<pre>
 
−
/* Volumetry databases */
 
−
create table tsqw_VolDb (
 
−
ingres_sid varchar(30) not null,
 
−
database_name varchar(80) not null,
 
−
gather_date datetime not null,
 
−
size_db integer
 
−
)
 
−
engine InnoDb
 
−
;
 
−
grant all on tsqw_VolDb to inddba;
 
−
alter table tsqw_VolDb add ( constraint isqw_VolDb_pk primary key (ingres_sid, database_name, gather_date));
 
−
 
 
−
</pre>
 
−
}}
 
−
 
 
−
{{SQWareRepositoryTables|tsqw_VolInstance
 
−
|<nowiki>
 
−
Volumetry instance
 
−
</nowiki>|
 
−
<pre>
 
−
/* Volumetry instance */
 
−
create table tsqw_VolInstance (
 
−
ingres_sid varchar(30) not null,
 
−
gather_date datetime not null,
 
−
size_instance integer,
 
−
maj_version integer,
 
−
version varchar(30)
 
−
)
 
−
engine InnoDb
 
−
;
 
−
grant all on tsqw_VolInstance to inddba;
 
−
alter table tsqw_VolInstance add ( constraint isqw_VolInstance_pk primary key (ingres_sid, gather_date));
 
−
 
 
−
</pre>
 
−
}}
 
−
 
 
−
{{SQWareRepositoryTables|tsqw_GenHisto
 
−
|<nowiki>
 
−
Monthly global informations
 
−
</nowiki>|
 
−
<pre>
 
−
/* Monthly global informations */
 
−
create table tsqw_GenHisto (
 
−
ingres_sid varchar(30) not null,
 
−
month datetime not null,
 
−
gather_date datetime not null,
 
−
size_instance integer,
 
−
maj_version integer,
 
−
version varchar(30),
 
−
client varchar (60),
 
−
env  char(3)
 
−
)
 
−
engine InnoDb
 
−
;
 
−
grant all on tsqw_GenHisto to inddba;
 
−
alter table tsqw_GenHisto add ( constraint isqw_GenHisto_pk primary key (ingres_sid, month));
 
−
 
 
−
</pre>
 
−
}}
 
  
−
{{SQWareRepositoryTables|tsqw_AlertFile
+
{{SQWareRepositoryTables|tsqwing_VolDb|
−
|<nowiki>
+
<nowiki>...</nowiki>|
−
Alert log location
 
−
</nowiki>|
 
 
<pre>
 
<pre>
−
/* Alert log location*/
+
Field Type
−
create table tsqw_AlertFile  (
+
dbalias varchar(80)
−
ingres_sid varchar(30) not null,
+
database_name varchar(80)
−
gather_date datetime not null,
+
gather_date datetime
−
alert_file  VARCHAR (800)
+
size_db decimal(12,2)
−
)
 
−
engine InnoDb
 
−
;
 
−
grant all on tsqw_AlertFile to inddba;
 
 
</pre>
 
</pre>
 
}}
 
}}

Latest revision as of 18:09, 8 August 2015

Presentation

It is the repository module, and stores rdbms indicators for all RDBMS.
It is a MySQL database.
Objects prefix by tsqw_% or isqw_% are generic.
Objects prefix by tsqwing_% or isqwing_% are specific for Ingres.
Installation guide for SQWareRepository for Ingres

Naming convention

All specific objects for Ingres are named with prefixes:

  • tsqwing_% : for tables
  • isqwing_% : for index
  • isqwing_%_u : for uniques
  • isqwing_%_pk : for primary key


Nuvola apps important.png
Warning:
Do not change the standard tables of the tool. For your custom objects, use another name convention than dbSQWare.

This will facilitate version upgrades.


Specific database content for Ingres

tsqwing_VolDb

This table contains : ...
Desc of tsqwing_VolDb :

Field Type
dbalias varchar(80)
database_name varchar(80)
gather_date datetime
size_db decimal(12,2)
Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareRepository:ingres&oldid=7263"