PM86933: MISCELLANEOUS FIXES TO GROUP PARTITIONS BY LOGIC

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The following issues are addressed in this APAR:
  1) For DB2 versions below V10, specifying Group Partition By
    (GPB) = "S" or "J" with LISTDEF results in message HAAB377I
    being displayed at job build time. HAAB377I should not be
    displayed since LISTDEF does not support more than one
    PARTLEVEL number. New message HAAB366W will be displayed
   instead (HAB366W Group Parts By for REORG TS turned off
    because DB2 Vnn LISTDEF does not support more than one
    PARTLEVEL number. LISTDEF overrides grouping of partitioned
    objects).
  .
  2) For DB2 versions below V10, specifying Group Partition By
    (GPB) = "S" or "J" with Process Dependent Indexes = "N" and
    LISTDEF = "N" results in:
  a) display of message HAAB377I at job build time.
    b) multiple REORG TABLESPACE control statements, which causes
     multiple REORG of NPIs.
  .
  The fix will produce a single REORG TABLESPACE control statement
  and NPI reorg will be minimized. Message HAAB377I will be
  displayed and the single REORG TS control statement will support
  that message.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. For DB2 versions below V10,          *
  *                      specifying Group Partition By (GPB) =   *
  *                      "S" or "J" with LISTDEF results in      *
  *                      message HAAB377I being displayed at     *
  *                      job build time. HAAB377I should not be  *
  *                      displayed since LISTDEF does not        *
  *                      support more than one PARTLEVEL number. *
  *                      New message HAAB366W will be displayed  *
  *                      instead (HAB366W Group Parts By for     *
  *                      REORG TS turned off because DB2 Vnn     *
  *                      LISTDEF does not support more than one  *
  *                      PARTLEVEL number. LISTDEF overrides     *
  *                      grouping of partitioned objects).       *
  *                      2. For DB2 versions below V10,          *
  *                      specifying Group Partition By (GPB) =   *
  *                      "S" or "J" with Process Dependent       *
  *                      Indexes = "N" and LISTDEF = "N"         *
  *                      results in:                             *
  *                      a. display of message HAAB377I at job   *
  *                      build time.                             *
  *                      b. multiple REORG TABLESPACE control    *
  *                      statements, which causes multiple       *
  *                      REORG of NPIs.                          *
  *                      The fix will produce a single REORG     *
  *                      TABLESPACE control statement and NPI    *
  *                      reorg will be minimized. Message        *
  *                      HAAB377I will be displayed and the      *
  *                      single REORG TS control statement will  *
  *                      support that message.                   *
  ****************************************************************
  * 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

• HAA$BMSG HAA$BUTR HAA#BPRI HAAGGCJ
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R310 PSY UK93686

     UP13/04/30 P F304

• R410 PSY UK93687

     UP13/04/30 P F304

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.