IBM Support

PK52523: NEW FUNCTION -- PLAN STABILITY

A fix is available

Subscribe

You can track all active APARs for this component.

 

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