Look for the row that has a "W", meaning waiting, in the Sts (status) column. The Owner column indicates which transaction is holding the lock. In the following example TranHdl 3 is waiting on a lock held be TranHdl 2 (indicated by 1 below).

db2pd -d <database> -locks showlocks

db2pd -alldbs - locks showlocks

Database Partition 0 -- Database SAMPLE -- Active -- Up 00:00:40

Locks:

TranHdl ...       Sts        Owner ...

2 ...                G           2 ...

3 ...                G           3 ...

2 ...                G           2 ...

3 ...            W        2   1  ...

2 ...                G           2 ...

2 ...                G           2 ...

2 ...                G           2 ...

      2 ...                G           2 ...

Identify the application that is running the transaction that is holding the lock by running db2pd -transactions. In the example below we see that TranHdl 2(indicated by 1 ) is being run by AppHandl 12(indicated by 2 ).

db2pd -d <database> -tansactions transaction= < TranHdl > 

Database Partition 0 -- Database SAMPLE -- Active -- Up 00:05:06

Transactions:

... AppHandl     ... TranHdl      Locks ...

... 12   2       ... 2   1      38 ...

      .... 13               ... 3               5 ...

Identify the Agent ID that is running the application by running db2pd -agents.

db2pd -agents application=< AppHandl> 

Database Partition 0 -- Database SAMPLE -- Active -- Up 00:06:15

Agents:

Current agents: 2

Idle agents: 0

Active agents: 2

Coordinator agents: 2

... AppHandl       ... AgentPid       ... ClientPid        Userid             ClientNm ...
... 13                 ... 749570          ... 434354           jmcmahon       db2bp ...

      ... 12   2        ... 811172      ... 917706       jmcmahon    db2bp ...