Difference between revisions of "SQWareRepository:general"

From Wiki_dbSQWare
Jump to: navigation, search
(→‎Presentation)
(→‎Presentation)
 
(11 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
== Presentation ==
 
== Presentation ==
−
SQWareRepository™, also known technically as SQWareRepository®, is the repository module, and stores rdbms indicators.<br>
+
SQWareRepository, is the repository module, and stores rdbms indicators.<br>
−
It manage the repository and the database indicators (this is actually a schema or database)..<br>
+
It manage the repository and the database indicators ...<br>
 
<br>
 
<br>
−
This module has one part per RDBMS managed. There is no 'core' part, each type of RDBMS is independent.
+
This module has is managed in a MySql database.<br>
−
There is still a consistency between all these MCD, you will find for example the referential table tsqw_Repository in each.<br>
 
−
Each scheme is managed in the same type of RDBMS that managed to avoid client deployment problem (Oracle in Oracle, Sybase, Sybase ...). One exemption is Ingres, Ingres indicators are managed in a MySql database.<br>
 
 
<br>
 
<br>
−
Links to different plugins of SQWareRepository™ module :
+
Links to different plugins of SQWareRepository module :
 
*[[SQWareRepository:oracle|Oracle plugins]]
 
*[[SQWareRepository:oracle|Oracle plugins]]
 
*[[SQWareRepository:sybase|Sybase plugins]]
 
*[[SQWareRepository:sybase|Sybase plugins]]
 
*[[SQWareRepository:mysql|Mysql plugins]]
 
*[[SQWareRepository:mysql|Mysql plugins]]
 
*[[SQWareRepository:mssql|Mssql plugins]]
 
*[[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]]
 
*[[SQWareRepository:ingres|Ingres plugins]]
−
[[Downloads|Download the latest stable versions]]<br>
+
[[Installation#SQWareRepository | Installation guide for SQWareRepository]]<br>
 
<br>
 
<br>
 +
 +
== General architecture diagram SQWareRepository (when the SQWareProduction module is locally installed) ==
 +
[[Image:General_SQWareRepository.jpg]]
  
 
== naming convention ==
 
== naming convention ==
−
All objects are named with prefixes:
+
All generic objects are named with prefixes:
 
* tsqw_% : for tables
 
* tsqw_% : for tables
 
* isqw_% : for index
 
* isqw_% : for index
Line 25: Line 32:
 
{{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"