IBM Support

JR40084: FEDERATED PACKAGE WILL BE INVALIDATED IF WE SWITCH DATA SOURCE BY ALTERING THE SERVER OPTIONS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If you switch the federated server's data source by altering the
    "DBNAME" and "NODE" options of this server, Federation Server
    will invalidate all the related packages by default. This
    potentially requires that all the invalidated packages should be
    rebound if you need to use the nicknames under this server. And
    sometimes application will encounter deadlock during implicit
    rebinding packages.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * The user is running "ALTER SERVER ..." operation while       *
    * accessing the nicknames at the same time.                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description for details.                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Federation Server V95FP9 or later.                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Federation Server V9.5 FP9.
    
    A new server option DB2_SWITCH_DS_NO_PLAN_INVAL was added with
    the
    fix. Setting this option to 'Y' can avoid invalidating the
    related packages while altering the "DBNAME" or "NODE" options
    of the server:
    alter server <servername> options(set
    db2_switch_ds_no_plan_inval 'Y')
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR40084

  • Reported component name

    FEDERATION SERV

  • Reported component ID

    5724N9700

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-07-13

  • Closed date

    2012-03-12

  • Last modified date

    2013-12-09

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    JR40089

Fix information

  • Fixed component name

    FEDERATION SERV

  • Fixed component ID

    5724N9700

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPY","label":"General Issues"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
09 December 2013