$ db2pd -db txdb -wlocks detail -locks showlocks wait

Database Member 0 -- Database TXDB -- Active -- Up 7 days 22:42:51 -- Date 2017-11-26-07.13.27.897921

Locks being waited on :
AppHandl [nod-index] TranHdl    Lockname                   Type       Mode Conv Sts CoorEDU    AppName  AuthID   AppID                           TableNm            SchemaNm AppNode                                  
3598     [000-03598] 204        000302E4000000000006000552 RowLock    ..X       G   37788      asncap   DPTXDBCP *LOCAL.insttxdb.171118215307     IBMSNAP_REGISTER   ASN      g01acirdbha011
3597     [000-03597] 214        000302E4000000000006000552 RowLock    ..U       W   39330      asncap   DPTXDBCP *LOCAL.insttxdb.171118215306     IBMSNAP_REGISTER   ASN      g01acirdbha011


Database Member 0 -- Database TXDB -- Active -- Up 7 days 22:42:51 -- Date 2017-11-26-07.13.27.916839

Locks:
Address            TranHdl    Lockname                   Type           Mode Sts Owner      Dur HoldCount  Att        ReleaseFlg rrIID TableNm            SchemaNm
0x0A0003001DB78300 214        000302E4000000000006000552 RowLock        ..U  W   204        0   0          0x00000000 0x00000000 0     IBMSNAP_REGISTER   ASN           000302E4000000000006000552 SQLP_RECORD (obj={3;740}, rid=d(0;6;5), x0000000000060005)
0x0A0003004EAB1B80 204        000302E4000000000006000552 RowLock        ..X  G   204        1   0          0x00200000 0x40000000 0     IBMSNAP_REGISTER   ASN           000302E4000000000006000552 SQLP_RECORD (obj={3;740}, rid=d(0;6;5), x0000000000060005)
$


db2 => select * from asn.IBMSNAP_REGISTER where hex(rid(ASN.IBMSNAP_REGISTER))='0000000000060005'

SOURCE_OWNER  SOURCE_TABLE  SOURCE_VIEW_QUAL GLOBAL_RECORD SOURCE_STRUCTURE SOURCE_CONDENSED SOURCE_COMPLETE CD_OWNER CD_TABLE PHYS_CHANGE_OWNER PHYS_CHANGE_TABLE CD_OLD_SYNCHPOINT CD_NEW_SYNCHPOINT DISABLE_REFRESH CCD_OWNER CCD_TABLE CCD_OLD_SYNCHPOINT SYNCHPOINT                          SYNCHTIME                  CCD_CONDENSED CCD_COMPLETE ARCH_LEVEL DESCRIPTION  BEFORE_IMG_PREFIX CONFLICT_LEVEL CHG_UPD_TO_DEL_INS CHGONLY RECAPTURE OPTION_FLAGS STOP_ON_ERROR STATE STATE_INFO
------------- ------------- ---------------- ------------- ---------------- ---------------- --------------- -------- -------- ----------------- ----------------- ----------------- ----------------- --------------- --------- --------- ------------------ ----------------------------------- -------------------------- ------------- ------------ ---------- ------------ ----------------- -------------- ------------------ ------- --------- ------------ ------------- ----- ----------
                                           0 Y                            0                                  -        -                                            -                 -                               0 -         -         -                  x'0000000004BF58EF000000019609F308' 2017-11-26-07.14.23.205977 -             -            0801       -            -                 -              -                  -       -         NNNN         Y             I     -         

  1 record(s) selected.

db2 =>