Help!

I am migrating 8.1 db from db2 on windows to 8.2 db2 on aix with db2look and db2move. Everything has been successful until I try to move 2 procedures using db2 "get routine ..." db2 "put routine..."

db2 "put routine from WMP_COPY_FRC.SAR"
SQL1042C An unexpected system error occurred. SQLSTATE=58004

error message from the db2diag.log:

MESSAGE : ADM11000E DB2 is unable to create or attach to the memory segment
used for fenced routine communications. Decrease the amount of
database shared memory used by your instance, and retry.

I've tried to increase both ASLHEAPSZ from 15 to 25 and DB2_FMP_COMM_HEAPSZ from nothing to 250.
I've stopped the instance, cleaned it, and started again. Retried the db2 put command and still get the same error.

Am I being to conservative when increasing DB2_FMP_COMM_HEAPSZ parameter? How do I know what to increase it to?

Thanks for any advice in advance!

The Rookie,
cg



******************************************************************************
This e-mail is intended only for the use of the individual or entity
to which it is addressed and may contain information which is
privileged, confidential, and exempt from disclosure under applicable
law. If you are not the intended recipient, or an employee or agent
of the intended recipient, you are hereby notified that any
dissemination, distribution, or copying of this communication is
strictly prohibited. If you have received this communication in error
please notify us immediately by replying to [Email address protected]
******************************************************************************


DB2 & UDB email list listserv db2-l LazyDBA home page