PI07305: CM RUN INCORRECTLY GENERATES DUPLICATE REBUILD INDEXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS Change Management function
  Generates duplicate Rebuild Indexes when the following options
  are set:
    ADBTEP2_ADVISORYAUTOREBUILD = 'YES'
    ADBTEP2_AUTOREBUILD = 'YES'
    RUN_REORG_REBUILD  = 'M'
  

Local fix

• remove duplicate rebuild statement
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS and DB2 Object Comparison Tool      *
  *                 for z/OS who use the 'ALT Alter Table'       *
  *                 (ALT), Object Compare ( OC ) or              *
  *                 Change Management ( CM ) functions.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS     *
  *                      and DB2 Object Comparison Tool for      *
  *                      z/OS, when using ALT, OC or CM          *
  *                      functions, the AUTO utilities like      *
  *                      REORG or REBUILD being issued by the    *
  *                      Batch Restart Program ADBTEP2 cause a   *
  *                      duplication of the explicit             *
  *                      utilities within the Work Statement     *
  *                      List (WSL) or APPLY batch job being     *
  *                      executed later.                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the ALT, OC or CM functions, the AUTO utilities
  like REORG or REBUILD being issued by the Batch Restart Program
  ADBTEP2 cause a duplication of the explicit utilities within
  the Work Statement List (WSL) or APPLY batch job being executed
  later.
  

Problem conclusion

• For the ALT, OC and CM Online paths:
  
  If the option "Run REORG/REBUILD" on panel ADBPALT 'Build
  Analyze and Apply Job', on panel GOC5 'Generate Compare Jobs'
  or on panel ADB2C11A 'Generate Analyze Job' is set to "M -
  Mandatory", the values "NO" will be passed to the Batch Restart
  Program ADBTEP2 for the parameters "Auto Rebuild" and "Auto
  Reorg" though these parameters are set to "YES" on panel
  ADB2UPA 'Batch Job Utility Parameters' so that AUTO utilities
  like REORG or REBUILD will not be performed for the object in
  one of these Pending states:  REORP, RBDP, RBDP* and PSRBD
  at run-time because these auto utilities will cause a
  duplication of the explicit utilities within the Work
  Statement List (WSL) or APPLY batch job being executed
  later.
  
  If the option "Run REORG/REBUILD" was set to "A - All
  relevant", the values "NO" will be passed to Batch Restart
  Program ADBTEP2 for the parameters "Auto Rebuild",
  "Auto Reorg", "Advisory Auto Rebuild" and "Advisory Auto
  Reorg" though these parameters are set to "YES" on panel
  ADB2UPA so that AUTO utilities like REORG or REBUILD will
  not be performed for the object in one of these Pending
  states and Advisory Pending status: REORP, RBDP, RBDP*,
  PSRBD, AREOR, AREO* and ARBDP at run-time because these
  AUTO utilities will cause a duplication of the explicit
  utilities within the Work Statement List (WSL) or APPLY
  batch job being executed later.
  
  For the CM Batch path:
  
  If the parameter "run_reorg_rebuild" is set to "M - Mandatory"
  for analyzing a change, the parameters "adbtep2_autorebuild"
  and "adbtep2_autoreorg" will be reset to "NO" for building a
  run job or running a change so that AUTO utilities like REORG
  or REBUILD will not be performed for the object in one of
  these pending states: REORP, RBDP, RBDP* and PSRBD at
  run-time, and also the following warning message ADB9720W
  will be issued.
  
  If the parameter "run_reorg_rebuild" is specified to "A - All
  relevant" for analyzing a change, the parameters
  "adbtep2_autorebuild", "adbtep2_autoreorg",
  "adbtep2_advisoryautorebuild" and "adbtep2_advisoryautoreorg"
  will be reset to "NO" for building a run job or running a
  change that AUTO utilities like REORG or REBUILD will not be
  performed for the object in one of these Pending states and
  Advisory Pending status: REORP, RBDP, RBDP*, PSRBD, AREOR,
  AREO* and ARBDP at run-time, and also the following warning
  message ADB9720W will be issued.
  
  ADB9720W    During the >run change< process, the parameter
              >adbtep2_autoreorg< is set to NO by force
              because the parameter run_reorg_rebuild has been
              specified to >M< to generate REORG and REBUILD
              utilities fromthe analyze process.
  System action: None.
  User response: None.
  

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

•    ADBCCM   ADBEAPI0 ADBGAJOB ADBHUPA  ADBTEP2
  ADB2TEP  ADB2W1   ADB9000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI20892

     UP14/08/29 P F408

• RB10 PSY UI20893

     UP14/08/30 P F408

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.