When I run the SNAPSHOT_LOCKWA IT table function (AIX db2 v8.1), I can
get lockwait results for lockwaits involving the same ID as that
running the SNAPSHOT_LOCKWA IT (instance owner), but if the Lockwait is
triggered with another user, I always get 0 rows from
SNAPSHOT_LOCKWA IT. 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('dbnam e', -1))
FROM TABLE(SNAPSHOT_ LOCKWAIT('dbnam e', -2))
get lockwait results for lockwaits involving the same ID as that
running the SNAPSHOT_LOCKWA IT (instance owner), but if the Lockwait is
triggered with another user, I always get 0 rows from
SNAPSHOT_LOCKWA IT. 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('dbnam e', -1))
FROM TABLE(SNAPSHOT_ LOCKWAIT('dbnam e', -2))