IBM Support

PH32032: SUBSTR SELECTION OF A LOB RESULTING IN ABND04E 00C90101 DSNOGLOB:51F7

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SUBSTR selection of a LOB resulting in ABND04E 00C90101
    DSNOGLOB:51F7 when LOB is highly compressed and the substring
    begins on a section of LOB that can be mapped to a LOB entry
    with only 1 page.
    Example of LOB map entries from LOB map page on DSN1PRNT:
    LOB MAP ENTRIES, COUNT = 0CC3
    LOB MAP ENTRY:SECT#='0000'X LMEFLAGS='F0'X LMSTOTLEN='0FF00002'x
    LOB MAP ENTRY:SECT#='0001'X LMEFLAGS='F0'X LMSTOTLEN='0FF00001'x
    LOB MAP ENTRY:SECT#='0002'X LMEFLAGS='F0'X LMSTOTLEN='0FF00001'x
                      SUBSTR starts on lob entry with 1 page ^
    LOB MAP ENTRY:SECT#='0003'X LMEFLAGS='F0'X LMSTOTLEN='0FF00001'x
    LOB MAP ENTRY:SECT#='0004'X LMEFLAGS='F0'X LMSTOTLEN='0FF00001'x
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Db2 12 for z/OS users with compressed                    *
    * LOB table space                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * SUBSTR of compressed LOB resulting in                        *
    * ABND04E 00C90101 DSNOGLOB:51F7                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    A SUBSTR selection of a compressed LOB could result in an
    ABND04E when the start of the substr happens to fall on a
    portion of LOB that is mapped by a 1 page section.
    Example of LOB map entries from LOB map page on DSN1PRNT:
    LOBMAP ENTRIES, COUNT = 0CC3
    LOBMAP ENTRY:SECT#='0000'X LMEFLAGS='F0'X LMSTOTLEN='0FF00002'x
    LOBMAP ENTRY:SECT#='0001'X LMEFLAGS='F0'X LMSTOTLEN='0FF00001'x
    LOBMAP ENTRY:SECT#='0002'X LMEFLAGS='F0'X LMSTOTLEN='0FF00001'x
                         SUBSTR starts on lob entry with 1 page ^
    LOBMAP ENTRY:SECT#='0003'X LMEFLAGS='F0'X LMSTOTLEN='0FF00001'x
    LOBMAP ENTRY:SECT#='0004'X LMEFLAGS='F0'X LMSTOTLEN='0FF00001'x
    In this case, Db2 tried to process additional pages instead of
    the one page for the section.
    

Problem conclusion

  • Db2 code is changed to correctly process only 1 page when a
    section is mapped to only 1 page..
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH32032

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-11-24

  • Closed date

    2021-01-12

  • Last modified date

    2021-02-01

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

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

    UI73439

Modules/Macros

  • DSNOMAPX
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI73439

       UP21/01/20 P F101 ¢

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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"12.0"}]

Document Information

Modified date:
02 February 2021