SQWareRepository:general

From Wiki_dbSQWare
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 :

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