Hi,
I found this error message in diaglog, database manager was not restarted, getting these messages again and again.....

ADM11003E DB2 failed to create the memory segment used for
communication with fenced routines. If restarting DB2, ensure that no
db2fmp processes are active on the instance prior to start. Otherwise
you can adjust the value through the DB2_FMP_COMM_HEAPSZ registry
variable, or you can decrease the value of ASLHEAPSZ in the database
manager configuration

Have you tried to adjust DB2_FMP_COMM_HEAPSZ or ASLHEAPSZ ?

ANdy

I didn't try, but i checked the values ASLHEAPSZ = 15 and
DB2_FMP_COMM_HEAPSZ =

How can we calculate these values?

Thanks

The documentation of DB2_FMP_COMM_HEAPSZ:

* Operating system: Windows, UNIX
* Default: 20 MB, or enough space to run 10 fenced routines (whichever is larger). On AIX®, the default is 256 MB
* This variable specifies, in 4 KB pages, the size of the pool used for fenced routine invocations, such as stored procedure or user-defined function calls. The space used by each fenced routine is twice the value of the aslheapsz configuration parameter.

If you are running a large number of fenced routines on your system, you may need to increase the value of this variable. If you are running a very small number of fenced routines, you can reduce it.

Setting this value to 0 means that no set is created, and as a result no fenced routines can be invoked. It also means that the health monitor and the automatic database maintenance functionality (such as automatic backups, statistics collection, and REORG) will be disabled since this functionality relies on the fenced routine infrastructure.

Andy

purush,

You may try e-mailing Chris Hodge as he may have some more info on this issue.