| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IC74661 | Status: Closed |
OCCASIONAL STMM TUNING FAILURES DECREASING DATABASE MEMORY | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
| Problem description: | |
Since 9.5 GA, STMM has been using database memory statistics
from before the tuning cycle to adjust database memory overflow,
if needed, at the end of the cycle. This is incorrect, as
Database Memory may have changed significantly during the cycle,
including from STMM tuning itself. This occasionally results in
internal failures logged to the db2diag.log. This is corrected
in the next tuning cycle, and has no significant effect on
database operations or STMM tuning.
Sample db2diag.log messages:
2010-08-04-17.39.26.305875+120 E14014A730 LEVEL: Warning
PID : 503850 TID : 20304 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-54 APPID: *N0.DB2.100729183327
AUTHID : db2inst1
EDUID : 20304 EDUNAME: db2stmm (SAMPLE) 0
FUNCTION: DB2 UDB, Self tuning memory manager,
stmmDecreaseDBMemOriginatedBySTMM, probe:1616
MESSAGE :
ZRC=0x02AE00A5=44957861=STMM_DBMEM_COULD_NOT_BE_DECREASED
"The DATABASE_MEMORY parameter could not be decreased"
DATA #1 : String, 141 bytes
Overflow memory decrease amount exceeds overflow size.
DATABASE_MEMORY decrease failed. Decrease amount: 686325760,
overflow size: 634912768
2010-08-04-17.39.26.313915+120 I14745A564 LEVEL: Severe
PID : 503850 TID : 20304 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-54 APPID: *N0.DB2.100729183327
AUTHID : db2inst1
EDUID : 20304 EDUNAME: db2stmm (SAMPLE) 0
FUNCTION: DB2 UDB, config/install, sqlfUpdateDbCfg, probe:5417
MESSAGE : ZRC=0x00000553=1363
DATA #1 : <preformatted>
DB cfg update happened non-dyn resulting in 1363.
action: 5 | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Systems where STMM is configured to tune Database Memory are * * affected (DATABASE_MEMORY = AUTOMATIC AND SELF_TUNING_MEM = * * ON) * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * This problem does not have a significant impact on database * * operations, it is recommended to ignore the associated STMM * * tuning failures. * **************************************************************** | |
| Local Fix: | |
| available fix packs: | |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows | |
| Solution | |
Problem First fixed in DB2 Version 9.5 Fix Pack 8 | |
| Workaround | |
not known / see Local fix | |
| BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC75236 follow-up : | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.02.2011 27.06.2011 27.06.2011 |
| Problem solved at the following versions (IBM BugInfos) | |
9.5.FP8 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.5.0.8 |
|