IBM Support

PH52101: ABEND0C4 PIC3A DSNIDCVL OFFSET0565C DURING RECORD CONVERSION IFCID306 CALL USING QREP

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • QREP terminated with ABENDS0C4 0000003A RC3A PIC3A in
    DSNIDCVL +0565C because of lack of the CUB (used for SQL
    processing). This happened in the process of record conversion
    on behalf of IFCID 306 caller.
    

Local fix

  • BYPASS/CIRCUMVENTION:
    n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Db2 12 and 13 for z/OS users of IFCID 306                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * ABEND0C4 in DSNIDCVL+0565C during                            *
    * IFCID 306 READS request to convert                           *
    * data in the version that was                                 *
    * current at the time the log record                           *
    * was written.                                                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    During IFCID 306 READS request to convert data in the log
    record, ABEND0C4 in DSNIDCVL+0565C was encountered because
    the page set cursor block information was not available when
    generating the default value for a rowid column.
    

Problem conclusion

  • Db2's IFCID 306 logic is modified to ensure the page set
    cursor block information is provided when generating the
    default value for a rowid column.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH52101

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2023-01-23

  • Closed date

    2023-05-05

  • Last modified date

    2023-06-01

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI91637 UI91638

Modules/Macros

  • DSNIMOFR DSNUCRUL DSNIRLPG DSNITUPD DSNIRELK DSNISFWL DSNITDLE
    DSNURWBR DSNIETRV DSNURPUI DSNIDCVL DSNIDLER DSNILREP DSNIDALC
    DSNISFX2 DSNICUMW DSNIFDIC DSNURFIT DSNURCRF DSNUKINT DSNIDCML
    DSNIZMOS DSNURLAP DSNUCINT DSNURWIK DSNICMT2 DSNISFS  DSNURSCN
    DSNUSTBL DSNURLXL DSNIDEFS DSNKIXDB DSNUKIUL DSNISFRL DSNIDIFS
    DSNUULCA DSNIKDEF DSNIRFNX DSNUULXA DSNUCLGR DSNXKINS DSNIBNRF
    DSNIIDIS DSNURFBR DSNURWBF DSNUULVA DSNURFUI
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI91637

       UP23/05/10 P F305

  • RD10 PSY UI91638

       UP23/05/10 P F305

[{"Business Unit":{"code":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19O","label":"DB2 for z\/OS"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"12.0"}]

Document Information

Modified date:
02 June 2023