SQWareRepository:general: Difference between revisions

From Wiki_dbSQWare
Jump to navigation Jump to search
← Older edit
No edit summary
 
(19 intermediate revisions by the same user not shown)
Line 1: Line 1:
== présentation ==
== Presentation ==
C'est le module de gestion du référentiel et indicateurs en bdd.<br>
SQWareRepository, is the repository module, and stores rdbms indicators.<br>
Il permet de gérer le référentiel ainsi que les indicateurs en bases de données (il s'agit en fait d'un shéma).<br>
It manage the repository and the database indicators ...<br>
<br>
<br>
Ce module est composé d'une partie par SGBD géré. Il n'y a pas de partie 'core', chaque type de SGBD est indépendant. Il y a tout de même une cohérence entre tous ces schémas, vous trouverez par exemple la table référentielle tsqw_Repository dans chacun d'entre eux.<br>
This module has is managed in a MySql database.<br>
Chaque schéma est géré dans le même type de SGBD que celui géré, ceci pour éviter les problématique de déploiement de clients (Oracle dans Oracle, Sybase dans Sybase, ...).
<br>
Liens vers les différentes parties du module SQWareRepository :
Links to different plugins of SQWareRepository module :
*[[SQWareRepository:oracle|Partie Oracle]]
*[[SQWareRepository:oracle|Oracle plugins]]
*[[SQWareRepository:sybase|Partie Sybase]]
*[[SQWareRepository:sybase|Sybase plugins]]
*[[SQWareRepository:mysql|Partie Mysql]]
*[[SQWareRepository:mysql|Mysql plugins]]
*[[SQWareRepository:mssql|Partie Mssql]]
*[[SQWareRepository:mssql|Mssql plugins]]
*[[SQWareRepository:mongodb|MongoDB plugins]]
*[[SQWareRepository:db2|DB2 plugins]]
*[[SQWareRepository:postgres|PostgreSQL plugins]]
*[[SQWareRepository:teradata|Terdata plugins]]
*[[SQWareRepository:cassandra|Cassandra plugins]]
*[[SQWareRepository:adabas|Adabas plugins]]
*[[SQWareRepository:ingres|Ingres plugins]]
[[Installation#SQWareRepository | Installation guide for SQWareRepository]]<br>
<br>
<br>


== convention de noms ==
== General architecture diagram SQWareRepository (when the SQWareProduction module is locally installed) ==
Tous les objets sont nommés avec des préfixes:
[[Image:General_SQWareRepository.jpg]]
* tsqw_% : pour les tables
 
* isqw_% : pour les index
== naming convention ==
* isqw_%_u : pour les index uniques
All generic objects are named with prefixes:
* isqw_%_pk : pour les primary key
* tsqw_% : for tables
* isqw_% : for index
* isqw_%_u : for uniques
* isqw_%_pk : for primary key
<br>
{{Warning_objets}}
{{Warning_objets}}
<br>
<br>
== Generic database content (for all dbms) ==
{{SQWareRepositoryTables|tsqw_AdminGroups|
<nowiki>...</nowiki>|
<pre>
Field Type
id_grp bigint(20)
groupname varchar(30)
dbaname varchar(50)
comments varchar(50)
upd_date datetime
</pre>
}}
{{SQWareRepositoryTables|tsqw_AdminGroupsPrivs|
<nowiki>...</nowiki>|
<pre>
Field Type
id_grp_grantee bigint(20)
id_grp_granted bigint(20)
dbaname varchar(50)
comments varchar(50)
upd_date datetime
</pre>
}}
{{SQWareRepositoryTables|tsqw_AdminLogins|
<nowiki>...</nowiki>|
<pre>
Field Type
id_usr bigint(20)
username varchar(30)
lastname varchar(255)
firstname varchar(255)
passwd char(40)
cre_date datetime
pwd_date datetime
dbaname varchar(50)
comments varchar(50)
upd_date datetime
</pre>
}}
{{SQWareRepositoryTables|tsqw_AdminLoginsPrivs|
<nowiki>...</nowiki>|
<pre>
Field Type
id_usr_grantee bigint(20)
id_grp_granted bigint(20)
dbaname varchar(50)
comments varchar(50)
upd_date datetime
</pre>
}}
{{SQWareRepositoryTables|tsqw_AdminTypes|
<nowiki>...</nowiki>|
<pre>
Field Type
id_type bigint(20)
typename varchar(30)
dbaname varchar(50)
comments varchar(50)
upd_date datetime
</pre>
}}
{{SQWareRepositoryTables|tsqw_AdminTypesPrivs|
<nowiki>...</nowiki>|
<pre>
Field Type
id_grp_grantee bigint(20)
id_type_granted bigint(20)
dbaname varchar(50)
comments varchar(50)
upd_date datetime
</pre>
}}
{{SQWareRepositoryTables|tsqw_AlertFile|
<nowiki>...</nowiki>|
<pre>
Field Type
dbalias varchar(80)
gather_date datetime
alert_file varchar(800)
</pre>
}}
{{SQWareRepositoryTables|tsqw_EndLife|
<nowiki>...</nowiki>|
<pre>
Field Type
rdbmstype varchar(50)
maj_version int(11)
releasedate datetime
premier datetime
extended datetime
</pre>
}}
{{SQWareRepositoryTables|tsqw_GenHisto|
<nowiki>...</nowiki>|
<pre>
Field Type
dbalias varchar(80)
month datetime
gather_date datetime
rdbmstype varchar(50)
size_instance decimal(12,2)
used decimal(12,2)
free decimal(12,2)
maj_version int(11)
version varchar(30)
client varchar(60)
env varchar(12)
</pre>
}}
{{SQWareRepositoryTables|tsqw_GenInfosLicense|
<nowiki>...</nowiki>|
<pre>
Field Type
dbalias varchar(80)
gather_date datetime
host_name varchar(64)
cpu_count int(11)
port_string varchar(255)
banner varchar(255)
os_type varchar(255)
</pre>
}}
{{SQWareRepositoryTables|tsqw_GenInstance|
<nowiki>...</nowiki>|
<pre>
Field Type
dbalias varchar(80)
gather_date datetime
size_instance decimal(12,2)
used decimal(12,2)
free decimal(12,2)
maj_version int(11)
version varchar(30)
</pre>
}}
{{SQWareRepositoryTables|tsqw_JobsExec|
<nowiki>...</nowiki>|
<pre>
Field Type
log_ide bigint(20)
log_id bigint(20)
dbalias varchar(80)
beginning datetime
script varchar(80)
parameters varchar(400)
end datetime
duration char(8)
status int(11)
</pre>
}}
{{SQWareRepositoryTables|tsqw_JobsLog|
<nowiki>...</nowiki>|
<pre>
Field Type
log_id bigint(20)
log_file text
</pre>
}}
{{SQWareRepositoryTables|tsqw_RdbmsType|
<nowiki>...</nowiki>|
<pre>
Field Type
rdbmstype varchar(50)
rdbmsname varchar(50)
rdbmstrigram varchar(50)
rdbmsroot varchar(50)
</pre>
}}
{{SQWareRepositoryTables|tsqw_Repository|
<nowiki>...</nowiki>|
<pre>
Field Type
dbalias varchar(80)
rdbmstype varchar(50)
virt_host_name varchar(64)
host_name varchar(64)
username varchar(60)
port int(11)
comments varchar(500)
contact varchar(100)
status varchar(10)
client varchar(60)
upd_date datetime
env varchar(12)
globalhost varchar(255)
custom1 varchar(255)
custom2 varchar(255)
</pre>
}}
{{SQWareRepositoryTables|tsqw_RepositoryExclude|
<nowiki>...</nowiki>|
<pre>
Field Type
trtname varchar(80)
dbalias varchar(80)
rdbmstype varchar(50)
dbaname varchar(50)
comments varchar(50)
upd_date datetime
</pre>
}}
{{SQWareRepositoryTables|tsqw_RepositoryFiles|
<nowiki>...</nowiki>|
<pre>
Field Type
filename varchar(700)
upd_date datetime
status int(11)
comments varchar(4000)
</pre>
}}
{{SQWareRepositoryTables|tsqw_RepositoryInclude|
<nowiki>...</nowiki>|
<pre>
Field Type
trtname varchar(80)
dbalias varchar(80)
rdbmstype varchar(50)
dbaname varchar(50)
comments varchar(50)
upd_date datetime
</pre>
}}
{{SQWareRepositoryTables|tsqw_RepositoryNoSQL|
<nowiki>...</nowiki>|
<pre>
Field Type
dbalias varchar(80)
nodename varchar(80)
rdbmstype varchar(50)
virt_host_name varchar(64)
host_name varchar(64)
username varchar(60)
port int(11)
ruletype varchar(50)
commands varchar(500)
comments varchar(500)
upd_date datetime
globalhost varchar(255)
custom1 varchar(255)
custom2 varchar(255)
</pre>
}}
{{SQWareRepositoryTables|tsqw_RepositoryOther|
<nowiki>...</nowiki>|
<pre>
Field Type
dbalias varchar(80)
rdbmstype varchar(50)
virt_host_name varchar(64)
host_name varchar(64)
username varchar(60)
port int(11)
comments varchar(500)
contact varchar(100)
status varchar(10)
client varchar(60)
upd_date datetime
env varchar(12)
globalhost varchar(255)
custom1 varchar(255)
custom2 varchar(255)
</pre>
}}
{{SQWareRepositoryTables|tsqw_RepositoryVersion|
<nowiki>...</nowiki>|
<pre>
Field Type
upd_date timestamp
rdbmstype varchar(50)
action varchar(32)
version varchar(17)
status int(11)
comments varchar(255)
</pre>
}}
{{SQWareRepositoryTables|tsqw_UserSsh|
<nowiki>...</nowiki>|
<pre>
Field Type
dbalias varchar(80)
username varchar(60)
status varchar(10)
</pre>
}}
{{SQWareRepositoryTables|tsqw_VolBackups|
<nowiki>...</nowiki>|
<pre>
Field Type
dbalias varchar(80)
database_name varchar(255)
beginning datetime
bck_type varchar(250)
tools varchar(250)
end_trt datetime
duration char(8)
size_bck decimal(12,2)
</pre>
}}
{{SQWareRepositoryTables|tsqw_VolBackupsExclude|
<nowiki>...</nowiki>|
<pre>
Field Type
dbalias varchar(80)
rdbmstype varchar(50)
dbaname varchar(50)
comments varchar(50)
upd_date datetime
</pre>
}}
{{SQWareRepositoryTables|tsqw_VolBackupsExcludeDb|
<nowiki>...</nowiki>|
<pre>
Field Type
dbalias varchar(80)
database_name varchar(255)
rdbmstype varchar(50)
dbaname varchar(50)
comments varchar(50)
upd_date datetime
</pre>
}}
{{SQWareRepositoryTables|tsqw_VolBackupsExcludeGlobalDb|
<nowiki>...</nowiki>|
<pre>
Field Type
database_name varchar(255)
rdbmstype varchar(50)
dbaname varchar(50)
comments varchar(50)
upd_date datetime
</pre>
}}
{{SQWareRepositoryTables|tsqw_VolFS|
<nowiki>...</nowiki>|
<pre>
Field Type
dbalias varchar(80)
gather_date datetime
host_name varchar(64)
filesystem varchar(200)
size_fs decimal(12,2)
used decimal(12,2)
free decimal(12,2)
rate decimal(12,2)
mount varchar(200)
</pre>
}}
{{SQWareRepositoryTables|tsqw_VolTapeBackups|
<nowiki>...</nowiki>|
<pre>
Field Type
dbalias varchar(80)
hostname varchar(30)
beginning datetime
parameters varchar(255)
tools varchar(250)
end_trt datetime
duration char(8)
size_bck decimal(12,2)
nbfiles decimal(12,2)
</pre>
}}
{{SQWareRepositoryTables|tsqw_VolThreshold|
<nowiki>...</nowiki>|
<pre>
Field Type
voltype varchar(50)
dbalias varchar(80)
rdbmstype varchar(50)
objname varchar(255)
threshold_c int(11)
threshold_w int(11)
dbaname varchar(50)
comments varchar(50)
upd_date datetime
</pre>
}}
{{SQWareRepositoryTables|tsqw_VolThresholdDef|
<nowiki>...</nowiki>|
<pre>
Field Type
voltype varchar(50)
size_limit int(11)
rdbmstype varchar(50)
threshold_c int(11)
threshold_w int(11)
dbaname varchar(50)
comments varchar(50)
upd_date datetime
</pre>
}}

Latest revision as of 20:14, 22 December 2017

Presentation

SQWareRepository, is the repository module, and stores rdbms indicators.
It manage the repository and the database indicators ...

This module has is managed in a MySql database.

Links to different plugins of SQWareRepository module :

Installation guide for SQWareRepository

General architecture diagram SQWareRepository (when the SQWareProduction module is locally installed)

naming convention

All generic objects are named with prefixes:

  • tsqw_% : for tables
  • isqw_% : for index
  • isqw_%_u : for uniques
  • isqw_%_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.


Generic database content (for all dbms)

tsqw_AdminGroups

This table contains : ...
Desc of tsqw_AdminGroups :

Field Type
id_grp bigint(20)
groupname varchar(30)
dbaname varchar(50)
comments varchar(50)
upd_date datetime


tsqw_AdminGroupsPrivs

This table contains : ...
Desc of tsqw_AdminGroupsPrivs :

Field Type
id_grp_grantee bigint(20)
id_grp_granted bigint(20)
dbaname varchar(50)
comments varchar(50)
upd_date datetime


tsqw_AdminLogins

This table contains : ...
Desc of tsqw_AdminLogins :

Field Type
id_usr bigint(20)
username varchar(30)
lastname varchar(255)
firstname varchar(255)
passwd char(40)
cre_date datetime
pwd_date datetime
dbaname varchar(50)
comments varchar(50)
upd_date datetime


tsqw_AdminLoginsPrivs

This table contains : ...
Desc of tsqw_AdminLoginsPrivs :

Field Type
id_usr_grantee bigint(20)
id_grp_granted bigint(20)
dbaname varchar(50)
comments varchar(50)
upd_date datetime


tsqw_AdminTypes

This table contains : ...
Desc of tsqw_AdminTypes :

Field Type
id_type bigint(20)
typename varchar(30)
dbaname varchar(50)
comments varchar(50)
upd_date datetime


tsqw_AdminTypesPrivs

This table contains : ...
Desc of tsqw_AdminTypesPrivs :

Field Type
id_grp_grantee bigint(20)
id_type_granted bigint(20)
dbaname varchar(50)
comments varchar(50)
upd_date datetime


tsqw_AlertFile

This table contains : ...
Desc of tsqw_AlertFile :

Field Type
dbalias varchar(80)
gather_date datetime
alert_file varchar(800)


tsqw_EndLife

This table contains : ...
Desc of tsqw_EndLife :

Field Type
rdbmstype varchar(50)
maj_version int(11)
releasedate datetime
premier datetime
extended datetime


tsqw_GenHisto

This table contains : ...
Desc of tsqw_GenHisto :

Field Type
dbalias varchar(80)
month datetime
gather_date datetime
rdbmstype varchar(50)
size_instance decimal(12,2)
used decimal(12,2)
free decimal(12,2)
maj_version int(11)
version varchar(30)
client varchar(60)
env varchar(12)


tsqw_GenInfosLicense

This table contains : ...
Desc of tsqw_GenInfosLicense :

Field Type
dbalias varchar(80)
gather_date datetime
host_name varchar(64)
cpu_count int(11)
port_string varchar(255)
banner varchar(255)
os_type varchar(255)


tsqw_GenInstance

This table contains : ...
Desc of tsqw_GenInstance :

Field Type
dbalias varchar(80)
gather_date datetime
size_instance decimal(12,2)
used decimal(12,2)
free decimal(12,2)
maj_version int(11)
version varchar(30)


tsqw_JobsExec

This table contains : ...
Desc of tsqw_JobsExec :

Field Type
log_ide bigint(20)
log_id bigint(20)
dbalias varchar(80)
beginning datetime
script varchar(80)
parameters varchar(400)
end datetime
duration char(8)
status int(11)


tsqw_JobsLog

This table contains : ...
Desc of tsqw_JobsLog :

Field Type
log_id bigint(20)
log_file text


tsqw_RdbmsType

This table contains : ...
Desc of tsqw_RdbmsType :

Field Type
rdbmstype varchar(50)
rdbmsname varchar(50)
rdbmstrigram varchar(50)
rdbmsroot varchar(50)


tsqw_Repository

This table contains : ...
Desc of tsqw_Repository :

Field Type
dbalias varchar(80)
rdbmstype varchar(50)
virt_host_name varchar(64)
host_name varchar(64)
username varchar(60)
port int(11)
comments varchar(500)
contact varchar(100)
status varchar(10)
client varchar(60)
upd_date datetime
env varchar(12)
globalhost varchar(255)
custom1 varchar(255)
custom2 varchar(255)


tsqw_RepositoryExclude

This table contains : ...
Desc of tsqw_RepositoryExclude :

Field Type
trtname varchar(80)
dbalias varchar(80)
rdbmstype varchar(50)
dbaname varchar(50)
comments varchar(50)
upd_date datetime


tsqw_RepositoryFiles

This table contains : ...
Desc of tsqw_RepositoryFiles :

Field Type
filename varchar(700)
upd_date datetime
status int(11)
comments varchar(4000)


tsqw_RepositoryInclude

This table contains : ...
Desc of tsqw_RepositoryInclude :

Field Type
trtname varchar(80)
dbalias varchar(80)
rdbmstype varchar(50)
dbaname varchar(50)
comments varchar(50)
upd_date datetime


tsqw_RepositoryNoSQL

This table contains : ...
Desc of tsqw_RepositoryNoSQL :

Field Type
dbalias varchar(80)
nodename varchar(80)
rdbmstype varchar(50)
virt_host_name varchar(64)
host_name varchar(64)
username varchar(60)
port int(11)
ruletype varchar(50)
commands varchar(500)
comments varchar(500)
upd_date datetime
globalhost varchar(255)
custom1 varchar(255)
custom2 varchar(255)


tsqw_RepositoryOther

This table contains : ...
Desc of tsqw_RepositoryOther :

Field Type
dbalias varchar(80)
rdbmstype varchar(50)
virt_host_name varchar(64)
host_name varchar(64)
username varchar(60)
port int(11)
comments varchar(500)
contact varchar(100)
status varchar(10)
client varchar(60)
upd_date datetime
env varchar(12)
globalhost varchar(255)
custom1 varchar(255)
custom2 varchar(255)


tsqw_RepositoryVersion

This table contains : ...
Desc of tsqw_RepositoryVersion :

Field Type
upd_date timestamp
rdbmstype varchar(50)
action varchar(32)
version varchar(17)
status int(11)
comments varchar(255)


tsqw_UserSsh

This table contains : ...
Desc of tsqw_UserSsh :

Field Type
dbalias varchar(80)
username varchar(60)
status varchar(10)


tsqw_VolBackups

This table contains : ...
Desc of tsqw_VolBackups :

Field Type
dbalias varchar(80)
database_name varchar(255)
beginning datetime
bck_type varchar(250)
tools varchar(250)
end_trt datetime
duration char(8)
size_bck decimal(12,2)


tsqw_VolBackupsExclude

This table contains : ...
Desc of tsqw_VolBackupsExclude :

Field Type
dbalias varchar(80)
rdbmstype varchar(50)
dbaname varchar(50)
comments varchar(50)
upd_date datetime


tsqw_VolBackupsExcludeDb

This table contains : ...
Desc of tsqw_VolBackupsExcludeDb :

Field Type
dbalias varchar(80)
database_name varchar(255)
rdbmstype varchar(50)
dbaname varchar(50)
comments varchar(50)
upd_date datetime


tsqw_VolBackupsExcludeGlobalDb

This table contains : ...
Desc of tsqw_VolBackupsExcludeGlobalDb :

Field Type
database_name varchar(255)
rdbmstype varchar(50)
dbaname varchar(50)
comments varchar(50)
upd_date datetime


tsqw_VolFS

This table contains : ...
Desc of tsqw_VolFS :

Field Type
dbalias varchar(80)
gather_date datetime
host_name varchar(64)
filesystem varchar(200)
size_fs decimal(12,2)
used decimal(12,2)
free decimal(12,2)
rate decimal(12,2)
mount varchar(200)


tsqw_VolTapeBackups

This table contains : ...
Desc of tsqw_VolTapeBackups :

Field Type
dbalias varchar(80)
hostname varchar(30)
beginning datetime
parameters varchar(255)
tools varchar(250)
end_trt datetime
duration char(8)
size_bck decimal(12,2)
nbfiles decimal(12,2)


tsqw_VolThreshold

This table contains : ...
Desc of tsqw_VolThreshold :

Field Type
voltype varchar(50)
dbalias varchar(80)
rdbmstype varchar(50)
objname varchar(255)
threshold_c int(11)
threshold_w int(11)
dbaname varchar(50)
comments varchar(50)
upd_date datetime


tsqw_VolThresholdDef

This table contains : ...
Desc of tsqw_VolThresholdDef :

Field Type
voltype varchar(50)
size_limit int(11)
rdbmstype varchar(50)
threshold_c int(11)
threshold_w int(11)
dbaname varchar(50)
comments varchar(50)
upd_date datetime
Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareRepository:general&oldid=9196"