SQWareRepository:db2

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


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 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)