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

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-21
DDL_LOCKS Table
DDL_LOCKS Table
DDL_LOCKS is a metadata table in DEFINITION_SCHEMA_VERSION_vernum that
is used for control locking of an object so that utility operations in progress are
protected against conflicting DDL or utility operations:
DDL_PARTITION_LOCKS
The DDL_PARTITION_LOCKS table stores information about DDL locks being held on
partitions.
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:
BK Backup
CR Concurrent Restore
DP Dup
IM Import
MT Modify table
MI Modify index
PI Populate index
PD PURGEDATA
RC Recover
RS Restore
UM Upgrade all metadata
FS FASTCOPY Source object
FT FASTCOPY Target object
DM Downgrade all metadata
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 OBJECT_UID LARGEINT UID of a lock.
*2 SYSTEM_NAME CHAR(8) Name of a node. The node name includes the
leading '\' sign.