Symptom
- System Hangs suddenly.
- EWA report shows 'High Average Read/Write time'
Db2diag.log shows below message
======================
2018-05-10********************* LEVEL: Warning
PID : ***** TID : ************** PROC : kuddb2
INSTANCE: db2<sid> NODE : 000
HOSTNAME: **********
FUNCTION: DB2 UDB, SQO Memory Management, sqlogmblkEx, probe:1000
MESSAGE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt invalid size"
DIA8563C An invalid memory size was requested.
DATA #1 : String, 43 bytes
Memory management block allocation failure.
DATA #2 : Codepath, 8 bytes
2
DATA #3 : Memory pool handle pointer, PD_TYPE_MEM_POOL_HANDLE_PTR, 8 bytes
0x0000000000000000
DATA #4 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
0
DATA #5 : Adjusted block size, PD_TYPE_MEM_ADJUSTED_SIZE, 8 bytes
0
DATA #6 : Options for requested block, PD_TYPE_GET_MEM_OPTIONS, 4 bytes
0x00000000
DATA #7 : Pointer to address that will be set by new allocation, PD_TYPE_PTR_TO_ADDRESS_OUT, 8 bytes
0x00002aaab7b30f48
DATA #8 : File name, PD_TYPE_OSS_MEM_FILE_NAME, 9 bytes
sqlmapi.C
DATA #9 : Line of code, PD_TYPE_OSS_MEM_LINE_NUM, 8 bytes
2920
DATA #10: Resource binding pointer, PD_TYPE_RESOURCE_BINDING_PTR, 8 bytes
0x0000000000000000
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x00002AAAB04F9D8C sqlogmblkEx + 0x192C
[1] 0x00002AAAB0DB954B /db2/db2<sid>/sqllib/lib/libdb2.so + 0x102754B
[2] 0x00002AAAB0DB9092 db2GetSnapshotSize + 0x952
[3] 0x00000000004744D6 _ZN17CandleDb2SnapShot19GetDatabaseSnapshotEPiiS0_iiPPci + 0x3B2
[4] 0x000000000057C9AF _ZN21kud00_kudtblspc_agent10TakeSampleEv + 0x57D
[5] 0x00002AAAAB9707D8 _ZN5ctira19DriveDataCollectionEv + 0x2E2
[6] 0x00002AAAAB97B7B0 _ZN12TableManager23checkForExpiredRequestsEl + 0x35E
[7] 0x00002AAAAB97BC74 _ZN12TableManager7timeoutEP15CTRA_Timerspec_ + 0x2E
[8] 0x00002AAAAB92EEC3 _ZN15CTRA_timer_base20TimerCallbackHandlerEv + 0x259
[9] 0x00002AAAAB92DA37 /opt/IBM/ITM/tmaitm6/lx8266/lib/libkra.so + 0x1E1A37
[10] 0x00002AAAAB930045 /opt/IBM/ITM/tmaitm6/lx8266/lib/libkra.so + 0x1E4045
[11] 0x00002AAAAAEED806 /lib64/libpthread.so.0 + 0x7806
[12] 0x00002AAAAD66974D clone + 0x6D
Read more...
Environment
- Db2 product installed along with IBM Tivoli Monitoring for Databases
- Db2 LUW 9.1 and above
- SAP SCM 7.0 / 740
- SAP EHP1 FOR SAP NETWEAVER 7.3
Product
Keywords
Memory, IBM Tivoli Monitoring (ITM), Tivoli Manager, Citra_hostname , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.