SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Metadata Tables
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
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.
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
12 EOF LARGEINT End of file indication at last
UPDATE STATISTICS
13 PARTITION_STATUS CHAR(2) Status defined by:
AV Available
UO Unavailable, offline
UC Unavailable, corrupt
UD Unavailable, dropped
UR Unavailable, re-created
14 DDL_IN_PROGRESS CHAR(2) Reserved for future use
15 FIRST_KEY VARCHAR(28670) User-specified first key in
normalized form; otherwise,
zero-length. If hash partitioned, a
logical partition number.