(One intermediate revision by the same user not shown) Line 1:
Line 1: {{SQWareRepositoryPresSgbd|Ingres|database|INGRES_SID|ing}}
{{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>Alert log location</nowiki>|
<nowiki>... </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>
}}
}}
Presentation It is the repository module, and stores rdbms indicators for all RDBMS. 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
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 :
...
Field Type
dbalias varchar(80)
database_name varchar(80)
gather_date datetime
size_db decimal(12,2)
