A fix is available
APAR status
Closed as new function.
Error description
New function--Plan Stability. (DK266)
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: DB2 users of REBIND PACKAGE who intend * * to utilize new function to preserve * * multiple package copies. * * * **************************************************************** * PROBLEM DESCRIPTION: With the use of new options, REBIND * * PACKAGE will preserve multiple package * * copies, and allow users to switch back * * to an older copy. * * * **************************************************************** * RECOMMENDATION: * **************************************************************** This PTF supports the following function: 1. A new REBIND PACKAGE option called PLANMGMT that can be used to control whether REBIND PACKAGE saves old package copies. This option has three possible settings - OFF, BASIC and EXTENDED. PLANMGMT(OFF) - No change to existing behavior. A package continues to have one active copy PLANMGMT(BASIC) - A package has one active copy, and one additional old copy (PREVIOUS) is preserved. PLANMGMT(EXTENDED) - A package has one active copy, and two additional old copies (PREVIOUS and ORIGINAL) are preserved. Preserving old copies has no impact on query performance. However, using the PLANMGMT(BASIC) option can double the DASD consumption in tablespace SPT01, and using the PLANMGMT(EXTENDED) option can triple it. The extra space is needed to maintain old copies. In addition, using the BASIC or EXTENDED option adds a 10-40% CPU overhead to the performance of the REBIND PACKAGE command. 2. A new system parameter called PLANMGMT for specifying the default setting of PLANMGMT option of REBIND PACKAGE. Possible settings are: OFF, BASIC and EXTENDED. The default value of this parameter is OFF. To use a setting other than OFF, update your DB2 V9 subsystem parameter (DSNZPxxx) modules as follows: * Edit your customized copy of installation job DSNTIJUZ * Add the keyword parameter PLANMGMT=<x> -- where <x> is BASIC, EXTENDED, or OFF -- to the invocation of the DSN6SPRM macro in job step DSNTIZA. Make sure to add a continuation character in column 72 if needed. * Run the first two steps of the DSNTIJUZ job you modified, to assemble and link the load module. * After the job completes, you must either use the SET SYSPARM command or stop and start DB2 for the change to take effect. 3. A new REBIND PACKAGE option called SWITCH to allow users to revert a package to an older copy, effectively undoing a prior REBIND invocation. SWITCH(PREVIOUS) - The PREVIOUS copy is activated SWITCH(ORIGINAL) - The ORIGINAL copy is activated 4. A new FREE PACKAGE option called PLANMGMTSCOPE to allow users to free older copies that are no longer necessary. PLANMGMTSCOPE(ALL) - Free the entire package including all copies. This is the default. PLANMGMTSCOPE(INACTIVE) - Free all old copies For additional details, refer to DB2 product documentation.
Problem conclusion
Temporary fix
Comments
DB2 users concerned about access path regressions seen after REBIND PACKAGE command can use the new function to preserve and restore old access paths. However, unless directed otherwise, the function is not intended for use when DB2 Service recommends a REBIND PACKAGE.
APAR Information
APAR number
PK52523
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function
Submitted date
2007-09-07
Closed date
2007-12-06
Last modified date
2008-01-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK31993
Modules/Macros
DSN@ZP DSNDDDRB DSNDEDM DSNDEDMB DSNDEDMC DSNDQSD DSNDRCIB DSNDSIB DSNECPFC DSNECP00 DSNECP08 DSNECP19 DSNECP41 DSNECP42 DSNECP45 DSNECP46 DSNECP47 DSNFMDIR DSNFTDIR DSNFTDTA DSNGEDB1 DSNGEDLT DSNGEFLC DSNGEIST DSNGELOC DSNGEPDL DSNGEPIS DSNGEPLC DSNLXRCM DSNLXRCS DSNTBAB2 DSNTBAP DSNTBAR DSNTBAS2 DSNTBFR2 DSNTBMSG DSNTBRB2 DSNTCT DSNWZP DSNXIDPM DSNXOIU1
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
R910 PSY UK31993
UP07/12/22 P F712
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":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 January 2008