Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 Memory Issue

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-17-10, 22:43
ananthamibm ananthamibm is offline
Registered User
  
Join Date: Aug 2010
Posts: 2
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?
Reply With Quote
  #2 (permalink)  
Old 08-18-10, 10:48
db2girl db2girl is offline
∞∞∞∞∞∞
  
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
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?
Reply With Quote
  #3 (permalink)  
Old 08-18-10, 12:42
ananthamibm ananthamibm is offline
Registered User
  
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
Reply With Quote
  #4 (permalink)  
Old 08-18-10, 13:36
db2girl db2girl is offline
∞∞∞∞∞∞
  
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
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
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.