Difference between revisions of "SQWareRepository:db2"
Expdbtools (talk | contribs) (Replaced content with '{{SQWareRepositoryPresSgbd|DB2|database|instances|db2}} == Specific database content for DB2 ==') |
Expdbtools (talk | contribs) |
||
| Line 1: | Line 1: | ||
{{SQWareRepositoryPresSgbd|DB2|database|instances|db2}} | {{SQWareRepositoryPresSgbd|DB2|database|instances|db2}} | ||
== Specific database content for DB2 == | == Specific database content for DB2 == | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwdb2_Parameters| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | Field Type | ||
| + | dbalias varchar(80) | ||
| + | gather_date date | ||
| + | name varchar(255) | ||
| + | value varchar(255) | ||
| + | </pre> | ||
| + | }} | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwdb2_VolDb| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | Field Type | ||
| + | dbalias varchar(80) | ||
| + | gather_date date | ||
| + | size_db decimal(12,2) | ||
| + | max_size_db decimal(12,2) | ||
| + | </pre> | ||
| + | }} | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwdb2_VolSchema| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | 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) | ||
| + | </pre> | ||
| + | }} | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwdb2_VolTables| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | 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) | ||
| + | </pre> | ||
| + | }} | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwdb2_VolTbs| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | 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) | ||
| + | </pre> | ||
| + | }} | ||
Latest revision as of 19:08, 8 August 2015
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)
