db2pd

1.Check lock wait.
db2pd -db [dbname] -locks wait showlocks


2.confirm the lock wait and the table.
select tabschema,tabname from syscat.tables where tbspaceid = ? and tableid=?

3.Get transaction
db2pd -db [dbname] -transactions

4.Get agent
db2pd -agents

5.Get applications
db2pd -db [dbname] -applications

6.Get dynamic buffer
db2pd -db [dbname] -dynamic

7.db2pd -db [dbname] -locks wait showlocks -transactions -agent -applications -dynamic -file [filename] -repeat 15(intervaltime:s) 40(times)