Each row represents a data partition. Note that the data partition statistics represent one database partition if the table is created on multiple database partitions.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
DATAPARTITIONNAME | VARCHAR (128) | Name of the data partition. | |
TABSCHEMA | VARCHAR (128) | Schema name of the table to which this data partition belongs. | |
TABNAME | VARCHAR (128) | Unqualified name of the table to which this data partition belongs. | |
DATAPARTITIONID | INTEGER | Identifier for the data partition. | |
TBSPACEID | INTEGER | Y | Identifier for the table space in which this data partition is stored. The null value when STATUS is 'I'. |
PARTITIONOBJECTID | INTEGER | Y | Identifier for the data partition within the table space. |
LONG_TBSPACEID | INTEGER | Y | Identifier for the table space in which long data is stored. The null value when STATUS is 'I'. |
ACCESS_MODE | CHAR (1) | Access restriction state of the data partition. These states
only apply to objects that are in set integrity pending state or
to objects that were processed by a SET INTEGRITY statement. Possible
values are:
|
|
STATUS | VARCHAR (32) |
|
|
SEQNO | INTEGER | Data partition sequence number (starting from 0). | |
LOWINCLUSIVE | CHAR (1) |
|
|
LOWVALUE | VARCHAR (512) | Low key value (a string representation of an SQL value) for this data partition. | |
HIGHINCLUSIVE | CHAR (1) |
|
|
HIGHVALUE | VARCHAR (512) | High key value (a string representation of an SQL value) for this data partition. | |
CARD | BIGINT | Total number of rows in the data partition; -1 if statistics are not collected. | |
OVERFLOW | BIGINT | Total number of overflow records in the data partition; -1 if statistics are not collected. | |
NPAGES | BIGINT | Total number of pages on which the rows of the data partition exist; -1 if statistics are not collected. | |
FPAGES | BIGINT | Total number of pages in the data partition; -1 if statistics are not collected. | |
ACTIVE_BLOCKS | BIGINT | Total number of active blocks in the data partition, or -1. Applies to multidimensional clustering (MDC) tables only. | |
INDEX_TBSPACEID | INTEGER | Identifier for the table space which holds all partitioned indexes for this data partition. | |
AVGROWSIZE | SMALLINT | Average length (in bytes) of both compressed and uncompressed rows in this data partition; -1 if statistics are not collected. | |
PCTROWSCOMPRESSED | REAL | Compressed rows as a percentage of the total number of rows in the data partition; -1 if statistics are not collected. | |
PCTPAGESAVED | SMALLINT | Approximate percentage of pages saved in the data partition as a result of row compression. This value includes overhead bytes for each user data row in the data partition, but does not include the space that is consumed by dictionary overhead; -1 if statistics are not collected. | |
AVGCOMPRESSEDROWSIZE | SMALLINT | Average length (in bytes) of compressed rows in this data partition; -1 if statistics are not collected. | |
AVGROWCOMPRESSIONRATIO | REAL | For compressed rows in the data partition, this is the average compression ratio by row; that is, the average uncompressed row length divided by the average compressed row length; -1 if statistics are not collected. | |
STATS_TIME | TIMESTAMP | Y | Time at which any change was last made to recorded statistics for this object. Null if statistics are not collected. |
LASTUSED | DATE | Date when the data partition was last used by any DML statement or the LOAD command. If the table is not partitioned, only the LASTUSED value in SYSCAT.TABLES is updated. This column is not updated when the data partition is used on an HADR standby database. The default value is '0001-01-01'. This value is updated asynchronously not more than once within a 24 hour period and might not reflect usage within the last 15 minutes. |