PM18542: GENERATE REORG FOR PARTITIONS OF A TABLESPACE WITH NPIS INTO A SINGLE JOBSTREAM USING THE GROUP PARTITIONS FEATURE WITH DB2 V9

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• APAR PM03078 enabled Partitioned Tablespaces with NPIs to be
  generated into a single jobstream for a REORG utility for DB2
  V9 New Function Mode (NFM) only.
  .
  This APAR allows DB2 Automation Tool to generate REORG for
  partitions of a tablespace with NPIs into a single jobstream
  using the Group Partitions feature with DB2 V9 Compatibility
  Mode (CM mode) as well.
  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.
  .
  This APAR also corrects a problem so that "Group Partitions by"
  must be set to J or S to have disjointed partitions generated
  into the JCL jobs.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: APAR PM03078 enabled Partitioned        *
  *                      Tablespaces with NPIs to be generated   *
  *                      into a single jobstream for a REORG     *
  *                      utility for DB2 V9 New Function Mode    *
  *                      (NFM) only.                             *
  *                      This APAR allows DB2 Automation Tool    *
  *                      to generate REORG for partitions of a   *
  *                      tablespace with NPIs into a single      *
  *                      jobstream using the Group Partitions    *
  *                      feature with DB2 V9 Compatibility       *
  *                      Mode (CM mode) as well.                 *
  *                      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.           *
  *                      This APAR also corrects a problem so    *
  *                      that "Group Partitions by" must be set  *
  *                      to J or S to have disjointed partitions *
  *                      generated into the JCL jobs.            *
  ****************************************************************
  * 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:

  UK59581

Modules/Macros

• HAA$BCPY HAA$BUTH HAA$BUTR HAA$JOBR HAA$JOBV
  HAA$JOPT HAA$JOPV HAA#UPRI HAAM38   HAAM383E
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R310 PSY UK59581

     UP10/08/11 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.