|
|
| 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|
| |
| − | <nowiki>Alert log location</nowiki>|
| |
| − | <pre>
| |
| − | /* Alert log location*/
| |
| − | create table tsqw_AlertFile (
| |
| − | ingres_sid varchar(30) not null,
| |
| − | gather_date datetime not null,
| |
| − | alert_file VARCHAR (800)
| |
| − | )
| |
| − | engine InnoDb
| |
| − | ;
| |
| − | grant all on tsqw_AlertFile to inddba;
| |
| − | </pre>
| |
| − | }}
| |
