Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2013
    Posts
    9

    Unanswered: Db2diag OSERR : ENOMEM (12) "Not enough space"

    Hi

    Os : 6.1.4.3 TL01 - AIX Kernel Version
    Version db2 : DB2 Workgroup Server Edition 9.5
    ram : 8Go

    I have a problem with my db2 database using by Websphere, a problem of use of swap.
    shared memory instance is automatic
    database memory is automatic too...

    I have 111mo of swap use. I can't add some memory
    Could you please help me to resolve the problem ?

    I think maybe I resolve the problem if I fix the memory value inferior of the current automatic value.... What do you think to do that ?

    thanks in advance for your help

    db2diag mesage :

    2013-01-31-13.49.16.636203+060 I374892A2055 LEVEL: Error (OS)
    PID : 577784 TID : 772 PROC : db2acd
    INSTANCE: db2wpps NODE : 000
    EDUID : 772 EDUNAME: db2acd
    FUNCTION: DB2 Common, OSSe, ossErrorMemoryAnalysis, probe:100
    CALLED : OS, -, malloc
    OSERR : ENOMEM (12) "Not enough space"
    DATA #1 : String, 72 bytes
    A total of 5 analysis will be performed :
    - ulimit info
    - Memory info
    DATA #2 : String, 381 bytes
    Current process limits (unit in bytes except for nofiles) :
    mem (S/H) = unlimited / unlimited
    core (S/H) = 1073741312 / unlimited
    cpu (S/H) = unlimited / unlimited
    data (S/H) = 134217728 / unlimited
    fsize (S/H) = 1073741312 / 1073741312
    nofiles (S/H) = unlimited / unlimited
    stack (S/H) = 33554432 / 4294967296
    rss (S/H) = 33554432 / unlimited
    DATA #3 : String, 41 bytes
    current sbrk(0) value: 0x0000000117fffea0
    DATA #4 : String, 117 bytes
    System RAM information (in megabytes) :
    Total = 8192
    Free = 54
    Available = -1
    Addressable = -1
    DATA #5 : String, 69 bytes
    Swap space information (in megabytes) :
    Total = 4096
    Free = 3985

    DATA #6 : String, 116 bytes
    Virtual Memory Information (in megabytes) :
    Total = 12288
    Reserved = -1
    Available = -1
    Free = 4039
    CALLSTCK:
    [0] 0x09000000010AB370 pdOSSeLoggingCallback + 0x140
    [1] 0x0900000002146E70 oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1B0
    [2] 0x09000000021473D4 ossLogSysRC + 0xD4
    [3] 0x090000000215751C ossErrorMemoryAnalysis__FCPC21OSSErrorAnalysisPara m + 0x73C
    [4] 0x09000000021557A4 ossSystemErrorHandler + 0x284
    [5] 0x090000000215FC08 _ossMemAlloc + 0x588
    [6] 0x090000000C504884 hmonFindNode__FP14HmonMainStructUiPUcUsPP9SNodeCB_ tP7SNode_tb + 0x244
    [7] 0x090000000C503174 hmonAddNode__FP14HmonMainStructUiPUcUsPP9SNodeCB_t P7SNode_t + 0x294
    [8] 0x090000000C503680 hmonAddNode__FP14HmonMainStructUiPUcUsPP9SNodeCB_t P7SNode_t + 0x7A0
    [9] 0x090000000C504B0C hmonFindNode__FP14HmonMainStructUiPUcUsPP9SNodeCB_ tP7SNode_tb + 0x4CC

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    The error you posted is reported by db2acd (auto-maintenance / health monitor process). This APAR is a very good match:
    IBM IC82262: ENOMEM ERROR ON DB2ACD PROCESS COULD LEAD TO NON-FATAL ASSERTION FAILED - United States

    Check the local fix, db2diag.log shows 128MB for ulimit (data) in effect:
    data (S/H) = 134217728 / unlimited

  3. #3
    Join Date
    Feb 2013
    Posts
    9
    Ok thanks for your answer, if I undersand good, I just need to fix the value of the ulimit of my user :
    data (S/H) = 134217728 / unlimited become data (S/H) = unlimited / unlimited
    And it will be ok...

    I'm a little bit stupid but I don't understand if it is a big problem or small problem...

  4. #4
    Join Date
    Feb 2013
    Posts
    9
    For maintenance reasons, I stopped and started my lpar, and since this problem does not occur anymore...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •