|
Problem IC95222
|
Status: Closed |
SQL0973 NO MEMORY IN PACKAGE CACHE WHEN USING INSUFFICIENT FIXED DATABASE MEMORY SETTING |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - 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 with fixed database_memory and not using STMM *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.5 Fix Pack 3 *
**************************************************************** |
| 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 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem first fixed in DB2 Version 10.5 Fix Pack 3 |
| Workaround |
see Local Fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.08.2013
27.02.2014
27.02.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
