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

DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

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 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