SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-19
PARTITIONS Table
Object names that are regular identifiers are stored in uppercase letters. Object names
that are delimited identifiers are stored as is, without surrounding quotation marks.
PARTITIONS Table
PARTITIONS is a metadata table in DEFINITION_SCHEMA that describes partitions in
the catalog. The columns INDEX_LEVEL, NON_EMPTY_BLOCK_COUNT, and EOF
are updated by the UPDATE STATISTICS statement.
6 CREATE_TIME LARGEINT Julian timestamp of creation time
7 REDEF_TIME LARGEINT Julian timestamp of redefinition time
8 CACHE_TIME LARGEINT Julian timestamp of cache time
9 OBJECT_FEATURE_VERSION INT Version of object
10 VALID_DEF CHAR(2) Y if definition valid
N if not
11 OBJECT_SECURITY_CLASS CHAR(2) UM User metadata table
UT User-defined table
SM System metadata table
12 OBJECT_OWNER INT The integer representation of the
owner's authorization ID
* Indicates primary key
Column Name Data Type Description
*1 OBJECT_UID LARGEINT UID of partitioned object
*2 SYSTEM_NAME CHAR(8) Name of node with partition
including leading “\” (backslash)
*3 DATA_SOURCE CHAR(8) Name of volume with partition
including leading “$” (dollar sign)
*4 FILE_SUFFIX CHAR(18) Subvolume and simple name of
name of file with partition
5 PARTITION_NAME VARCHAR(128) Name associated with a partition.
6 MAX_SIZE LARGEINT The value of MAXSIZE for the
partition
7 PRI_EXT LARGEINT Primary extent size
8 SEC_EXT LARGEINT Secondary extent size
9 MAX_EXT LARGEINT Maximum extent size
10 INDEX_LEVEL INT Index level of last UPDATE
STATISTICS
11 NON_EMPTY_BLOCK_COUNT INT Number of nonempty blocks at
last UPDATE STATISTICS
* Indicates primary key
Column Name Data Type Description