A fix is available
APAR status
Closed as unreproducible in next release.
Error description
Capture gets SQLCODE -180 when it inserts timestamp values into the CAPMON CURRENT_LOG_TIME and LAST_EOL_TIME columns if the Db2 subsystem LRSN Delta is non-zero.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: 1- All Capture customers with Db2 tables in * * multi-table tablespaces. * * 2- All Capture Db2 data sharing customers * * 3- All SQL Capture customers * * 4- All SQL Capture customers * **************************************************************** * PROBLEM DESCRIPTION: 1- Capture cannot find the version of * * a table in the IBMQREP_TABVERSION * * table. * * 2- Capture gets SQLCODE -180 when it * * inserts timestamp values into the * * CAPMON CURRENT_LOG_TIME and * * LAST_EOL_TIME columns if the Db2 * * subsystem LRSN Delta is non-zero. * * 3- SQL Capture hangs reading 974 Meg * * transaction. * * 4- SQL Capture inserts commit * * information into the IBMSNAP_UOW table * * even if SQL Apply does not need to * * join the CD tables with the * * IBMSNAP_UOW table. * **************************************************************** * RECOMMENDATION: * **************************************************************** 1- Capture is decoding a log record and cannot locate the version of a table specified in the log record. The table is in a multi-table tablespace and a REORG of the tablespace was done that increased the version of the table even though the table was not altered. 2- The capture log reader converts the end-of-log LRSN value into an invalid timestamp value if the LRSN Delta value is non-zero. 3- The SQL Capture log reader sleeps when it detects that SQL Capture memory is full even if its worker has no transactions to process. 4- SQL Capture should not insert commit information into the IBMSNAP_UOW table if it is not needed.
Problem conclusion
Temporary fix
Comments
1- Capture has been changed to use the schema from the IBMQREP_TABVERSION table that describes the version of the table specified in the log record. 2- The capture log reader will adjust the end-of-log LRSN value using the LRSN Delta value before it converts the end-of-log LRSN value into a timestamp value. 3- The SQL Capture log reader will spill transactions to disk when it detects that SQL Capture memory is full. 4- SQL Capture will not insert commit information into the IBMSNAP_UOW table if the INSERT_UOW start-up parameter is 'N' and all IBMSNAP_PRUNCNTL TARGET_STRUCTURE column values are 8 or 9. ASNCLP was not updated.
APAR Information
APAR number
PH06478
Reported component name
WS REPLICATION
Reported component ID
5655L8800
Reported release
B33
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-12-13
Closed date
2019-01-16
Last modified date
2019-02-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI60756 UI60757 UI60758 UI60759
Modules/Macros
ASNACMD ASNADMSP ASNAPPLY ASNCAP ASNCATM ASNCCMD ASNCCPWK ASNMCMD ASNMON ASNQACMD ASNQAPP ASNQCAP ASNQCCMD ASNQDEP ASNQEXRP ASNQMFMT ASNQXFMT ASNRBASE ASNTDIFF ASNTDSP ASNTRC ASN2BASE
Fix information
Fixed component name
WS REPLICATION
Fixed component ID
5655L8800
Applicable component levels
RB33 PSY UI60756
UP19/01/26 P F901
RB34 PSY UI60757
UP19/01/26 P F901
RB35 PSY UI60758
UP19/01/26 P F901
RB36 PSY UI60759
UP19/01/26 P F901
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B33","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 February 2019