2655254 - KUDDB2 messages in db2diag.log | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.