IBM Support

PH52122: QREP CAPTURE IFCID306 ERROR RC00E60844

A fix is available

Subscribe

You can track all active APARs for this component.

 

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