select *
from syslocks,
sysdbspartn,outer syssessions
where syslocks.owner = syssessions.sid and
syslocks.rowidlk = sysdbspartn.rowid
onmode -z sid;
select *
from syslocks,
sysdbspartn,outer syssessions
where syslocks.owner = syssessions.sid and
syslocks.rowidlk = sysdbspartn.rowid
onmode -z sid;