From: http://www.db2china.net/club/archiver/tid-10129.html
Reference: ---- view the number of locks in the table in the sample database
Select tabschema, tabname, count (*) as number_of_locks_held from sysibmadm. locks_held -- where db_name = 'sample' group by dbpartitionnum, tabschema, tabname ---- query database lock table information DB2 "select agent_id, tabschema, tabname from sysibmadm. snaplock "---- view lock wait select smallint (agent_id) as waiting_id, substr (appl_name,) as waiting_app, substr (authid,) as waiting_user, smallint (token) as holder_id, lock_mode as held, lock_object_type as type, lock_mode_requested as request from sysibmadm. lockwaits view lock table information ------------- select substr (tabschema,), substr (tabname,), count (*) as number_of_locks_held from sysibmadm. locks_held group by dbpartitionnum, tabschema, tabname
RelatedArticle:
http://www.db2china.net/club/viewthread.php? Tid = 9782 & extra = Page % 3d3