<bi******@in.ibm.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
Hi ,
How to find out if a table is locked ?
Thanks
Bikash
You can do a snapshot for locks (you must turn on the lock monitor first).
See the "Command Reference" manual.
Table level locking occurs in the following ways:
- Table is created with table level locking (instead of row level). See "SQL
Reference Vol 2".
- Lock Table SQL statement as described in "SQL Reference Vol 2".
- Lock escalation from row to table (this will show up in the db2diag.log).
Lock escalation is be influenced by the LOCKLIST and MAXLOCKS database
configuration parameters as described in the "Administration: Performance"
manual.