SAP Knowledge Base Article - Preview

2655254 - KUDDB2 messages in db2diag.log

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

SAP NetWeaver 7.3 ; SAP Supply Chain Management 7.0

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.