SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-24
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_VERSION_vernum that
describes partitions in the catalog. The columns INDEX_LEVEL,
NON_EMPTY_BLOCK_COUNT, and EOF are updated by the UPDATE STATISTICS
statement.
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
13 RESERVED_FILLER_INT INT Reserved for future use
14 RESERVED_FILLER_CHAR CHAR(20) Reserved for future use
15 DROPPABLE CHAR(2) Reserved for future use
16 RCB_VERSION INT The version of the object's Record
Control Block (RCB)
* Indicates primary key
Note. In the definition schema version 3000 and later versions, a unique index called OBJIDX
is defined on the OBJECT_UID column.
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
Column Name Data Type Description