Difference between revisions of "SQWareRepository:general"

From Wiki_dbSQWare
Jump to: navigation, search
(→‎Presentation)
 
(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 19: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)

General SQWareRepository.jpg

naming convention

All generic objects are named with prefixes:

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


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"