PM03078: GENERATE REORG FOR PARTITIONS OF A TABLESPACE WITH NPIS INTO A SINGLE JOBSTREAM

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This enhancement enables partitioned tablespaces with NPIs to be
  generated into a single jobstream for a REORG utility since DB2
  V9 does not allow parallel REORG jobs of those partitioned
  spaces.
  
  A new field called "Group partitions" was added to the HAA$UREO
  REORG Utility Profile panel that enables this new feature.
  
  IMPORTANT:
  1) This Feature in DB2 Automation Tool generates syntax that is
     dependent on DB2 APAR PK87762.  This DB2 APAR must be
     applied.
  2) The "following" feature (generating non-consecutive
      parts into a single statement) will not be supported
      for REORGs using LISTDEFS.
  
  Also, Non consecutive partitions  will be generated in a single
  statement when this enhancement is complete.  An example of this
  would be:
  
  If, for example, parts 1, 2, 3, and 5 are included, Automation
  Tool currently generates a separate REORG statement for each
  partition as in the below example:
  
          REORG TABLESPACE DBNAME.TSNAME
          PART 1
          REORG TABLESPACE DBNAME.TSNAME
          PART 2
          REORG TABLESPACE DBNAME.TSNAME
          PART 3
          REORG TABLESPACE DBNAME.TSNAME
          PART 5
  
  With this enhancement, Automation Tool will now group the REORG
  statements for all partitions as in the following example:
  
         REORG TABLESPACE DBNAME.TSNAME
          PART (1:3,5)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: This enhancement enables partitioned    *
  *                      tablespaces with NPIs to be generated   *
  *                      into a single jobstream for a REORG     *
  *                      utility since DB2 V9 does not allow     *
  *                      parallel REORG jobs of those            *
  *                      partitioned spaces. A new field called  *
  *                      "Group partitions" was added to the     *
  *                      HAA$UREO REORG Utility Profile panel    *
  *                      that enables this new feature.          *
  *                      IMPORTANT: The "following" feature      *
  *                      (generating non-consecutive parts into  *
  *                      a single statement) will not be         *
  *                      supported for REORGs using LISTDEFs.    *
  *                      Also, Non consecutive partitions  will  *
  *                      be generated in a single statement when *
  *                      this enhancement is complete.  An       *
  *                      example of this would be:               *
  *                      If, for example, parts 1, 2, 3, and 5   *
  *                      are included, Automation Tool currently *
  *                      generates a separate REORG statement    *
  *                      for each partition as in the below      *
  *                      example:                                *
  *                           REORG TABLESPACE DBNAME.TSNAME     *
  *                           PART 1                             *
  *                           REORG TABLESPACE DBNAME.TSNAME     *
  *                           PART 2                             *
  *                           REORG TABLESPACE DBNAME.TSNAME     *
  *                           PART 3                             *
  *                           REORG TABLESPACE DBNAME.TSNAME     *
  *                           PART 5                             *
  *                      With this enhancement, Automation Tool  *
  *                      will now group the REORG statements for *
  *                      all partitions as in the following      *
  *                      example:                                *
  *                           REORG TABLESPACE DBNAME.TSNAME     *
  *                           PART (1:3,5)                       *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

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$BCPY HAA$BMSG HAA$BULD HAA$BULJ HAA$BUTC
  HAA$BUTI HAA$BUTJ HAA$BUTM HAA$BUTP HAA$BUTQ HAA$BUTR HAA$BUTT
  HAA$BUTX HAA$BUT2 HAA$CALL HAA$CVT  HAA$JBRK HAA$MAIN HAA$UOPT
  HAA$UREO HAA$VREO HAA#BPRI HAA#OBEX HAA#UPRI HAA#UTED HAA#UTOB
  HAA@BULD HAA@POBJ HAAHUREO HAAHVREO HAAREORC HAA448E  HAA52
  HAA520E
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R310 PSY UK58293

     UP10/07/02 P F007

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.