SQWareRepository:ingres

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 tsqwing_% or isqwing_% are specific for Ingres.
Installation guide for SQWareRepository for Ingres

Naming convention

All specific objects for Ingres are named with prefixes:

• tsqwing_% : for tables
• isqwing_% : for index
• isqwing_%_u : for uniques
• isqwing_%_pk : for primary key

Specific database content for Ingres

tsqwing_VolDb

This table contains : ...
Desc of tsqwing_VolDb :

Field Type
dbalias varchar(80)
database_name varchar(80)
gather_date datetime
size_db decimal(12,2)