[crx@CentOS-6-64-EN sqllib]$ db2pd -db db6 -locks wait showlocks

Database Member 0 -- Database DB6 -- Active -- Up 0 days 19:32:09 -- Date 2014-02-28-06.17.52.081105

Locks:
Address            TranHdl    Lockname                   Type           Mode Sts Owner      Dur HoldCount  Att        ReleaseFlg rrIID TableNm            SchemaNm 
0x00007F31313BA980 17         02000700040000000000000052 RowLock        ..U  W   21         0   0          0x00000000 0x00000000 0     JOURNAL_LOCAL_REVI CRX      	02000700040000000000000052 SQLP_RECORD (obj={2;7}, rid=d(0;0;4), x0400000000000000)
0x00007F31313BE380 21         02000700040000000000000052 RowLock        ..X  G   21         1   0          0x00200000 0x40000000 0     JOURNAL_LOCAL_REVI CRX      	02000700040000000000000052 SQLP_RECORD (obj={2;7}, rid=d(0;0;4), x0400000000000000)

[crx@CentOS-6-64-EN sqllib]$ db2pd -db db6 -transactions

Database Member 0 -- Database DB6 -- Active -- Up 0 days 19:32:19 -- Date 2014-02-28-06.18.02.132028

Transactions:
Address            AppHandl [nod-index] TranHdl    Locks      State   Tflag      Tflag2     Firstlsn           Lastlsn            Firstlso             Lastlso              SpaceReserved   LogSpace        TID            AxRegCnt   GXID     ClientUserID                   ClientWrkstnName               ClientApplName                 ClientAccntng                  
0x00007F3130C7FA80 2651     [000-02651] 11         0          READ    0x00000000 0x00000000 0x0000000000000000 0x0000000000000000 0                    0                    0               0               0x000000000101 1          0        n/a                            n/a                            db2evml_DB2DETAILDEADLOCK      n/a                            
0x00007F3130C8E080 4062     [000-04062] 16         0          READ    0x00000000 0x00000000 0x0000000000000000 0x0000000000000000 0                    0                    0               0               0x000000036E62 1          0        n/a                            n/a                            n/a                            n/a                            
0x00007F3130C90E80 2962     [000-02962] 17         4          READ    0x00000000 0x00000000 0x0000000000000000 0x00000000000DAD72 0                    0                    0               0               0x000000034DD0 1          0        n/a                            10.42.83.201                   n/a                            n/a                            
0x00007F3130C9C680 2971     [000-02971] 21         6          WRITE   0x00000000 0x00000000 0x00000000000DAD80 0x00000000000DAD84 132069851            132070208            500             980             0x000000034DCF 1          0        n/a                            10.42.83.201                   n/a                            n/a                            
Total application commits   : 210229              
Total application rollbacks : 10030              


[crx@CentOS-6-64-EN sqllib]$ db2pd -db db6 -applications

Database Member 0 -- Database DB6 -- Active -- Up 0 days 19:32:44 -- Date 2014-02-28-06.18.27.280528

Applications:
Address            AppHandl [nod-index] NumAgents  CoorEDUID  Status                  C-AnchID C-StmtUID  L-AnchID L-StmtUID  Appid                                                            WorkloadID  WorkloadOccID CollectActData          CollectActPartition     CollectSectionActuals  
0x0000000204060080 2651     [000-02651] 1          311        ConnectCompleted        0        0          0        0          *LOCAL.DB2.140227184559                                          0           0             N                       C                       N  
0x0000000203E60080 2971     [000-02971] 1          320        UOW-Waiting             0        0          1003     1          10.42.83.201.58126.140227210147                                  1           26            N                       C                       N  
0x0000000203CD0080 2648     [000-02648] 1          308        ConnectCompleted        0        0          0        0          *LOCAL.DB2.140227184556                                          0           0             N                       C                       N  
0x0000000203D80080 4062     [000-04062] 1          315        UOW-Waiting             0        0          542      2          *LOCAL.crx.140228140330                                          1           39            N                       C                       N  
0x0000000203870080 2647     [000-02647] 1          307        ConnectCompleted        0        0          0        0          *LOCAL.DB2.140227184555                                          0           0             N                       C                       N  
0x0000000204050080 2962     [000-02962] 1          318        Lock-wait               1003     1          317      1          10.42.83.201.59730.140227205644                                  1           22            N                       C                       N