A fix is available
APAR status
Closed as program error.
Error description
QREP CAPTURE won't start with IFCID 306 error reason 00E60844 20.54.18 ASN0005E CAPTURE "C2QASN" : "LogrdThread". The Capture program encountered an error when reading the database log. The log sequence number is "00dc:715b:d603:4a00:2800:0000:0000:0000", the SQLCODE is "12", and the reason code is "00E60844" The problem is due to Db2's IFCID 306 not receiving the replication caller's WQLS information properly and our error checking detected the problem. When Qrep called the IFCID306 service, Db2 will first check their WQAL/WQLS input information and if any error, Db2 will return X'00E60xxx'. In this case, X'00E60844' was issued, as Db2 did not properly receive the input from the WQAL/WQLS block.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 13 for z/OS users * * running applications that read the Db2 * * logs with the IFI READS facility for * * Partition range support in IFCID 306. * **************************************************************** * PROBLEM DESCRIPTION: * * Q-REPLICATION CAPTURE issued ASN0005E * * with SQLCODE = "12", and the reason * * code RC00E60844. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** Db2 13 allows any user of IFCID 306 the flexibility to supply the partition filtering as a range of partitions for log read process. Before processing the IFI READS call, Db2 checks and validates the input partition range from the replication caller. Due to Db2's incorrect handling of the internal storage holding the input partition range information, bad partition range was read. This caused the error and the reason code RC00E60844 was issued by Db2 and returned to the replication caller.
Problem conclusion
Db2 code is modified to ensure its internal storage can hold the entire input data, including the partition range information, from the replication program for IFCID 306 process.
Temporary fix
Comments
APAR Information
APAR number
PH52122
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
D10
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-01-24
Closed date
2023-03-01
Last modified date
2023-08-23
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI90802
Modules/Macros
DSNWARDS
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RD10 PSY UI90802
UP23/03/09 P F303
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":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
24 August 2023