When I run the SNAPSHOT_LOCKWAIT table function (AIX db2 v8.1), I can
get lockwait results for lockwaits involving the same ID as that
running the SNAPSHOT_LOCKWAIT (instance owner), but if the Lockwait is
triggered with another user, I always get 0 rows from
SNAPSHOT_LOCKWAIT. Anybody else experience this, and if so, what kind
of workarounds or parm changes can effect this?
The SNAPSHOT_LOCKS table function on the otherhand behaves as expected
and returns the locks no matter the ID that has the locks.
I have tried
FROM TABLE(SNAPSHOT_LOCKWAIT('', -1))
FROM TABLE(SNAPSHOT_LOCKWAIT('', -2))
FROM TABLE(SNAPSHOT_LOCKWAIT('dbname', -1))
FROM TABLE(SNAPSHOT_LOCKWAIT('dbname', -2))