A fix is available
APAR status
Closed as program error.
Error description
Q Capture delimited EP does not include the day for a TIMESTAMP WITH TIME ZONE column value if the day is December 31.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: 1- All SQL Apply users * * 2- All Event Publication customers * * 3- All Event Publication customers * * 4- All Q Capture Proxy customers using Db2 * * V12 Function level 502 or higher. * * 5- All Q Capture customers * **************************************************************** * PROBLEM DESCRIPTION: 1- SQL Apply should perform TRUNCATE * * of target table before fullrefresh if * * its DATA CAPTURE CHANGES attribute is * * not set * * 2- Q Capture delimited EP does not * * include the day for a TIMESTAMP WITH * * TIME ZONE column value if the day is * * December 31. * * 3- Q Capture delimited EP does not * * prefix negative decimal column values * * with a minus sign if the source table * * CCSID is 37 or 500 and the * * IBMQREP_SENDQUEUES MESSAGE_CODEPAGE is * * the same as the source table CCSID. * * 4- Q Capture running in proxy mode * * saves the SYSIBM.SYSTABLES schema in * * its version tables as version 0. Q * * Capture is unable to decode a Db2 V12 * * Function level 502 or higher * * SYSIBM.SYSTABLES log records using * * version 0 schema information. * * 5- Q Capture displays ASN0725W plus * * diagnostic data and continues * * executing after its log reader detects * * out of order log records. * **************************************************************** * RECOMMENDATION: * **************************************************************** 1- Currently SQL Apply always perform DELETE of target table before fullrefresh, regardless of the DATA CAPTURE CHANGES attribute of the target table. 2- Q Capture delimited EP should always include the day for a TIMESTAMP(integer) WITH TIME ZONE column values. 3- Q Capture delimited EP should prefix negative decimal column values with a minus sign. 4- Q Capture running in proxy mode should delete old SYSIBM.SYSTABLES schema information from its version tables if activating a Db2 V12 Function level adds a column to SYSIBM.SYSTABLES. 5- Q Capture will display ASN0725W plus diagnostic data, rollback uncommitted MQ transactions and reinitialize after its log reader detects out of order log records if its REINIT_LOGRECORDER is 'Y' (default). Q Capture will displays ASN0725W plus diagnostic data and continue executing after the log reader detects out of order log records if its REINIT_LOGRECORDER is 'N'.
Problem conclusion
1- SQL Apply will determine how to delete the target table before a fullrefresh, based on the DATA CAPTURE CHANGES attribute of the target table. 2- Q Capture delimited EP has been changed to always include the day for a TIMESTAMP WITH TIME ZONE column value. 3- Q Capture delimited EP has been changed to prefix negative decimal column values with a minus sign. 4- Q Capture has been changed to save the latest SYSIBM.SYSTABLES schema information in its version tables as the correct version. 5- The Q Capture REINIT_LOGRECORDER parameter has been added to prevent data loss the log reader detects out of order log records Note: ASNCLP has been updated from db2_v111m4fp6 n2002110100. Functional level: 1140.103
Temporary fix
Comments
APAR Information
APAR number
PH20050
Reported component name
WS REPLICATION
Reported component ID
5655L8800
Reported release
B33
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-12-06
Closed date
2020-02-20
Last modified date
2020-04-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI68024 UI68025 UI68026 UI68027
Modules/Macros
ASNAAPP ASNACMD ASNACMP ASNADMSP ASNAFET ASNAISO ASNAMAN ASNAPPLY ASNAPRS ASNAWPN ASNCAP ASNCATM ASNCCMD ASNCLPAP ASNCLPCL ASNCLPCM ASNCLPCO ASNCLPMS ASNCLPQA ASNMCMD ASNMON ASNQACMD ASNQAPP ASNQASUB ASNQBRWZ ASNQCAP ASNQCCMD ASNQCTLZ 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 UI68024
UP20/03/04 P F003
RB34 PSY UI68025
UP20/03/05 P F003
RB35 PSY UI68026
UP20/03/04 P F003
RB36 PSY UI68027
UP20/03/04 P F003
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:
05 March 2020