PM90790: VARIOUS FIXES FOR 'GROUP PARTITIONS BY' FOR DB2 11

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Changes related to 'Group Partitions By' and DB2 11:
  1) The following message is removed:
  HAAB366W Group Parts By for utility turned off because LISTPARTS
  nnnn was specified and there are nnnn objects being REORGed.
  
  and replaced with the following new messages:
  
  a) HAAB366W - Group Parts By for utility turned off because
  LISTPARTS 1 was secified.
  
  b) HAAB366W - Group Parts By for utility will be performed but
  will be limited by he number of LISTPARTS specified (nnnn).
  
  2) If LISTPARTS is blank, the default is based upon the value of
  the DSNZPARM parameter REORG_LIST_PROCESSING (value can be
  either "PARALLEL" or "SERIAL").  If value is "SERIAL", message
  HAAB366W will be displayed at build time.
  
  3) LISTPARTS keyword is erroneously being generated in the
  LISTDEF statement syntax rather than in the REORG TABLESPACE
  utility syntax.
  
  4) Message HAAB575W - remove excessive spacing from message
  text.
  

Local fix

Problem summary

• USERS AFFECTED: Users of DB2 Automation Tool.
  
    PROBLEM DESCRIPTION: Changes related to 'Group Partitions
                         By' and DB2 11:
                         1. The following message is removed:
                         HAAB366W Group Parts By for utility
                         turned off because LISTPARTS nnnn was
                         specified and there are nnnn objects
                         being REORGed.
                         and replaced with the following new
                         messages:
                         a. HAAB366W - Group Parts By for
                         utility turned off because LISTPARTS 1
                         was secified.
                         b. HAAB366W - Group Parts By for
                         utility will be performed but will be
                         limited by he number of LISTPARTS
                         specified (nnnn .
                         2. If LISTPARTS is blank, the default
                         is based upon the value of the
                         DSNZPARM parameter
                         REORG_LIST_PROCESSING (value can be
                         either "PARALLEL" or "SERIAL" .  If
                         value is "SERIAL", message HAAB366W
                         will be displayed at build time.
                         3. LISTPARTS keyword is erroneously
                         being generated in the LISTDEF
                         statement syntax rather than in the
                         REORG TABLESPACE utility syntax.
                         4. Message HAAB575W - remove excessive
                         spacing from message text.
  
    RECOMMENDATION: APPLY the PTF.
  
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

APAR Information

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

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

Modules/Macros

• HAADISPT
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R410 PSY UK95224

     UP13/06/27 P F306

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.