SQWareRepository:teradata

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 tsqwter_% or isqwter_% are specific for Teradata.
Installation guide for SQWareRepository for Teradata

Naming convention

All specific objects for Teradata are named with prefixes:

• tsqwter_% : for tables
• isqwter_% : for index
• isqwter_%_u : for uniques
• isqwter_%_pk : for primary key

Specific database content for Teradata

tsqwter_VolDb

This table contains : ...
Desc of tsqwter_VolDb :

Field Type
dbalias varchar(80)
database_name varchar(255)
gather_date datetime
size_db decimal(12,2)
used decimal(12,2)
free decimal(12,2)
maxsize decimal(12,2)
pctusedmax decimal(12,2)
freeavailablemax decimal(12,2)

tsqwter_VolTables

This table contains : ...
Desc of tsqwter_VolTables :

Field Type
dbalias varchar(80)
gather_date datetime
database_name varchar(255)
table_name varchar(255)
size_tbl decimal(12,2)
used decimal(12,2)
free decimal(12,2)
peakperm decimal(12,2)
skewfactor decimal(12,2)