IBM Support

IC80695: 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.
    
    Client re-route is one method that can potentially flow
    EXCSQLSET drda request frequently.
    
    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.7                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Version 9.7 FixPack 6.                            *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 9.7 FixPack 6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC80695

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-01-06

  • Closed date

    2012-06-06

  • Last modified date

    2012-06-06

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

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

    IC80713 IC81265 IC84332

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC80695

Modified date: 06 June 2012