Difference between revisions of "SQWareRepository:sybase"
Expdbtools (talk | contribs) (Replaced content with '{{SQWareRepositoryPresSgbd|Sybase|database|dataservers|syb}} == Specific database content for Sybase ==') |
Expdbtools (talk | contribs) |
||
| Line 1: | Line 1: | ||
{{SQWareRepositoryPresSgbd|Sybase|database|dataservers|syb}} | {{SQWareRepositoryPresSgbd|Sybase|database|dataservers|syb}} | ||
== Specific database content for Sybase == | == Specific database content for Sybase == | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwsyb_GenInfos| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | Field Type | ||
| + | gather_date datetime | ||
| + | dbalias varchar(80) | ||
| + | size_ds decimal(12,2) | ||
| + | used decimal(12,2) | ||
| + | version varchar(35) | ||
| + | unix varchar(20) | ||
| + | memory int(11) | ||
| + | nblogins int(11) | ||
| + | nbdb int(11) | ||
| + | nbengines int(11) | ||
| + | nbmaxdevices int(11) | ||
| + | nbdevices int(11) | ||
| + | nbmaxlocks int(11) | ||
| + | nbmaxconnections int(11) | ||
| + | unixversion varchar(250) | ||
| + | </pre> | ||
| + | }} | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwsyb_Parameters| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | Field Type | ||
| + | dbalias varchar(80) | ||
| + | gather_date datetime | ||
| + | name varchar(255) | ||
| + | value varchar(255) | ||
| + | isdefault varchar(9) | ||
| + | </pre> | ||
| + | }} | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwsyb_VolDb| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | Field Type | ||
| + | gather_date datetime | ||
| + | dbalias varchar(80) | ||
| + | database_name varchar(255) | ||
| + | size_db decimal(12,2) | ||
| + | used decimal(12,2) | ||
| + | sizelog decimal(12,2) | ||
| + | owner varchar(30) | ||
| + | options varchar(4000) | ||
| + | </pre> | ||
| + | }} | ||
| + | |||
| + | {{SQWareRepositoryTables|tsqwsyb_VolTables| | ||
| + | <nowiki>...</nowiki>| | ||
| + | <pre> | ||
| + | Field Type | ||
| + | dbalias varchar(80) | ||
| + | gather_date datetime | ||
| + | database_name varchar(255) | ||
| + | owner varchar(255) | ||
| + | tablename varchar(255) | ||
| + | rows decimal(12,0) | ||
| + | reserved decimal(12,2) | ||
| + | data decimal(12,2) | ||
| + | index_size decimal(12,2) | ||
| + | unused decimal(12,2) | ||
| + | </pre> | ||
| + | }} | ||
Latest revision as of 18: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 tsqwsyb_% or isqwsyb_% are specific for Sybase.
Installation guide for SQWareRepository for Sybase
Naming convention
All specific objects for Sybase are named with prefixes:
- tsqwsyb_% : for tables
- isqwsyb_% : for index
- isqwsyb_%_u : for uniques
- isqwsyb_%_pk : for primary key
Specific database content for Sybase
tsqwsyb_GenInfos
This table contains :
...
Desc of tsqwsyb_GenInfos :
Field Type gather_date datetime dbalias varchar(80) size_ds decimal(12,2) used decimal(12,2) version varchar(35) unix varchar(20) memory int(11) nblogins int(11) nbdb int(11) nbengines int(11) nbmaxdevices int(11) nbdevices int(11) nbmaxlocks int(11) nbmaxconnections int(11) unixversion varchar(250)
tsqwsyb_Parameters
This table contains :
...
Desc of tsqwsyb_Parameters :
Field Type dbalias varchar(80) gather_date datetime name varchar(255) value varchar(255) isdefault varchar(9)
tsqwsyb_VolDb
This table contains :
...
Desc of tsqwsyb_VolDb :
Field Type gather_date datetime dbalias varchar(80) database_name varchar(255) size_db decimal(12,2) used decimal(12,2) sizelog decimal(12,2) owner varchar(30) options varchar(4000)
tsqwsyb_VolTables
This table contains :
...
Desc of tsqwsyb_VolTables :
Field Type dbalias varchar(80) gather_date datetime database_name varchar(255) owner varchar(255) tablename varchar(255) rows decimal(12,0) reserved decimal(12,2) data decimal(12,2) index_size decimal(12,2) unused decimal(12,2)
