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

DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

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 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