Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC90520 Status: Closed

SQL0973 NO MEMORY IN PACKAGE CACHE WHEN USING INSUFFICIENT FIXED DATABASE
MEMORY SETTING

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
When a configuration has an insufficient database memory 
setting, DB2 overrides the setting, calculating a database 
memory size which will support the configuration - including a 
5% overflow.  One of the main uses of the overflow is for 
package cache overhead - which can be as much 100% in the worst 
case.  If package cache is 10000 4K pages or 40MB, it may need 
an additional 40MB from database memory overflow to support 
package cache requirements. 
 
This APAR will add additional overflow for package cache - the 
amount will be the equivalent of the package cache setting - and 
only for the specific case of insufficient database memory 
settings.  Note this has no impact on STMM configurations, where 
overflow is already maintained by STMM. 
 
When using a fixed database_memory setting, monitor the 
"Unreserved" column in db2pd -db <db> -memsets output.  If this 
value approaches 0, the system is in danger of database overflow 
exhaustion, and application requests may fail with SQL0973 
errors. 
 
Case with sufficient overflow (Unreserved is 245MB out of a 
configured size of 1489MB) 
Memory Sets: 
Name         Address            Id          Size(Kb)   Key 
DBP    Type   Unrsv(Kb) 
SAMPLE       0x0700000040000000 2097196     1489920     0x0 
0      1      245760 
 
Case with insufficient overflow (Unreserved is 2MB out of a 
configured size of 1489MB) 
Memory Sets: 
Name         Address            Id          Size(Kb)   Key 
DBP    Type   Unrsv(Kb) 
SAMPLE       0x0700000040000000 2097196     1489920     0x0 
0      1      1842 
 
Example db2diag.log entry: 
FUNCTION: DB2 UDB, access plan manager, sqlra_cache_fill_pkg, 
probe:600 
RETCODE : ZRC=0x8B0F0007=-1961951225=SQLO_NOMEM_PCKCACHEH 
          "No memory available in 'Package Cache'" 
          DIA8300C A memory heap error has occurred.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* systems using a fixed DATABASE_MEMORY setting                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 9                        * 
****************************************************************
Local Fix:
Ensure the database memory setting is sufficient to support the 
configuration.  If encountering SQL0973 due to no memory in 
package cache, database_memory can be increased dynamically to 
allow for additional overflow.  Do not increase the package 
cache setting as this will tend to exacerbate the problem.
available fix packs:
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Problem first fixed in DB2 Version 9.7 Fix Pack 9
Workaround
See local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC91242 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
27.02.2013
08.07.2013
08.07.2013
Problem solved at the following versions (IBM BugInfos)
9.7.FP9
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.9 FixList
9.7.0.9 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.