SQL – find locks in database

Find locks in database
(kill with clearlocks in tc-shell or live session with server pool manager)

Search by User-Session:

select p.PUSER_NAME, p.PNODE_NAME, p.PPROCESS_ID
FROM infodba.PPOM_SESSION p, infodba.POM_M_LOCK l
WHERE l.PROCESS = p.PPROCESS_ID;

Search by Object with a lock:

SELECT wso.POBJECT_TYPE, wso.POBJECT_NAME
FROM infodba.PWORKSPACEOBJECT wso, infodba.POM_M_LOCK l
WHERE l.REF_UID = wso.PUID;