Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2007
    Posts
    66

    Unanswered: Load Failing On Prod

    Hi ,


    Load is failing on a production server with the following errors. I believe the private memory is getting exhausted. Tweaking with the memory on production database is not a feasible solution as it is a highly visible application.Please provide your tips to get is resolved

    2007-08-08-02.05.24.905038-240 E17397318A548 LEVEL: Severe (OS)
    PID : 13741 TID : 2199083744640PROC : db2lrid 0
    INSTANCE: db2inst1 NODE : 000 DB : MARKETDB
    APPHDL : 0-311 APPID: AC188950.B8C2.0155C8060434
    FUNCTION: DB2 UDB, oper system services, getPrivateChunksFromOs, probe:100
    CALLED : OS, -, malloc
    OSERR : ENOMEM (12) "Cannot allocate memory"
    MESSAGE : Private memory and/or virtual address space exhausted
    DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
    1445888

    2007-08-08-02.05.24.905101-240 I17397867A506 LEVEL: Warning
    PID : 13741 TID : 2199083744640PROC : db2lrid 0
    INSTANCE: db2inst1 NODE : 000 DB : MARKETDB
    APPHDL : 0-311 APPID: AC188950.B8C2.0155C8060434
    FUNCTION: DB2 UDB, sort/list services, sqlsAllocateSortMemory, probe:35
    DATA #1 : <preformatted>
    Not enough memory available for a (private) sort heap of size 1000
    bufSize = 1429504, bPrivatePool = 1, bPoolHasSpace = 1
    Trying smaller size...

    2007-08-08-02.05.24.905180-240 E17398374A548 LEVEL: Severe (OS)
    PID : 13741 TID : 2199083744640PROC : db2lrid 0
    INSTANCE: db2inst1 NODE : 000 DB : MARKETDB
    APPHDL : 0-311 APPID: AC188950.B8C2.0155C8060434
    FUNCTION: DB2 UDB, oper system services, getPrivateChunksFromOs, probe:100
    CALLED : OS, -, malloc
    OSERR : ENOMEM (12) "Cannot allocate memory"
    MESSAGE : Private memory and/or virtual address space exhausted
    DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
    1347584

    2007-08-08-02.05.24.905261-240 E17398923A548 LEVEL: Severe (OS)
    PID : 13741 TID : 2199083744640PROC : db2lrid 0
    --More--

  2. #2
    Join Date
    Feb 2005
    Location
    Bangalore,India
    Posts
    39
    What is your OS??.If it is AIX,change the ulimit(memory) parameter value to 'unlimited'.

    --Naga

  3. #3
    Join Date
    Jun 2007
    Posts
    66
    My OS is linux. The ulimit data seg is set to unlimited already. Is there any other thing i can check for??

  4. #4
    Join Date
    Aug 2007
    Location
    TX, USA
    Posts
    5
    Can you provide more info? db2 version, Linux version, hardware details (including memory), is db2 hosted independently on the box?

    Can you also provide the output of:
    get dbm cfg and get db cfg?

    Also, details of buffer pools.

Posting Permissions

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