A fix is available
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.
[{"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":"9.1","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":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 December 2011