PM87540: HAAB366W NOT DISPLAYED WHEN REORG TS CONTAINS PARALLEL NO

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• At JCL build time, warning message HAAB366W is not being
  displayed in the following circumstances:
  1. When REORG TABLESPACE syntax contains PARALLEL NO syntax
  2. When REORG TABLESPACE sytax does not contain the PARALLEL
     keyword,  and the default value for PARALLEL (in DSNZPARMS)
    is "NO".
  .
  In both instances above, PARALLEL NO results in a sequential
  execution of the partitions being REORG'd - thus overriding any
  Group Partitions By (GPB) specifications.  Multiple REORGs of
  any NPI (non-partitioning indexes) will then result.
  
  When this occurs, message HAAB366W should be displayed, alerting
  the user to the fact that their GPB specifications are being
  overridden.
  .
  Additionally, other messages related to Group Partitions By
  should be suppressed.
  

Local fix

Problem summary

• USERS AFFECTED: Users of DB2 Automation Tool.
  
    PROBLEM DESCRIPTION: At JCL build time, warning message
                         HAAB366W is not being displayed in the
                         following circumstances:
                         1. When REORG TABLESPACE syntax
                          contains PARALLEL NO syntax
                         2. When REORG TABLESPACE sytax does not
                          contain the PARALLEL keyword,  and
                          the default value for PARALLEL (in
                          DSNZPARMS  is "NO".
                         In both instances above, PARALLEL NO
                         results in a sequential execution of
                         the partitions being REORG'd - thus
                         overriding any Group Partitions By
                         (GPB  specifications.  Multiple REORGs
                         of any NPI (non-partitioning indexes
                         will then result.
                         When this occurs, message HAAB366W
                         should be displayed, alerting the user
                         to the fact that their GPB
                         specifications are being overridden.
                         Additionally, other messages related
                         to Group Partitions By should be
                         suppressed.
  
    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:

  UK95223 UK95224

Modules/Macros

• HAA$BMSG HAA#BPRI HAADISPT HAAHUREO HAAHVREO
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R310 PSY UK95223

     UP13/06/27 P F306

• 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.