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. Supports 512 characters. |
Language |
varchar(30) |
Allows you to specify the language in which the SAP ASE server returns the values of the Description column. By default, the SAP ASE server returns US English. Queries must use the the IS0-639 and ISO-3166 naming conventions. |