SQWareRepository:db2
Revision as of 18:08, 8 August 2015 by Expdbtools (talk | contribs)
Contents
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 tsqwdb2_% or isqwdb2_% are specific for DB2.
Installation guide for SQWareRepository for DB2
Naming convention
All specific objects for DB2 are named with prefixes:
- tsqwdb2_% : for tables
- isqwdb2_% : for index
- isqwdb2_%_u : for uniques
- isqwdb2_%_pk : for primary key
Specific database content for DB2
tsqwdb2_Parameters
This table contains :
...
Desc of tsqwdb2_Parameters :
Field Type dbalias varchar(80) gather_date date name varchar(255) value varchar(255)
tsqwdb2_VolDb
This table contains :
...
Desc of tsqwdb2_VolDb :
Field Type dbalias varchar(80) gather_date date size_db decimal(12,2) max_size_db decimal(12,2)
tsqwdb2_VolSchema
This table contains :
...
Desc of tsqwdb2_VolSchema :
Field Type dbalias varchar(80) gather_date date table_schema varchar(64) size_sch decimal(12,2) data_length decimal(12,2) index_length decimal(12,2)
tsqwdb2_VolTables
This table contains :
...
Desc of tsqwdb2_VolTables :
Field Type dbalias varchar(80) gather_date date table_schema varchar(64) table_name varchar(64) data_length decimal(12,2) index_length decimal(12,2)
tsqwdb2_VolTbs
This table contains :
...
Desc of tsqwdb2_VolTbs :
Field Type dbalias varchar(80) tablespace_name varchar(80) gather_date date size_tbs decimal(12,2) used decimal(12,2) free decimal(12,2)