By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,353 Members | 1,555 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,353 IT Pros & Developers. It's quick & easy.

Out of private memory heap

P: 8
Hi guys,

For last few days we are getting out of private memory error. We have a
development environment. We tried to figure out the problem but we
believe that it might be related to the OS (I am new to Windows so not
sure). We are currently bouncing the instance to overcome this error. This
generally happen at the end of business day only (So maybe memory
might be getting used up?). We have already increased the statement heap &
Application heap size. The task manager shows that only 1.8 gig out of
4 gig is being used by the entire system. So there is enough memory on
the system. Strangely db2syscs is only using 800 MB of RAM even when
memory is available & it is facing shortage of it. We first tried STMM
but later started giving fixed value to many of the parameters.

We are running DB2 9 Fix Pak 3 Express Edition on Windows Server 2003
SP2 32-bit 4 Gig RAM. The server has 1 instance which holds 2 database
and both of them get this error when the users try to log through the
application. Here is the db2diag entry:

Expand|Select|Wrap|Line Numbers
  1. 2007-12-28-16.36.06.642000-360 E15236769H668      LEVEL: Warning
  2. PID     : 6020                 TID  : 3468        PROC : db2syscs.exe
  3. INSTANCE: DB2                  NODE : 000         DB   : FACTSSIA
  4. APPHDL  : 0-88                 APPID: 10.131.81.83.55307.071228223249
  5. AUTHID  : FACTSDB 
  6. FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
  7. DATA #1 : <preformatted>
  8. Out of memory failure for Statement Heap.
  9. Requested block size           : 4132 bytes.
  10. Physical heap size             : 1376256 bytes.
  11. Configured heap size           : 491651072 bytes.
  12. Unreserved memory used by heap : 0 bytes.
  13. Unreserved memory left in set  : 0 bytes.
  14.  
  15. 2007-12-28-16.36.06.657000-360 E15237439H682      LEVEL: Warning (OS)
  16. PID     : 6020                 TID  : 3468        PROC : db2syscs.exe
  17. INSTANCE: DB2                  NODE : 000         DB   : FACTSSIA
  18. APPHDL  : 0-88                 APPID: 10.131.81.83.55307.071228223249
  19. AUTHID  : FACTSDB 
  20. FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100
  21. CALLED  : OS, -, VirtualAlloc
  22. OSERR   : 8 "Not enough storage is available to process this command."
  23. MESSAGE : Private memory and/or virtual address space exhausted
  24. DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes
  25. 262144
  26. DATA #2 : Current set size, PD_TYPE_SET_SIZE, 4 bytes
  27. 329908224
  28.  
  29. 2007-12-28-16.36.06.657000-360 E15238123H668      LEVEL: Warning
  30. PID     : 6020                 TID  : 3468        PROC : db2syscs.exe
  31. INSTANCE: DB2                  NODE : 000         DB   : FACTSSIA
  32. APPHDL  : 0-88                 APPID: 10.131.81.83.55307.071228223249
  33. AUTHID  : FACTSDB 
  34. FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
  35. DATA #1 : <preformatted>
  36. Out of memory failure for Statement Heap.
  37. Requested block size           : 4132 bytes.
  38. Physical heap size             : 1376256 bytes.
  39. Configured heap size           : 491651072 bytes.
  40. Unreserved memory used by heap : 0 bytes.
  41. Unreserved memory left in set  : 0 bytes.
  42.  
  43. 2007-12-28-16.36.36.907000-360 E15238793H683      LEVEL: Warning (OS)
  44. PID     : 6020                 TID  : 4816        PROC : db2syscs.exe
  45. INSTANCE: DB2                  NODE : 000         DB   : FACTSSIA
  46. APPHDL  : 0-110                APPID: 10.131.81.83.57355.071228223405
  47. AUTHID  : FACTSDB 
  48. FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100
  49. CALLED  : OS, -, VirtualAlloc
  50. OSERR   : 8 "Not enough storage is available to process this command."
  51. MESSAGE : Private memory and/or virtual address space exhausted
  52. DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes
  53. 1769472
  54. DATA #2 : Current set size, PD_TYPE_SET_SIZE, 4 bytes
  55. 329908224
  56.  
  57. 2007-12-28-16.36.36.907000-360 E15239478H673      LEVEL: Warning
  58. PID     : 6020                 TID  : 4816        PROC : db2syscs.exe
  59. INSTANCE: DB2                  NODE : 000         DB   : FACTSSIA
  60. APPHDL  : 0-110                APPID: 10.131.81.83.57355.071228223405
  61. AUTHID  : FACTSDB 
  62. FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
  63. DATA #1 : <preformatted>
  64. Out of memory failure for Application Heap.
  65. Requested block size           : 1724472 bytes.
  66. Physical heap size             : 1376256 bytes.
  67. Configured heap size           : 204996608 bytes.
  68. Unreserved memory used by heap : 0 bytes.
  69. Unreserved memory left in set  : 0 bytes.
  70.  
  71. 2007-12-28-16.36.36.923000-360 E15240153H683      LEVEL: Warning (OS)
  72. PID     : 6020                 TID  : 4816        PROC : db2syscs.exe
  73. INSTANCE: DB2                  NODE : 000         DB   : FACTSSIA
  74. APPHDL  : 0-110                APPID: 10.131.81.83.57355.071228223405
  75. AUTHID  : FACTSDB 
  76. FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100
  77. CALLED  : OS, -, VirtualAlloc
  78. OSERR   : 8 "Not enough storage is available to process this command."
  79. MESSAGE : Private memory and/or virtual address space exhausted
  80. DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes
  81. 1769472
  82. DATA #2 : Current set size, PD_TYPE_SET_SIZE, 4 bytes
  83. 329908224
  84.  
  85. 2007-12-28-16.36.36.923000-360 E15240838H673      LEVEL: Warning
  86. PID     : 6020                 TID  : 4816        PROC : db2syscs.exe
  87. INSTANCE: DB2                  NODE : 000         DB   : FACTSSIA
  88. APPHDL  : 0-110                APPID: 10.131.81.83.57355.071228223405
  89. AUTHID  : FACTSDB 
  90. FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
  91. DATA #1 : <preformatted>
  92. Out of memory failure for Application Heap.
  93. Requested block size           : 1724472 bytes.
  94. Physical heap size             : 1376256 bytes.
  95. Configured heap size           : 204996608 bytes.
  96. Unreserved memory used by heap : 0 bytes.
  97. Unreserved memory left in set  : 0 bytes.
  98.  
  99. 2007-12-28-16.36.36.923000-360 E15241513H683      LEVEL: Warning (OS)
  100. PID     : 6020                 TID  : 4816        PROC : db2syscs.exe
  101. INSTANCE: DB2                  NODE : 000         DB   : FACTSSIA
  102. APPHDL  : 0-110                APPID: 10.131.81.83.57355.071228223405
  103. AUTHID  : FACTSDB 
  104. FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100
  105. CALLED  : OS, -, VirtualAlloc
  106. OSERR   : 8 "Not enough storage is available to process this command."
  107. MESSAGE : Private memory and/or virtual address space exhausted
  108. DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes
  109. 1769472
  110. DATA #2 : Current set size, PD_TYPE_SET_SIZE, 4 bytes
  111. 329908224
  112.  
  113. 2007-12-28-16.36.36.923000-360 E15242198H673      LEVEL: Warning
  114. PID     : 6020                 TID  : 4816        PROC : db2syscs.exe
  115. INSTANCE: DB2                  NODE : 000         DB   : FACTSSIA
  116. APPHDL  : 0-110                APPID: 10.131.81.83.57355.071228223405
  117. AUTHID  : FACTSDB 
  118. FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
  119. DATA #1 : <preformatted>
  120. Out of memory failure for Application Heap.
  121. Requested block size           : 1724472 bytes.
  122. Physical heap size             : 1179648 bytes.
  123. Configured heap size           : 204996608 bytes.
  124. Unreserved memory used by heap : 0 bytes.
  125. Unreserved memory left in set  : 0 bytes.
  126.  
  127. 2007-12-28-16.36.36.923000-360 I15242873H549      LEVEL: Error
  128. PID     : 6020                 TID  : 4816        PROC : db2syscs.exe
  129. INSTANCE: DB2                  NODE : 000         DB   : FACTSSIA
  130. APPHDL  : 0-110                APPID: 10.131.81.83.57355.071228223405
  131. AUTHID  : FACTSDB 
  132. FUNCTION: DB2 UDB, access plan manager, sqlra_sqlW_get_static_section, probe:900
  133. RETCODE : ZRC=0x8B0F0001=-1961951231=SQLO_NOMEM_APPH
  134.           "No memory available in 'Application Heap'"
  135.           DIA8301C No memory available in the application heap.
  136.  
  137. 2007-12-28-16.36.43.876000-360 E15243424H682      LEVEL: Warning (OS)
  138. PID     : 6020                 TID  : 3696        PROC : db2syscs.exe
  139. INSTANCE: DB2                  NODE : 000         DB   : FACTSSIA
  140. APPHDL  : 0-180                APPID: 10.131.81.81.21255.071228223645
  141. AUTHID  : FACTSDB 
  142. FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100
  143. CALLED  : OS, -, VirtualAlloc
  144. OSERR   : 8 "Not enough storage is available to process this command."
  145. MESSAGE : Private memory and/or virtual address space exhausted
  146. DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes
  147. 262144
  148. DATA #2 : Current set size, PD_TYPE_SET_SIZE, 4 bytes
  149. 329908224
  150.  
  151. 2007-12-28-16.36.43.876000-360 E15244108H661      LEVEL: Warning
  152. PID     : 6020                 TID  : 3696        PROC : db2syscs.exe
  153. INSTANCE: DB2                  NODE : 000         DB   : FACTSSIA
  154. APPHDL  : 0-180                APPID: 10.131.81.81.21255.071228223645
  155. AUTHID  : FACTSDB 
  156. FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
  157. DATA #1 : <preformatted>
  158. Out of memory failure for Statement Heap.
  159. Requested block size           : 416 bytes.
  160. Physical heap size             : 0 bytes.
  161. Configured heap size           : 491651072 bytes.
  162. Unreserved memory used by heap : 0 bytes.
  163. Unreserved memory left in set  : 0 bytes.
  164.  
  165. 2007-12-28-16.36.48.533000-360 E15244771H584      LEVEL: Warning (OS)
  166. PID     : 6020                 TID  : 5372        PROC : db2syscs.exe
  167. INSTANCE: DB2                  NODE : 000
  168. APPHDL  : 0-170
  169. FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100
  170. CALLED  : OS, -, VirtualAlloc
  171. OSERR   : 8 "Not enough storage is available to process this command."
  172. MESSAGE : Private memory and/or virtual address space exhausted
  173. DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes
  174. 262144
  175. DATA #2 : Current set size, PD_TYPE_SET_SIZE, 4 bytes
  176. 329908224
Expand|Select|Wrap|Line Numbers
  1. 2007-12-28-16.36.48.533000-360 E15245357H563      LEVEL: Warning
  2. PID     : 6020                 TID  : 5372        PROC : db2syscs.exe
  3. INSTANCE: DB2                  NODE : 000
  4. APPHDL  : 0-170
  5. FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
  6. DATA #1 : <preformatted>
  7. Out of memory failure for Private Heap.
  8. Requested block size           : 2432 bytes.
  9. Physical heap size             : 0 bytes.
  10. Configured heap size           : 2147680256 bytes.
  11. Unreserved memory used by heap : 0 bytes.
  12. Unreserved memory left in set  : 0 bytes.
  13.  
  14. 2007-12-28-16.36.48.533000-360 I15245922H482      LEVEL: Severe
  15. PID     : 6020                 TID  : 5372        PROC : db2syscs.exe
  16. INSTANCE: DB2                  NODE : 000
  17. APPHDL  : 0-170
  18. FUNCTION: DB2 UDB, DRDA Application Server, sqljsInitAgent, probe:30
  19. MESSAGE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM
  20.           "No Memory Available (reason code is id of requested heap)"
  21.           DIA8300C A memory heap error has occurred.
  22. DATA #1 : String, 12 bytes
  23. sqljsInit rc
  24.  
  25. 2007-12-28-16.36.48.783000-360 E15246406H650      LEVEL: Warning (OS)
  26. PID     : 6020                 TID  : 4404        PROC : db2syscs.exe
  27. INSTANCE: DB2                  NODE : 000
  28. APPHDL  : 0-1115               APPID: *LOCAL.DB2.071228215235
  29. AUTHID  : FACTSDB 
  30. FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100
  31. CALLED  : OS, -, VirtualAlloc
  32. OSERR   : 8 "Not enough storage is available to process this command."
  33. MESSAGE : Private memory and/or virtual address space exhausted
  34. DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes
  35. 262144
  36. DATA #2 : Current set size, PD_TYPE_SET_SIZE, 4 bytes
  37. 329908224
  38.  
  39. 2007-12-28-16.36.48.783000-360 E15247058H635      LEVEL: Warning
  40. PID     : 6020                 TID  : 4404        PROC : db2syscs.exe
  41. INSTANCE: DB2                  NODE : 000
  42. APPHDL  : 0-1115               APPID: *LOCAL.DB2.071228215235
  43. AUTHID  : FACTSDB 
  44. FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
  45. DATA #1 : <preformatted>
  46. Out of memory failure for Private Heap.
  47. Requested block size           : 81920 bytes.
  48. Physical heap size             : 327680 bytes.
  49. Configured heap size           : 2147680256 bytes.
  50. Unreserved memory used by heap : 0 bytes.
  51. Unreserved memory left in set  : 0 bytes.
  52.  
  53. 2007-12-28-16.36.48.783000-360 I15247695H522      LEVEL: Severe
  54. PID     : 6020                 TID  : 4404        PROC : db2syscs.exe
  55. INSTANCE: DB2                  NODE : 000
  56. APPHDL  : 0-1115               APPID: *LOCAL.DB2.071228215235
  57. AUTHID  : FACTSDB 
  58. FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcReceive, probe:30
  59. MESSAGE : ZRC=0x873600CE=-2026503986=SQLZ_RC_OUT_OF_MEMORY, SQLT_SQLJC
  60.           "Out of private memory"
  61. DATA #1 : String, 11 bytes
  62. CCI Error: 
  63. DATA #2 : unsigned integer, 4 bytes
  64. 60
  65.  
  66. 2007-12-28-16.36.48.798000-360 I15248219H374      LEVEL: Error
  67. PID     : 4272                 TID  : 1172        PROC : db2Mon.exe
  68. INSTANCE: DB2                  NODE : 000
  69. FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcWritePurgeDss, probe:20
  70. MESSAGE : ZRC=0x87360014=-2026504172=SQLJC_ERROR_SYSI "INTERNAL ERROR"
  71.           DIA8515C A system error has occurred.
  72.  
  73. 2007-12-28-16.36.49.673000-360 E15248595H650      LEVEL: Warning (OS)
  74. PID     : 6020                 TID  : 3096        PROC : db2syscs.exe
  75. INSTANCE: DB2                  NODE : 000
  76. APPHDL  : 0-193                APPID: *LOCAL.DB2.071228223649
  77. AUTHID  : DB2ADMIN
  78. FUNCTION: DB2 UDB, SQO Memory Management, sqloLogMemoryCondition, probe:100
  79. CALLED  : OS, -, VirtualAlloc
  80. OSERR   : 8 "Not enough storage is available to process this command."
  81. MESSAGE : Private memory and/or virtual address space exhausted
  82. DATA #1 : Requested size, PD_TYPE_MEM_REQUESTED_SIZE, 4 bytes
  83. 851968
  84. DATA #2 : Current set size, PD_TYPE_SET_SIZE, 4 bytes
  85. 329908224
  86.  
  87. 2007-12-28-16.36.49.673000-360 E15249247H636      LEVEL: Warning
  88. PID     : 6020                 TID  : 3096        PROC : db2syscs.exe
  89. INSTANCE: DB2                  NODE : 000
  90. APPHDL  : 0-193                APPID: *LOCAL.DB2.071228223649
  91. AUTHID  : DB2ADMIN
  92. FUNCTION: DB2 UDB, SQO Memory Management, sqloMemLogPoolConditions, probe:30
  93. DATA #1 : <preformatted>
  94. Out of memory failure for Private Heap.
  95. Requested block size           : 792640 bytes.
  96. Physical heap size             : 196608 bytes.
  97. Configured heap size           : 2147680256 bytes.
  98. Unreserved memory used by heap : 0 bytes.
  99. Unreserved memory left in set  : 0 bytes.
  100.  
  101. 2007-12-28-16.36.49.689000-360 I15249885H502      LEVEL: Severe
  102. PID     : 6020                 TID  : 3096        PROC : db2syscs.exe
  103. INSTANCE: DB2                  NODE : 000
  104. APPHDL  : 0-193                APPID: *LOCAL.DB2.071228223649
  105. AUTHID  : DB2ADMIN
  106. FUNCTION: DB2 UDB, routine_infrastructure, sqlerCallDL, probe:20
  107. RETCODE : ZRC=0x8B0F0000=-1961951232=SQLO_NOMEM
  108.           "No Memory Available (reason code is id of requested heap)"
  109.           DIA8300C A memory heap error has occurred.
  110.  
Dec 29 '07 #1
Share this Question
Share on Google+
5 Replies


eWish
Expert 100+
P: 971
kumarmdb2,

I added the code tags for you. Also, because of the amount of text you provided I broke it up to two different segments. This helps preserve the whitespace and make it more readable. When posting here please use the [code] [/code] tags.

Thank You,

--Kevin
Dec 29 '07 #2

P: 8
Thanks Kevin,

I'll definately keep thin in mind for my future posts...

Regards,

Kumar


kumarmdb2,

I added the code tags for you. Also, because of the amount of text you provided I broke it up to two different segments. This helps preserve the whitespace and make it more readable. When posting here please use the tags.

Thank You,

--Kevin
Dec 29 '07 #3

docdiesel
Expert 100+
P: 297
Hi kumarmdb2,

the latter error messages seem to be caused by exhaustion of the application heap. Look for the db parameter APPLHEAPSZ, double it, restart the db and see if your sql is then working fine.

The error messages in the top just look like something is exhausting the virtual address space which is quiet restricted on 32bit systems. Perhaps the article "The DB2 UDB memory model" at http://www.ibm.com/developerworks/db...cle/dm-0406qi/ may give you a hint what's going wrong.

Regards, Bernd
Jan 3 '08 #4

P: 8
Hi kumarmdb2,

the latter error messages seem to be caused by exhaustion of the application heap. Look for the db parameter APPLHEAPSZ, double it, restart the db and see if your sql is then working fine.

The error messages in the top just look like something is exhausting the virtual address space which is quiet restricted on 32bit systems. Perhaps the article "The DB2 UDB memory model" at http://www.ibm.com/developerworks/db...cle/dm-0406qi/ may give you a hint what's going wrong.

Regards, Bernd

Hi Bernd,

Thanks for reply. I tried that but it did not helped much (it just delayed the occurence of error) but I would like to thank you from bottom of my heart for helping.

It is actually a DB2 bug which causes fragmentation of appl heap. As soon as we migrated to fix pack 4 the error stopped coming.


Cheers!

Kumar
Jan 17 '08 #5

docdiesel
Expert 100+
P: 297
It is actually a DB2 bug which causes fragmentation of appl heap. As soon as we migrated to fix pack 4 the error stopped coming.
A bug? Huh, if doubling APPHEAPSZ doesn't help for long it must be. Thank you for posting this information. Btw., did you get to know which APAR fixes this bug?

Regards,
Bernd
Jan 19 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.