SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—523723-004
8-41
Displaying All DDL Locks on an Index
Displaying All DDL Locks on an Index
This example (when run on the node on which the metadata is located) displays the
DDL locks on the index SAMDBCAT.SALES.XCUSTNAM:
>> set schema samdbcat.definition_schema_version_1200;
--- SQL operation complete.
>> select substring (o1.object_name from 1 for 25) as lock_name,
l.operation as util,
l.status,
substring (l.process_id from 1 for 25)
from objects o, objects o1, ddl_locks l
where o.object_name = 'XCUSTNAM'
and o.object_uid = l.base_object_uid
and l.object_uid = o1.object_uid
and o.schema_uid =
(select schema_uid
from nonstop_sqlmx_figaro.system_schema.schemata
where
schema_name = 'SALES' and
cat_uid =
(select cat_uid
from nonstop_sqlmx_figaro.system_schema.catsys
where cat_name = 'SAMDBCAT'
)
)
for read uncommitted access
order by l.object_uid;
LOCK_NAME UTIL STATUS PROCESS_ID
----------------------- ---- -------- -----------------------
CUSTOMER_777179541_2217 PD 4 \FIGARO.$:3:321:2235264