SQWareRepository:general

From Wiki_dbSQWare
Revision as of 19:11, 22 December 2017 by Expdbtools (talk | contribs) (General architecture diagram SQWareRepository™ (when the SQWareProduction™ module is locally installed))
Jump to: navigation, search

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 :

Download the latest stable versions
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