PI16739: SUPPORT NEW PARAMETERS TO CONTROL AUTO REORG/REBUILD FOR ALTER ... STOGROUP STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 ADMINISTRATION TOOL FOR Z/OS ADD
  SUPPORT NEW PARAMETERS TO CONTROL AUTO REORG/REBUILD FOR ALTER
  ... STOGROUP STATEMENT
  

Local fix

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 - Redefine Index'      *
  *                 command on panel ADB21X 'Indexes', Object    *
  *                 Compare or the Change Management (CM)        *
  *                 function to change the STOGROUP attribute    *
  *                 on Indexes.                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS     *
  *                      and DB2 Object Comparison Tool for      *
  *                      z/OS, when using the 'ALT Redefine      *
  *                      Index' line command, Object Compare,    *
  *                      CM function, and the REORG or REBUILD   *
  *                      auto utilities are being issued by      *
  *                      the Batch Restart Program ADBTEP2, a    *
  *                      duplication of the explicit utilities   *
  *                      is being executed within the Work       *
  *                      Statement List ( WSL ) or the APPLY     *
  *                      batch job for altering the STOGROUP     *
  *                      attribute on the table space or         *
  *                      index.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using  the 'ALT Redefine Index' line command, Object
  Compare the CM function, and the REORG or REBUILD auto
  utilities are being issued by the Batch Restart Program
  ADBTEP2, a duplication of the explicit utilities is being
  executed within the Work Statement List ( WSL ) or the
  APPLY batch job for altering the STOGROUP attribute on the
  table space or index.
  

Problem conclusion

• For ALT, Object Compare and CM Online paths:
  
  A new option 'Auto Reorg/Rebuild after STOGROUP change'
  has been added to panel ADB2UPA 'Batch Job Utility Parameters'
  to control whether performing an automatic REORG or REBUILD
  in Batch Restart Program ADBTEP2 for altering the STOGROUP
  attribute on the table space or index. If it is set to 'YES',
  the value 'YES' will be passed to the ADBTEP2 jobs as a
  parameter. If it is set to 'NO' or blank, no value will be
  passed to ADBTEP2 jobs because the default value to ADBTEP2 is
  'NO' when the parameter is missing.
  
  There is an exceptional case that 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 "A - All relevant', 'NO' will
  be seen as the value for this parameter during the passing of
  the value to ADBTEP2, eventhough it is set to 'YES' on panel
  ADB2UPA so that the auto utilities like REORG or REBUILD will
  not be performed after executing the alter of the STOGROUP
  statement on the table space or index, resulting in no
  duplication between these auto utilities and explicit
  utilities within the WSL or APPLY batch job.
  
  For CM Batch path:
  
  A new parameter adbtep2_stogroup_auto_reorg_rebuild has been
  added in the CM Batch jobs to control whether performing an
  automatic REORG or REBUILD in ADBTEP2 for altering the STOGROUP
  attribute on the table space or index. If the parameter
  run_reorg_rebuild is set to 'A - All relevant' for analyzing
  a change, this parameter will be reset to 'NO' for building a
  run job or running a change so that the auto utilities like
  REORG or REBUILD will not be performed after executing the
  alter of the STOGROUP statement on the table space or index,
  and the following warning message ADB9720W will be issued:
  
  ADB9720W During the <run change> process, the parameter
         adbtep2_stogroup_auto_reorg_rebuild is set to
         NO by force because the parameter run_reorg_rebuild
         has been specified to A to generate REORG and
         REBUILD utilities from the analyze process.
  
  System action: None.
  User response: None.
  
  The definition for parameter
  adbtep2_stogroup_auto_reorg_rebuild:
  
  adbtep2_stogroup_auto_reorg_rebuild
  
      The adbtep2_stogroup_auto_reorg_rebuild parameter specifies
  whether the product, when a change is run, initiates a REORG or
  REBUILD for the table space or index to implement the effect of
  altering STOGROUP attribute. For the complete description and
  list of values see Using the Batch Restart programs: ADBTEP2
  and ADBTEPA.
  
  Values:
    YES
     The product automatically attempts a REORG or REBUILD
     for the table space or index after SQL statement ALTER
     STOGROUP is executed. However, if the parameter
     run_reorg_rebuild was specified as 'A - All relevant' to
     generate an explicit REORG or REBUILD during the change
     flow, then the value NO is passed to ADBTEP2. The NO
     value prevents an automatic REORG or REBUILD that
     duplicates the explicit REORG or REBUILD.
  
    NO
     The product does not automatically attempt a REORG or
     REBUILD for the table space or index after SQL statement
  
  The following has been updated in the DB2 Administration
  Tool for z/OS User's Guide and Reference, Version 10, Release
  2 and Version 11, Release 1:
  
  1 - The new field 'Auto Reorg/Rebuild after STOGROUP
  change' has been added to panel ADB2UPA 'Batch
  Job Utility Parameters'.
     ALTER STOGROUP is executed.
  
  Default:
    NO
  
  The following has been updated in the DB2 Administration
  Tool for z/OS User's Guide and Reference, Version 10, Release
  2 and Version 11, Release 1:
  
  1 - The new field 'Auto Reorg/Rebuild after STOGROUP change'
  has been added to panel ADB2UPA 'Batch Job Utility Parameters'.
  
  2 - Added new parameter 'Auto Reorg/Rebuild after STOGROUP
  change', and also updated Tips for the existing four parameters
  'Advisory Auto Rebuild', 'Advisory Auto Reorg', 'Auto Rebuild'
  and 'Auto Reorg' under 'Using the Batch Restart programs:
  ADBTEP2 and ADBTEPA-> Parameters passed to the ADBTEP2
  program > Parameters passed under the DD name of ADBTEPIN'.
  
  3 - Added new parameter 'adbtep2_stogroup_auto_reorg_rebuild'
  for CM Batch component under 'Managing changes to DB2 objects->
  Making changes using Change Management batch interface->
  Using parameters for Change Management batch interface->
  Parameter definitions'.
  

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   ADBEALT  ADBEAPI0 ADBGAJOB ADBHUPA
  ADBTEP2  ADB2TEP  ADB2UPA  ADB2W1   ADB2000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI27293

     UP15/05/16 P F505

• RB10 PSY UI27294

     UP15/05/16 P F505

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.