IBM Support

PH08620: ABEND04E RC00C90101 DSNOGLOB ERQUAL51F7

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • An abend occurred with the following title:
    DSN ,ABND=04E-00C90101,U=xxxxxxx ,M=N
     ,C=121.LOCN=::xx.xx.xx.xxx     ,LOC=DSNIDM  .DSNOGLOB:51F7
                                                                   .
    Db2 code checked if a zEDC device was available to inflate LOB
    data, and received back that it was, so set a flag to indicate
    software inflation was not being used.
    This was via the FPZ4ABC service .
    However when the service request was made, the zEDC cards had
    been deactivated and rc04 rsn2000 was returned to Db2.
    The reason 2000 indicates: 'No zEDC devices are available.
    Inflate is completed in software when hardware is not available'
                                                                   .
    The decompression itself was successful.
    However Db2 had already set the flag to indicate software
    inflation was not being used and this then tripped the abend as
    Db2 thought the inflate hadn't been successful, when it was.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Db2 12 for z/OS users of the LOB                         *
    * zEnterprise Data Compression(zEDC).                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * An ABEND04E RC00C90101 at                                    *
    * DSNOGLOB ERQUAL51F7 might occur when                         *
    * fetching a compressed LOB column.                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    An ABEND04E RC00C90101 at DSNOGLOB ERQUAL51F7 might occur when
    fetching a compressed LOB column.
    
    The reason for the abend is that Db2 fails to recognize the
    reason code indicating that the LOB has been inflated using
    software. As a result, the reported intentional abend is
    generated.
    
    Additional keywords: SQLLOB
    

Problem conclusion

  • Db2 is corrected to recognize the reason code for software
    inflate to avoid the abend.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH08620

  • 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

    2019-02-15

  • Closed date

    2019-04-01

  • Last modified date

    2019-05-02

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

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

    UI62256

Modules/Macros

  • DSNOGLOB
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI62256

       UP19/04/16 P F904

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":"12.0","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":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 May 2019