Preparation 
  Connect to the desired database
    db2 connect to <dbname>
  Create the db2perf_quiet_drop utility stored procedure
    db2 -td@ -f db2perf_utils.db2
  Create the db2perf_locktree stored procedure
    db2 -td@ -f db2perf_locktree.db2
Use
  Connect to the desired database 
    db2 connect to <dbname>
  Call the stored procedure to capture the state of lock wait relationships at that moment
    $ db2 call db2perf_locktree
  Examine the lock relationships in the result set returned from db2perf_locktree


For more information, see db2perf.pdf
