SQWareRepository:teradata: Difference between revisions
Jump to navigation
Jump to search
Created page with '{{SQWareRepositoryPresSgbd|Teradata|schema|instances|ter}} == Schema content == {{SQWareRepositoryTables|tsqw_Repository| <nowiki>Instance repository</nowiki>| <pre> /* Instance …' |
No edit summary |
||
| (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
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)