IBM Support

PK65220: DK1053: EXTEND APPEND KEYWORD TO LOB TABLE SPACE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • DK1053: EXTEND APPEND KEYWORD TO LOB TABLESPACE
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 for z/OS users of LOB table space    *
    ****************************************************************
    * PROBLEM DESCRIPTION: DCR DK1053 :                            *
    *                      The exhaustive space search on LOB      *
    *                      table space caused high getpage rate.   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When applications use LOBs in a transactional manner with
    mostly INSERT and little DELETE/UPDATE on the LOB, the
    exhaustive space search process could lead to a very high
    getpage rate on the LOB table space and further degrade the
    INSERT performance.
    
    DK1053 :
    The "APPEND" clause on the base table is extended to be
    specified on the LOB table via CREATE AUX TABLE DDL statement
    or ALTER TABLE DDL  statement in V9 NFM.
    When APPEND clause is used on the LOB table, it will instruct
    DB2 to only search free space at the end of table space
    and extend table space when it is necessary.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PK65220

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-04-28

  • Closed date

    2008-10-30

  • Last modified date

    2008-12-02

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

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

    UK41212

Modules/Macros

  • DSNDXID  DSNDXSB1 DSNHAPLY DSNHBNF  DSNHPNAM
    DSNHPTAB DSNHSML2 DSNHSYMH DSNOALLO DSNXIATB DSNXICB7 DSNXICDR
    DSNXIPGA DSNXISB1
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK41212

       UP08/11/18 P F811

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 #: PK65220

Modified date: 02 December 2008