A fix is available
APAR status
Closed as new function.
Error description
Enhancement to the REORG utility in V9.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 9 for z/OS users of REORG TABLESPACE * * and LISTDEF utility. * **************************************************************** * PROBLEM DESCRIPTION: New function for REORG TABLESPACE and * * LISTDEF utility. * **************************************************************** * RECOMMENDATION: Apply PTF when available. * **************************************************************** New function for REORG TABLESPACE and LISTDEF utility. The Utility Guide and Reference is updated with the following: ________________________________________________________________ The REORG TABLESPACE utility has extended syntax specification for the PART keyword: >-+--------------------------------------+----> | +------------,------------+ | | V | | +-PART-(-+--+-integer-----------+--+-)---+ +-integer1:integer2-+ | The PART specification is extended to allow for multiple parts | or part ranges. This applies to all SHRLEVEL of REORG | TABLESPACE. REORG will eliminate duplicate and/or overlapping | partition range specifications. Existing program logic will | issue MSGDSNU256I on invalid partition number specified and | terminate with return code 8. | Example: REORG TABLESPACE PART (1, 3:5, 254:257) ________________________________________________________________ The LISTDEF utility is changed so that it will invoke a single REORG TABLESPACE to process all the adjacently specified data partitions, instead of invoking a separate REORG on each specified partition. For example: LISTDEF X INCLUDE TABLESPACE dbb.tss PARTLEVEL 3 INCLUDE TABLESPACE dbb.tss PARTLEVEL 5 REORG TABLESPACE LIST X Prior to PK87762, LISTDEF would invoke one REORG to process partition 3, follows serially by another REORG to process partition 5 in the above example. After applying the PTF of PK87762, LISTDEF will invoke a single REORG to process partition 3 and 5 in a single REORG job, as if REORG TABLESPACE PART(3,5) is specified. ________________________________________________________________
Problem conclusion
Temporary fix
Comments
Code has been modified to provide the aforementioned new utility function. ž**** PE10/09/16 FIX IN ERROR. SEE APAR PM22336 FOR DESCRIPTION
APAR Information
APAR number
PK87762
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
2009-06-02
Closed date
2010-07-23
Last modified date
2010-11-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK59095
Modules/Macros
DSNDUCA DSNDUJB DSNDURXA DSNDUSM DSNDUSMM DSNDUSU DSNDUTKN DSNUGDDM DSNUGDFL DSNUGPDS DSNUGPPM DSNUGPRT DSNUGPRV DSNUGRNG DSNUGUCA DSNUGULM DSNURBXA DSNURBXE DSNURFBR DSNURFIT DSNURPUI DSNURSCN
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
R910 PSY UK59095
UP10/08/14 P F008
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:
04 November 2010