Fixes are available
APAR status
Closed as new function.
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 October 2021