IBM Support

PM82763: ABEND04E 00C90101 IN DSNODAL1 ERQUAL5002 SINCE THE LOB MAP PAGE RETURNED AFTER I/O IS ALL ZEROS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After a LOAD Utility successfully completed, ABEND 04E
    RC00C90101 in DSNODAL1 5002 was seen, since a subsequent I/O
    for a LOB MAP PAGE returned a page with all zeros.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: DB2 users.                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E 00C90101 ERQUAL5002 in         *
    *                      DSNODAL1 when accessing a LOB space     *
    *                      after a LOAD utility has been run.      *
    *                                                              *
    *                      ABEND04E RC00C200A4 in DSNB5COM during  *
    *                      a LOAD, followed by DB2 subsystem       *
    *                      termination RC00E50702.                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When a LOAD utility is updating multiple LOG NO LOB spaces,
    there is a timing window in which DB2 may schedule a second
    write engine for a LOB while one is already running.  Since the
    LOB is opened in format-write mode, the concurrent running of
    multiple write engines can result in previously formatted pages
    being written over with zeroes, which can cause a subsequent
    ABEND04E RC00C90101 in DSNODAL1.  It may also result in a write
    I/O failure which causes an ABEND04E RC00C200A4 in DSNB5COM,
    bringing down DB2.
    

Problem conclusion

  • The logic which drives writes for LOG NO LOBs has been modified
    to ensure that a second write engine will not be scheduled if
    the LOB is being accessed in format-write mode.
    

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

APAR Information

  • APAR number

    PM82763

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-13

  • Closed date

    2013-03-13

  • Last modified date

    2013-04-02

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

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

    UK92490

Modules/Macros

  • DSNB1FLW
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK92490

       UP13/03/28 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"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 April 2013