Finding the key of record causing DSNU344I while loading
Posted: Mon Feb 25, 2019 1:17 pm
When loading the data to the table, I got below message in SYSPRINT stating existence of duplicate record:
Is there any way to find the key of the record which resulted in above error? Also as per table definition, I see no column defined as USAGE SQL TYPE IS ROWID So what is the RID Hexadecimal value denotes?
DSNU344I -DT11 055 03:18:34.55 DSNURBXA - UNIQUE INDEX KEY DUPLICATES KEY OF INDEXED RECORD
AT RID X'0030008201',
INDEX = DB2T.index_nm,
TABLE = DB2T.table_nm,
RECNO = 1,
RID = X'0030012A02'
AT RID X'0030008201',
INDEX = DB2T.index_nm,
TABLE = DB2T.table_nm,
RECNO = 1,
RID = X'0030012A02'
Is there any way to find the key of the record which resulted in above error? Also as per table definition, I see no column defined as USAGE SQL TYPE IS ROWID So what is the RID Hexadecimal value denotes?