SQWareRepository:sybase

From wiki_dbSQWare_3.1
Jump to: navigation, search

Presentation

It is the repository module, and stores rdbms indicators for all RDBMS.
It is a MySQL database.
Objects prefix by tsqw_% or isqw_% are generic.
Objects prefix by tsqwsyb_% or isqwsyb_% are specific for Sybase.
Installation guide for SQWareRepository™ for Sybase

Naming convention

All specific objects for Sybase are named with prefixes:

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


Specific database content for Sybase

tsqwsyb_GenInfos

This table contains : ...
Desc of tsqwsyb_GenInfos :

Field Type
gather_date datetime
dbalias varchar(80)
size_ds decimal(12,2)
used decimal(12,2)
version varchar(35)
unix varchar(20)
memory int(11)
nblogins int(11)
nbdb int(11)
nbengines int(11)
nbmaxdevices int(11)
nbdevices int(11)
nbmaxlocks int(11)
nbmaxconnections int(11)
unixversion varchar(250)


tsqwsyb_Parameters

This table contains : ...
Desc of tsqwsyb_Parameters :

Field Type
dbalias varchar(80)
gather_date datetime
name varchar(255)
value varchar(255)
isdefault varchar(9)


tsqwsyb_VolDb

This table contains : ...
Desc of tsqwsyb_VolDb :

Field Type
gather_date datetime
dbalias varchar(80)
database_name varchar(255)
size_db decimal(12,2)
used decimal(12,2)
sizelog decimal(12,2)
owner varchar(30)
options varchar(4000)


tsqwsyb_VolTables

This table contains : ...
Desc of tsqwsyb_VolTables :

Field Type
dbalias varchar(80)
gather_date datetime
database_name varchar(255)
owner varchar(255)
tablename varchar(255)
rows decimal(12,0)
reserved decimal(12,2)
data decimal(12,2)
index_size decimal(12,2)
unused decimal(12,2)