Difference between revisions of "SQWareRepository:teradata"
Expdbtools (talk | contribs) |
Expdbtools (talk | contribs) |
||
| Line 1: | Line 1: | ||
{{SQWareRepositoryPresSgbd|Teradata|schema|instances|ter}} | {{SQWareRepositoryPresSgbd|Teradata|schema|instances|ter}} | ||
== Specific database content for Teradata == | == Specific database content for Teradata == | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwter_VolDb| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | 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) | ||
| + | </pre> | ||
| + | }} | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwter_VolTables| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | 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) | ||
| + | </pre> | ||
| + | }} | ||
Latest revision as of 19:17, 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 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)
