I own a tool which is putting a very heavy load on a database, and I am
getting lock escalation warnings and alarms. I have taken some steps
to mark transactions as unconditional reads to try and make the DBs life
easier, but I was wondering if there was any way to see which tables are
getting the lock escalations so I can narrow down the problem.

I recently added some logging in the DB to monitor exactly what requests
are being asked of the tool, but I think that that addition itself is putting
a heavy load on the DB. I think I am going to cache that info in memory and
load it into the DB at regular intervals to ease that load.

Any help/advice on tracking down locking issues would be appreciated.

Thanks,
Wayne

Try "GET SNAPSHOT FOR LOCKS..."

Thanks, I was able to use:

db2 get snapshot for locks on dbname | grep "Table Name"

For most databases, you should increase the LOCKLIST which has a default that is too low. This will help reduce the lock escalation.

db2 connect to sample

db2 update db cfg using LOCKLIST 4096