| 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 IT06177 | Status: Geschlossen |
In rare cases, DB2 instance may trap when STMM thread is shutting down | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problembeschreibung: | |
Symptom:
There would be a db2stmm's Error and an associated FODC_Trap...
message on db2diag.log as similar as below.
...
2014-12-17-04.19.23.472402+540 I61305E570 LEVEL: Error
PID : 17093 TID : 46912837249344PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-13247 APPID: *LOCAL.DB2.141216191620
AUTHID : DB2INST1
EDUID : 5411 EDUNAME: db2agent (idle)
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,
probe:10
MESSAGE : Error in agent servicing application with APPLICATION
NAME:
DATA #1 : Hexdump, 7 bytes
0x0000000202E66852 : 6462 3273 746D 6D
db2stmm
2014-12-17-04.19.23.476208+540 I61876E220 LEVEL: Severe
PID:17093 TID:46912837249344 NODE:000 Title: sqeAgent
Dump File:
/.../db2dump/FODC_Trap_2014-12-17-04.19.23.267764_0000/17093.541
1.000.dump.bin
...
From the associated 17093.5411.000.trap.txt in the FODC_Trap...
directory, may find similar stack trace backs as below.
...
<POFDisassembly>
_Z25sqlplCalculateLmaxTriggerP16sqeLocalDatabasemb + 0x0013
(/.../sqllib/lib64/libdb2e.so.1)
0x00002AAAABE094B1 : 4C8BA8188C00004D
</POFDisassembly>
<StackTrace>
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00002AAAB0407C8B ossDumpStackTraceEx + 0x01ef
0x00002AAAB0402A4A _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00cc
0x00002AAAAD37C6DB sqlo_trce + 0x03fb
0x00002AAAAD3C54D1 sqloEDUCodeTrapHandler + 0x0265
0x0000003B2E80ECA0 address: 0x0000003B2E80ECA0 ; dladdress:
0x0000003B2E800000 ; offset in lib: 0x000000000000ECA0 ;
0x00002AAAABE094B1
_Z25sqlplCalculateLmaxTriggerP16sqeLocalDatabasemb + 0x0013
0x00002AAAAC0634A2
_Z42stmmCleanupMemConsumersOnTunerDeactivationP16sqeLocalDatabas
e + 0x0038
0x00002AAAAC063018
_Z31stmmDeactivateTuningIfNecessaryP16sqeLocalDatabasebbb +
0x0102
0x00002AAAAC063561
_Z35stmmUpdateSTMMStateOnDaemonShutdownP16sqeLocalDatabase +
0x007f
0x00002AAAAC062477 stmmMemoryTunerMain + 0x0297
0x00002AAAAB95B801 _Z26sqleIndCoordProcessRequestP8sqeAgent +
0x04c5
0x00002AAAAB968719 _ZN8sqeAgent6RunEDUEv + 0x038f
0x00002AAAAC05C9B8 _ZN9sqzEDUObj9EDUDriverEv + 0x00a6
0x00002AAAAC05C90F _Z10sqlzRunEDUPcj + 0x0009
0x00002AAAABDC2150 sqloEDUEntry + 0x02f4
0x0000003B2E80683D address: 0x0000003B2E80683D ; dladdress:
0x0000003B2E800000 ; offset in lib: 0x000000000000683D ;
0x0000003B2DCD503D clone + 0x006d
</StackTrace>
...
Condition of problem:
Any situation where STMM is ON. | |
| Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DB2 UDB Version 9.7 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 9.7 FixPack 11. * **************************************************************** | |
| Local-Fix: | |
Trun off self_tuning_mem db cfg parameter. | |
| Lösung | |
Problem was first fixed in DB2 UDB Version 9.7 FixPack 11. | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 18.12.2014 13.10.2015 13.10.2015 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP11 | |
| Problem behoben lt. FixList in der Version | |
| 9.7.0.11 |
|
