IBM Support

IC81265: PACKAGE CACHE MAY BE FILLED UP WITH MANY VARIATIONS OF "SET CURRENT ..." STATEMENTS.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • package cache may be filled up with variations of "SET
    CURRENT... "
    statement when these statements are sent via the EXCSQLSET drda
    request, sent to db2 server.
    This request type is the case when client reroute support is
    configured
    
    This problem can be confirmed with db2pd -db <dbname> -dynamic
    at "Dynamic SQL Variations:" section. Following is the sample of
    output showing high number of VarID column on the same
    AnchID,StmtUID, with Val column showing "N" ( not valid )
    
    Address            AnchID StmtUID    EnvID      VarID
    NumRef     Typ Lockname                   Val Insert Time
    Sect Size
    
    0x0700000311DD0080 255    1          1          294289     1
    9   0000000100047D9100011FE256 N   2012-01-04-22.30.39.555702
    1736
    0x0700000311DE6E00 255    1          1          294288     1
    9   0000000100047D9000011FE256 N   2012-01-04-22.30.39.467800
    1736
    0x0700000311DE52A0 255    1          1          294287     1
    9   0000000100047D8F00011FE256 N   2012-01-04-22.30.39.201001
    1736
    0x0700000311DE3740 255    1          1          294286     1
    9   0000000100047D8E00011FE256 N   2012-01-04-22.30.39.107542
    1736
    0x0700000311DE1BE0 255    1          1          294285     1
    9   0000000100047D8D00011FE256 N   2012-01-04-22.30.39.011197
    1736
    0x0700000311DE0080 255    1          1          294284     1
    9   0000000100047D8C00011FE256 N   2012-01-04-22.30.38.924375
    1736
    0x0700000311DF6E00 255    1          1          294283     1
    9   0000000100047D8B00011FE256 N   2012-01-04-22.30.38.222125
    1736
    
    
    These redundant variation can not be flushed with "db2 flush
    package cache dynamic"
    

Local fix

  • Reduce the package cache size, as these redundant variation will
    be dropped from package cache when db2 see package cache filled
    up to configured size, and it need new space in package cache.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 UDB Version 9.5.                                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error description field for more information.            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Version 9.5 FixPack 10.                           *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 9.5 FixPack 10.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC81265

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-02-07

  • Closed date

    2012-08-28

  • Last modified date

    2012-08-28

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

    IC80695

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
28 August 2012