View Single Post
  #10 (permalink)  
Old 03-07-10, 09:37
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
It appears you don't have enough heap allocated for FMPs. This has to do with DB2_FMP_COMM_HEAPSZ again.

DB2_FMP_COMM_HEAPSZ can accomodate "2 * ASLHEAPSZ * number of active db2fmps".


I'm not sure if the following will fix the problem, but it worth to try:

- decrease ASLHEAPSZ (default is 15 4K pages; leave it unchanged for now if this is what you already have)
- increase DB2_FMP_COMM_HEAPSZ (20MB if not set)


For example, the following setting should provide enough memory to run up to 400 FMPs concurrently:
db2 update dbm cfg using ASLHEAPSZ 15
db2set DB2_FMP_COMM_HEAPSZ=12000


Please check this article for some additional info about these parameters:
Solve common problems with DB2 UDB Java stored procedures


I should also mention that you may have some leftover db2fmps from an abnormal instance termination. Check the Task Manager after stopping the instance.

Last edited by db2girl; 03-07-10 at 09:41.
Reply With Quote