Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2010
    Posts
    2

    Unanswered: DB2 Memory Issue

    2010-08-12-19.03.42.043925-240 E1911011A567 LEVEL: Severe (OS)
    PID : 872850 TID : 1 PROC : db2lrid 0
    INSTANCE: db2rwap1 NODE : 000 DB : DBRWA0FP
    APPHDL : 0-1424 APPID: GA950518.B365.150BD2231743
    FUNCTION: DB2 UDB, oper system services, getPrivateChunksFromOs, probe:100
    CALLED : OS, -, malloc
    OSERR : ENOMEM (12) "There is not enough memory available now."
    MESSAGE : Private memory and/or virtual address space exhausted
    DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
    28758016

    2010-08-12-19.03.42.044918-240 E1911579A567 LEVEL: Severe (OS)
    PID : 872850 TID : 1 PROC : db2lrid 0
    INSTANCE: db2rwap1 NODE : 000 DB : DBRWA0FP
    APPHDL : 0-1424 APPID: GA950518.B365.150BD2231743
    FUNCTION: DB2 UDB, oper system services, getPrivateChunksFromOs, probe:100
    CALLED : OS, -, malloc
    OSERR : ENOMEM (12) "There is not enough memory available now."
    MESSAGE : Private memory and/or virtual address space exhausted
    DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
    28758016

    2010-08-12-19.03.42.045250-240 I1912147A507 LEVEL: Warning
    PID : 872850 TID : 1 PROC : db2lrid 0
    INSTANCE: db2rwap1 NODE : 000 DB : DBRWA0FP
    APPHDL : 0-1424 APPID: GA950518.B365.150BD2231743
    FUNCTION: DB2 UDB, sort/list services, sqlsAllocateSortMemory, probe:35
    DATA #1 : <preformatted>
    Not enough memory available for a (private) sort heap of size 10000
    bufSize = 28745728, bPrivatePool = 1, bPoolHasSpace = 1
    Trying smaller size...

    2010-08-12-19.03.42.045529-240 E1912655A567 LEVEL: Severe (OS)
    PID : 872850 TID : 1 PROC : db2lrid 0
    INSTANCE: db2rwap1 NODE : 000 DB : DBRWA0FP
    APPHDL : 0-1424 APPID: GA950518.B365.150BD2231743
    FUNCTION: DB2 UDB, oper system services, getPrivateChunksFromOs, probe:100
    CALLED : OS, -, malloc
    OSERR : ENOMEM (12) "There is not enough memory available now."
    MESSAGE : Private memory and/or virtual address space exhausted
    DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
    14389248

    2010-08-12-19.03.42.047869-240 E1913223A567 LEVEL: Severe (OS)
    PID : 872850 TID : 1 PROC : db2lrid 0
    INSTANCE: db2rwap1 NODE : 000 DB : DBRWA0FP
    APPHDL : 0-1424 APPID: GA950518.B365.150BD2231743
    FUNCTION: DB2 UDB, oper system services, getPrivateChunksFromOs, probe:100
    CALLED : OS, -, malloc
    OSERR : ENOMEM (12) "There is not enough memory available now."
    MESSAGE : Private memory and/or virtual address space exhausted
    DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 8 bytes
    14389248

    2010-08-12-19.03.42.048190-240 I1913791A506 LEVEL: Warning
    PID : 872850 TID : 1 PROC : db2lrid 0
    INSTANCE: db2rwap1 NODE : 000 DB : DBRWA0FP
    APPHDL : 0-1424 APPID: GA950518.B365.150BD2231743
    FUNCTION: DB2 UDB, sort/list services, sqlsAllocateSortMemory, probe:35
    DATA #1 : <preformatted>
    Not enough memory available for a (private) sort heap of size 5000
    bufSize = 14376960, bPrivatePool = 1, bPoolHasSpace = 1
    Trying smaller size...

    2010-08-12-19.03.48.167806-240 I1914298A464 LEVEL: Warning
    PID : 872850 TID : 1 PROC : db2lrid 0
    INSTANCE: db2rwap1 NODE : 000 DB : DBRWA0FP
    APPHDL : 0-1424 APPID: GA950518.B365.150BD2231743
    FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:0
    DATA #1 : String, 106 bytes
    LOADID: 520504.2010-08-12-19.03.41.302381.0 (14;642)
    Completed LOAD phase at 08/12/2010 19:03:48.161938.

    2010-08-12-19.03.48.168801-240 I1914763A464 LEVEL: Warning
    PID : 872850 TID : 1 PROC : db2lrid 0
    INSTANCE: db2rwap1 NODE : 000 DB : DBRWA0FP
    APPHDL : 0-1424 APPID: GA950518.B365.150BD2231743
    FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:0
    DATA #1 : String, 106 bytes
    LOADID: 520504.2010-08-12-19.03.41.302381.0 (14;642)
    Starting BUILD phase at 08/12/2010 19:03:48.168153.

    2010-08-12-19.03.52.220804-240 I1915228A465 LEVEL: Warning
    PID : 872850 TID : 1 PROC : db2lrid 0
    INSTANCE: db2rwap1 NODE : 000 DB : DBRWA0FP
    APPHDL : 0-1424 APPID: GA950518.B365.150BD2231743
    FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:0
    DATA #1 : String, 107 bytes
    LOADID: 520504.2010-08-12-19.03.41.302381.0 (14;642)
    Completed BUILD phase at 08/12/2010 19:03:52.220075.

    2010-08-12-19.09.03.457435-240 I1915694A431 LEVEL: Warning
    PID : 184440 TID : 1 PROC : db2lrid 0
    INSTANCE: db2rwap1 NODE : 000 DB : DBRWA0FP
    APPHDL : 0-1427 APPID: GA950518.B3D3.150BD2232306
    FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
    DATA #1 : String, 82 bytes
    LOADID: 520504.2010-08-12-19.09.03.297666.0 (14;615)
    Load CPU parallelism is: 5, 0

    2010-08-12-19.09.03.490328-240 I1916126A490 LEVEL: Warning
    PID : 598268 TID : 1 PROC : db2lfrm0 0
    INSTANCE: db2rwap1 NODE : 000 DB : DBRWA0FP
    APPHDL : 0-1427 APPID: GA950518.B3D3.150BD2232306
    FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:0
    DATA #1 : String, 131 bytes
    LOADID: 520504.2010-08-12-19.09.03.297666.0 (14;615)
    Starting LOAD phase at 08/12/2010 19:09:03.488438. Table DB454 .RI_MCM_TMP

    2010-08-12-19.09.03.837516-240 I1916617A464 LEVEL: Warning
    PID : 184440 TID : 1 PROC : db2lrid 0
    INSTANCE: db2rwap1 NODE : 000 DB : DBRWA0FP
    APPHDL : 0-1427 APPID: GA950518.B3D3.150BD2232306
    FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:0
    DATA #1 : String, 106 bytes
    LOADID: 520504.2010-08-12-19.09.03.297666.0 (14;615)
    Completed LOAD phase at 08/12/2010 19:09:03.836411.

    2010-08-12-19.09.03.838435-240 I1917082A464 LEVEL: Warning
    PID : 184440 TID : 1 PROC : db2lrid 0
    INSTANCE: db2rwap1 NODE : 000 DB : DBRWA0FP
    APPHDL : 0-1427 APPID: GA950518.B3D3.150BD2232306
    FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:0
    DATA #1 : String, 106 bytes
    LOADID: 520504.2010-08-12-19.09.03.297666.0 (14;615)
    Starting BUILD phase at 08/12/2010 19:09:03.837848.

    2010-08-12-19.09.04.174643-240 I1917547A465 LEVEL: Warning
    PID : 184440 TID : 1 PROC : db2lrid 0
    INSTANCE: db2rwap1 NODE : 000 DB : DBRWA0FP
    APPHDL : 0-1427 APPID: GA950518.B3D3.150BD2232306
    FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:0
    DATA #1 : String, 107 bytes
    LOADID: 520504.2010-08-12-19.09.03.297666.0 (14;615)
    Completed BUILD phase at 08/12/2010 19:09:04.173990.

    2010-08-12-19.09.33.879784-240 I1918013A431 LEVEL: Warning
    PID : 626790 TID : 1 PROC : db2lrid 0
    INSTANCE: db2rwap1 NODE : 000 DB : DBRWA0FP
    APPHDL : 0-1429 APPID: GA950518.B3DA.150BD2232336
    FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
    DATA #1 : String, 82 bytes
    LOADID: 520504.2010-08-12-19.09.33.677348.0 (14;642)
    Load CPU parallelism is: 5, 0

    2010-08-12-19.09.33.902928-240 I1918445A488 LEVEL: Warning
    PID : 725058 TID : 1 PROC : db2lfrm0 0
    INSTANCE: db2rwap1 NODE : 000 DB : DBRWA0FP
    APPHDL : 0-1429 APPID: GA950518.B3DA.150BD2232336
    FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:0
    DATA #1 : String, 129 bytes
    LOADID: 520504.2010-08-12-19.09.33.677348.0 (14;642)
    Starting LOAD phase at 08/12/2010 19:09:33.901102. Table DB454 .RI_MIR_T




    I found this in DB2 Diag log file... There is not enough memory available now... can anyone suggest on this please?

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    What OS and DB2 version are you using? If AIX, check ulimit(data) setting (ulimit -a command)
    Is this a 32-bit or 64-bit instance?
    What is sortheap and sheapthers set to?

  3. #3
    Join Date
    Aug 2010
    Posts
    2
    Hi Bella... Thank you very much for your reply....

    What OS and DB2 version are you using?

    AIX rspsswods01 3 5 00C6091F4C00

    DB21085I Instance "db2rwap1" uses "64" bits and DB2 code release "SQL08027"
    with level identifier "03080106".
    Informational tokens are "DB2 v8.1.1.128", "s061108", "U810098", and FixPak
    "14".
    Product is installed at "/usr/opt/db2_08_01".




    If AIX, check ulimit(data) setting (ulimit -a command)

    time(seconds) unlimited
    file(blocks) unlimited
    data(kbytes) 245760
    stack(kbytes) 32768
    memory(kbytes) unlimited
    coredump(blocks) unlimited
    nofiles(descriptors) 2000

    Is this a 32-bit or 64-bit instance?

    It is 64-bit instance

    What is sortheap and sheapthers set to?

    Sort heap threshold (4KB) (SHEAPTHRES) = 150000
    Sort list heap (4KB) (SORTHEAP) = 10000

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    Load does all of its index key sorting simultaneusly in the private memory of one process - db2lrid in your case. For 32-bit instances on AIX, private memory segment was limited to (256MB - stack) so ulimit(data) had to be set to a max of 250MB. For 64-bit, 256MB limitation doesn't exist so ulimit(data) can be set to unlimited or some high value. Take a look at the following technote and consider increasing your ulimit(data) - currently set to 240MB:
    IBM - Setting the user data limit for DB2 on AIX

Posting Permissions

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