PK98678: INSERT FAILS ON A PBG TABLE WITH SQLCODE904 DSNT408I 00D70011

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • An extend failure occurs on the first partition of a two part,
    partition by growth, PBG , table. The first partition is full,
    while the second part is half full.
    Messages DSNP007I ( MSGDSNP007I ) DSNPXTN0 - EXTEND FAILED
    RC00D70011 and DSNT408I SQLCODE = -904 UNAVAILABLE RESOURCE
    REASON 00D70011, TYPE OF # RESOURCE 00000220 are also seen
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 users using PBG table spaces         *
    ****************************************************************
    * PROBLEM DESCRIPTION: The INSERT gets SQL -904 with reason    *
    *                      code 00D70011                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Inserting system page into a partition which does not have
    any available space for system page failed with SQL -904
    reason code 00D70011 on the partitioned by growth (PBG)
    table space.
    The inserting of a system page process failed to detect the 4G
    data set boundary and triggered data set extend instead of
    moving onto the next partition in the PBG table space.
    The extend process triggered SQL -904 error.
    

Problem conclusion

  • Fixed the logic to detect 4G data set boundary on the first
    insert to the system page.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK98678

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / CST

  • Submitted date

    2009-10-15

  • Closed date

    2009-12-15

  • Last modified date

    2010-02-01

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

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

    UK53073

Modules/Macros

  • DSNISEGF
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK53073

       UP10/01/06 P F001

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.



Document information


More support for:

DB2 for z/OS

Software version:

9.1

Reference #:

PK98678

Modified date:

2010-02-01

Translate my page

Content navigation