IBM Support

PM35200: NEW FUNCTION: SPATIAL INDEX SUPPORT BY DB2 UTILITIES REORG TABLESPACE, REORG INDEX, REBUILD INDEX, AND CHECK INDEX

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • This is a new function for DB2 9 for z/OS.  The new function
    introduces spatial index support by utilities REORG TABLESPACE,
    REORG INDEX, REBUILD INDEX, and CHECK INDEX.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 for z/OS utility users of REORG    *
    *                 TABLESPACE, REORG INDEX, REBUILD INDEX, and  *
    *                 CHECK INDEX utilities.                       *
    ****************************************************************
    * PROBLEM DESCRIPTION: Enable spatial index support for REORG  *
    *                      TABLESPACE, REORG INDEX, REBUILD INDEX, *
    *                      and CHECK INDEX utilities.              *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION: Apply appropriate PTF.                       *
    ****************************************************************
    This APAR will enable spatial support for REORG TABLESPACE,
    REORG INDEX, REBUILD INDEX, and CHECK INDEX utilities.
    (SHRLEVEL CHANGE is not supported for spatial, however,
    and MSGDSNU076 is issued is specified on these utilities.)
    There are no external changes to these utilities as a
    result of this APAR.  With this APAR, DEFER YES is
    allowed on a spatial index in DB2 9 NFM.
    

Problem conclusion

Temporary fix

Comments

  • Code has been changed to enable spatial support by the
    REORG TABLESPACE, REBUILD INDEX, and CHECK INDEX utilities.
    

APAR Information

  • APAR number

    PM35200

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function

  • Submitted date

    2011-03-18

  • Closed date

    2011-10-21

  • Last modified date

    2011-12-02

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

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

    UK73143

Modules/Macros

  •    DSNDMSI  DSNDUKIT DSNDURTB DSNDUSU  DSNHSM5X
    DSNIPROW DSNIRLPG DSNUCINM DSNUCINT DSNUCRIB DSNUCRIX DSNUCRUL
    DSNUGSRI DSNUKINM DSNUKINT DSNUKIUL DSNUKPIK DSNUK001 DSNURFIT
    DSNURPUI DSNURWBF DSNURWIK
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK73143

       UP11/11/08 P F111

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: 910

Reference #: PM35200

Modified date: 02 December 2011


Translate this page: