| Neueste Versionen | 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 |
|
| Haben Sie Probleme? - Kontaktieren Sie uns. | |
| Kostenlos registrieren |
|
| Kontaktformular |
|
DB2 - Problembeschreibung
| Problem IC75236 | Status: Geschlossen |
OCCASIONAL STMM TUNING FAILURES DECREASING DATABASE MEMORY | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * Systems configured to have STMM tune overall database memory * * (Database_Memory = AUTOMATIC, SELF_TUNING_MEM = ON) * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Messages can be ignored as the problem has very limited * * impact * **************************************************************** | |
| Local-Fix: | |
| verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
| Lösung | |
Problem first fixed in DB2 Version 9.7 Fix Pack 5 | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.03.2011 02.02.2012 02.02.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP5 | |
| Problem behoben lt. FixList in der Version | |
| 9.7.0.5 |
|