Difference between revisions of "SQWareRepository:teradata"
Expdbtools (talk | contribs) (Created page with '{{SQWareRepositoryPresSgbd|Teradata|schema|instances|ter}} == Schema content == {{SQWareRepositoryTables|tsqw_Repository| <nowiki>Instance repository</nowiki>| <pre> /* Instance …') |
Expdbtools (talk | contribs) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{SQWareRepositoryPresSgbd|Teradata|schema|instances|ter}} | {{SQWareRepositoryPresSgbd|Teradata|schema|instances|ter}} | ||
| − | == | + | == Specific database content for Teradata == |
| − | {{SQWareRepositoryTables| | + | |
| − | <nowiki> | + | {{SQWareRepositoryTables|tsqwter_VolDb| |
| + | <nowiki>...</nowiki>| | ||
<pre> | <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> | </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)
