SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-18
DDL_LOCKS Table
DDL_LOCKS Table
DDL_LOCKS is a metadata table in DEFINITION_SCHEMA_VERSION_vernum that
is used for control locking of the base table so that utility operations in progress are
protected against conflicting DDL operations:
KEY_COL_USAGE Table
KEY_COL_USAGE is a metadata table in DEFINITION_SCHEMA_VERSION_vernum
that lists columns on key constraints in the catalog. KEY_COL_USAGE contains one or
more rows for each unique, primary key, or foreign key constraint in the
TBL_CONSTRAINTS table:
Column Name Data Type Description
*1 OBJECT_UID LARGEINT UID of lock
2 BASE_OBJECT_UID LARGEINT UID of locked object
3 TIME_LOCK_REQUESTED LARGEINT Lock creation time
4 TIME_LOCK_ALTERED LARGEINT Time when the lock was last altered
5 OPERATION CHAR(2) Utility operation requesting the lock:
DP Dup
IM Import
MT Modify table
MI Modify index
PI Populate index
PD PURGEDATA
RC Recover
6 STATUS INT Step in the operation
7 PERCENT_COMPLETE INT Reserved for future use
8 PROCESS_CREATE_TIME LARGEINT Time when process was created
9 PROCESS_ID VARCHAR(100) ID of process that requested the
lock
* Indicates primary key
Column Name Data Type Description
*1 CONSTRAINT_UID LARGEINT UID of constraint
*2 COLUMN_NUMBER INT Position within table (first column is 0)
3 ORDINAL_POSITION INT Position within key (first column is 0)
* Indicates primary key