We have a database that is showing a lock list memory in use of 31104 bytes, with 0 locks held currently. I know that the catalog cache and package cache can overflow into the lock list memory space, but the snapshot shows 0 overflows for both. Is the overflow counter reset each time you start monitoring for snapshots, or is it a cumlative counter? We are clueless why there would be lock list usage with no current locks nor overflows.

Thanks
Ron

Lock list memory in use is a guage element, ie, it shows the usage at the current point of time ...

Seems like a bug ... Can you report it to IBM so that they can fix this in a later fp

Cheers
Sathyaram