monTableCompression

Description

Contains the table’s compression history. Enable the enable monitoring and per object statistics active configuration parameters for this monitoring table to collect data.

Columns

The columns for monTableCompression are:

Name	Datatype	Attributes	Description
InstanceID	int		(Cluster Edition only) Server instance ID
DBID	int		ID of the database to which this table was transferred
TableID	int		Table ID of the compressed table
PartitionID	int		ID of the compressed partition
TableName	varchar	statnull	Name of the compressed table
CompRowInserted	int	Counter, monitor	Number of compressed rows inserted
CompRowUpdated	int	Counter, monitor	Number of updated compressed rows
CompRowForward	int	Counter, monitor	Number of compressed rows forwarded from the update
CompRowScan	int	Counter, monitor	Number of compressed rows accessed
RowPageDecompressed	int		Number of page-compressed rows decompressed to be row-compressed
RowDecompressed	int	Counter, monitor	Number of rows decompressed
ColDecompressed	int	Counter, monitor	Number of columns decompressed
RowCompNoneed	int	Counter, statnull	Number of rows not compressed because their compressed row length exceeded their normal row length
PageCompNoneed	int	Counter, statnull	Number of pages that are not suitable for page-level compression because Adaptive Server cannot generate a dictionary or index
PagesCompressed	int	Counter, monitor	Number of pages compressed at the page-level
BytesSavedPageLevel	int	Counter, monitor	Number of bytes page level compression saved