Provides a description of all monitoring tables. You can join monTables with monTableColumns for a description of each monitoring table and the columns it contains.
The metadata view for this table is identical for all instances in a shared-disk cluster.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monTables are:
Name |
Datatype |
Attributes |
Description |
---|---|---|---|
TableID |
int |
Unique identifier for the table |
|
Columns |
tinyint |
Total number of columns in the table |
|
Parameters |
tinyint |
Total number of optional parameters you can specify |
|
Indicators |
int |
Indicators for specific table properties (for example, if the table retains session context) The Indicators column is a bit map. Use a bitmask to to determine which bits are turned on. A value of 1 indicates the table is a historical table. To display all tables that are historical: Select TableName from master..monTables where Indicators & 1 != 0 |
|
Size |
int |
Maximum row size (in bytes) |
|
TableName |
varchar(30) |
Null |
Table name |
Description |
varchar(368) |
Null |
Table description |
Language |
varchar(30) |
Allows you to specify the language in which Adaptive Server returns the values of the Description column. By default, Adaptive Server returns US English. Queries must use the the IS0-639 and ISO-3166 naming conventions. |