A fix is available
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 number
PI16739
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-04-25
Closed date
2015-05-01
Last modified date
2015-06-01
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
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 June 2015