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: - D = No data movement
- F = Full access
- N = No access
- R = Read-only access
|
STATUS |
VARCHAR (32) |
|
- A = Data partition is newly attached
- D = Data partition is detached and detached dependents are to
be incrementally maintained with respect to the content of this partition
- I = Detached data partition whose entry in the catalog is maintained
only during asynchronous index cleanup; rows with a STATUS value
of 'I' are removed when all index records referring to the detached
partition have been deleted
- L = Data partition is logically detached
- Empty string = Data partition is visible (normal status)
Bytes 2 through 32 are reserved for future use. |
SEQNO |
INTEGER |
|
Data partition sequence number (starting from 0). |
LOWINCLUSIVE |
CHAR (1) |
|
- N = Low key value is not inclusive
- Y = Low key value is inclusive
|
LOWVALUE |
VARCHAR (512) |
|
Low key value (a string representation of an SQL value) for
this data partition. |
HIGHINCLUSIVE |
CHAR (1) |
|
- N = High key value is not inclusive
- Y = High key value is inclusive
|
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. |