Q Replication Dashboard

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

...