IBM Support

JR45355: Q & SQL REPLICATION ENGINE FIXES FOR DB2 LUW V9.7FP8

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Q & SQL Replication Engine fixes for DB2 LUW V9.7FP8
    

Local fix

Problem summary

  • The following Data Replication Engine APARs have been
    fixed in DB2 LUW V9.7 FP8.
    .
    Refer to the respective APARs for more details.
    .
    .
    JR43984: QAPPLY SHOULD BE ABLE TO GRACEFULLY COME DOWN IF
    FEDERATED TARGET GETS CONNECTION ERROR
    .
    JR44039: QCAPTURE ADMIN THREAD SLEEPS WHILE ADMIN MESSAGES
    REMAIN UNPROCESSED ON THE ADMINQ
    .
    JR44759: CAPTURE HANGS AND DISPLAYS ASN0057E WITH ERROR
    "28" IF THERE IS NOT ENOUGH AVAILABLE SPACE TO WRITE A
    SPILLED ROW
    .
    JR44815: A CCD FAN-OUT SETUP CAN HAVE DATA LOSS WHEN THE
    CCD REGISTER TBL SYNCHPOINT IS UPDATED INCORRECTLY WHEN
    QAPPLY RESTARTS
    .
    JR45352: RESTORE REPLICATION PROGRAM SUPPORT FOR DES
    ENCRYPTED PASSWORD FILES
    .
    JR45571: ASNTREP RETURNS SQLCODE -423 WHEN THE NON-KEY
    COLUMNS ARE LOB, CLOB, BLOB AND THE LENGTH OF ANY COLUMN
    VALUE IS ZERO
    .
    JR45635: ORACLE QCAPTURE: SIGNAL TABLE ROWS ARE GROWING
    AND NEVER PRUNED WHEN ORACLE IS 11G AND HIGHER
    .
    JR46242: SQL APPLY REPORTS SQLCODE -204 ON
    SYSIBM.SYSCOLUMNS IN APPLY LOGWHEN SOURCE DATABASE IS
    ISERIES
    .
    JR47713: SQL APPLY FAILS WITH SQLCODE -206 OR CRASHES WITH
    SIGSEGV FOR CCD TARGET WHEN A COLUMN HAS COL_TYPE='C' OR
    'F'
    .
    JR48285: "TXRDTHREAD" THE PROGRAM RECEIVED RETURN CODE
    "100" FROM ROUTINE "TXRDTHREAD" THE PROGRAM REC
    "ADDALLREQUIREDREDOLOGFILES"
    .
    JR48287: ORACLE CAPTURE: ASN0569E RC=5003 ERROR WHEN
    REPLICATE NCHAR DATA TYPE WITH SPECIFIC DATA
    .
    JR48289: Q APPLY BEHAVIOR FOR UPDATING OLDEST_TRANS FROM
    HEARTBEAT MSGS SEEMS TO BE OUT-OF-SPEC
    .
    JR48291: Q APPLY IT CAN CAUSE AN INFINITE LOOP WHEN
    RETRYING MULTIPLE ROW FAILURES WITH OKSQLSTATES IN SAME
    TRANSACTION
    .
    JR48299: ORACLE CAPTURE NOT COMPENSATING PARTICULAR
    FAILED MULTI-ROW INSERT OPERATIONS CORRECTLY
    .
    JR48292: ASNMON DOESN'T DELETE THE PID FILE IN
    $HOME/SQLLIB/DPROPR DIR WHEN STOPS
    .
    JR48315: ASNLOAD FAILS WITH ASN1053E OR CRASHES WITH
    SIGSEGV WHEN THE MEMBER INCLUDES A COMPUTED COLUMN
    (COL_TYPE= 'C' OR 'F')
    .
    JR48300: SQL APPLY FAILS WITH ASN1021E DURING READING
    SPILL FILES FOR SUBSCRIPTIONS WITH UDB V10 SERVER
    .
    JR48301: Q APPLY HANG WHEN USING REINITQ AND CHANGING
    .
    JR48293: CORRECT CAPTURE_IDLE IN CAPMON TO PREVENT
    INCORRECT LARGE VALUES.  IT DOES RETURN TO NORMAL AFTER
    RESTART QCAPTURE.
    .
    

Problem conclusion

  •  see problem summary
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR45355

  • Reported component name

    REPLICATION SER

  • Reported component ID

    5724N9800

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-01-10

  • Closed date

    2015-06-25

  • Last modified date

    2015-06-25

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    REPLICATION SER

  • Fixed component ID

    5724N9800

Applicable component levels

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU050","label":"BU NOT IDENTIFIED"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 June 2015