Formatted Exceptions
The following table is actual output from a dashboard report of a Q Apply exceptions table.
Time | Exception |
---|---|
2006-02-27 17:12:58.462015 | RECVQ = peer1to2data SRC_COMMIT_LSN = x'00000000000009A15099' SRC_TRANS_TIME = 2006-02-28 01:12:56.000088 SUBNAME = EMPLOYEE0002 REASON = SQLERROR SQLCODE = -289 SQLSTATE = 57011 SQLERRMC (EBCDIC) = èëá(&<|ßáá (ASCII) = TSEMPLOYEE (HEX) = 5453454D504C4F594545 IS_APPLIED = N CONFLICT_RULE = V Database name = TOOLSDB Source Table Owner = null Source Table Name = null Row Operation = Insert Columns : Column Name = EMPNO Is Key = true Value = A17132 Column Name = ibmqrepVERTIME Value = 2006-02-28T01:12:56.209002 Column Name = ibmqrepVERNODE Value = 8 Column Name = BIRTHDATE Value = null Column Name = BONUS Value = null Column Name = COMM Value = null Column Name = EDLEVEL Value = 2 Column Name = FIRSTNME Value = A Column Name = HIREDATE Value = null Column Name = JOB Value = null Column Name = LASTNAME Value = A Column Name = MIDINIT Value = A Column Name = PHONENO Value = null Column Name = SALARY Value = null Column Name = SEX Value = null Column Name = WORKDEPT Value = null |
2006-02-27 17:12:58.462014 | RECVQ = peer1to2data SRC_COMMIT_LSN = x'00000000000009A1488E' SRC_TRANS_TIME = 2006-02-28 01:12:56.000074 SUBNAME = EMPLOYEE0002 REASON = SQLERROR SQLCODE = -289 SQLSTATE = 57011 SQLERRMC (EBCDIC) = èëá(&<|ßáá (ASCII) = TSEMPLOYEE (HEX) = 5453454D504C4F594545 IS_APPLIED = N CONFLICT_RULE = V Database name = TOOLSDB Source Table Owner = null Source Table Name = null Row Operation = Insert Columns : Column Name = EMPNO Is Key = true Value = A17123 Column Name = ibmqrepVERTIME Value = 2006-02-28T01:12:56.169002 Column Name = ibmqrepVERNODE Value = 8 Column Name = BIRTHDATE Value = null Column Name = BONUS Value = null Column Name = COMM Value = null Column Name = EDLEVEL Value = 2 Column Name = FIRSTNME Value = A Column Name = HIREDATE Value = null Column Name = JOB Value = null Column Name = LASTNAME Value = A Column Name = MIDINIT Value = A Column Name = PHONENO Value = null Column Name = SALARY Value = null Column Name = SEX Value = null Column Name = WORKDEPT Value = null |