A fix is available
APAR status
Closed as program error.
Error description
The DB2 Administration Tool for z/OS' CMBATCH Analyze generates more REBIND statements than customers expect.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration and DB2 * * Object Comparison Tool for z/OS who use * * the 'ALT Alter Table' (ALT) function, * * Compare function, or Change Management * * Batch (CM Batch) interface. * **************************************************************** * PROBLEM DESCRIPTION: When users specify 'Yes' for the 'Run * * REBIND' field on panels ADBPALT * * 'ALTER - Build Analyze and Apply * * Job' and GOC5 'Generate Compare * * Jobs' when using the ALT function, * * the Compare function, or CM Batch * * interface, rebind statements are * * generated for all packages, but can * * not be generated only for packages * * that are invalidated. * **************************************************************** * RECOMMENDATION: * **************************************************************** Users cannot specify a value for 'Run REBIND' when using ALT function, Compare function or the CM Batch interface, allowing them to only rebind invalidated packages, not all packages.
Problem conclusion
Program has been modified to update valid values for field 'Run REBIND' on panel ADBPALT, and panel GOC5, which changed from Run REBIND . . . . . . (Yes/No) to Run REBIND . . . . . . (Mandatory, All relevant, None) Change Management batch program has been updated to support new options for run_rebind parameters. run_rebind The run_rebind parameter specifies whether to generate a job to rebind plans and packages that are affected by changes that the analyze process generates. Values: M, A, N M Mandatory. Generate REBIND utility statements only for packages and plans invalidated by the change. A All relevant. Generates REBIND statements for all packages and plans affected by the change. N None. Does not generate REBIND utility statements. Default: N
Temporary fix
Comments
APAR Information
APAR number
PM91046
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
2013-06-13
Closed date
2014-03-19
Last modified date
2014-04-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADBALT ADBCCM ADBEALT ADBGAJOB ADBHALT ADBHC11A ADBPALT ADBSALT ADB2CMF ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2C11A 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:
02 April 2014