Hello
I came across this error.
=============
2006-10-06-09.55.05.920232-420 E3709566A586 LEVEL: Error
PID : 942280 TID : 1 PROC : db2agent (WPCDB) 0
INSTANCE: wpcprdwe NODE : 000 DB : WPCDB
APPHDL : 0-1016 APPID: C0A8983C.I874.061006165505
FUNCTION: DB2 UDB, routine_infrastructure, sqlerGetFMPIPC, probe:70
MESSAGE : ADM11002E Insufficient shared memory available for communication
with the db2fmp process. Use the DB2_FMP_COMM_HEAPSZ registry
variable to increase the amount of shared memory available for fenced
routines.

2006-10-06-09.55.05.920450-420 I3710153A493 LEVEL: Severe
PID : 942280 TID : 1 PROC : db2agent (WPCDB) 0
INSTANCE: wpcprdwe NODE : 000 DB : WPCDB
APPHDL : 0-1016 APPID: C0A8983C.I874.061006165505
FUNCTION: DB2 UDB, routine_infrastructure, sqlerGetFMPIPC, probe:60
RETCODE : ZRC=0x8B0F003B=-1961951173=SQLO_NOMEM_UND
"No memory available in 'Undefined Heap'"
DIA8300C A memory heap error has occurred.
====================

I think default value for db2_fmp_comm_heapsz on aix is 245 and the limit is 256 Mb. The error recommends increase in fmp heap. How do I determine the value. The doc. also recommends decreasing appl. support layer heap.

Maximum Number of db2fmps = DB2_FMP_COMM_HEAPSZ / (2*ASLHEAPSZ)

I do not know the values for SQLDA ...
aslheapsz >= ( sizeof(input SQLDA)
+ sizeof(each input SQLVAR)
+ sizeof(output SQLDA)
+ 250 ) / 4096

Any suggestions?

Thnx