Here's the fix:
To resolve the ADM11000E error the total bufferpool size needed to be under 1GB in a 32 bit environment.
db2 "select * from sysibm.sysbufferpool"
The npages = 40000 and page size = 32k. Totaling to 1.22 GB. Decreased npages to 30000 and brought down the total bufferpool size to 0.92 GB.
Next, resolve SQL1042C make sure your system has enough memory and swapping/paging space available.
Use the DB2_FMP_COMM_HEAPSZ registry variable to adjust the amount of memory available for fenced routines.
DB2set - all will display all the default settings when a new instance is created. DB2_FMP_COMM_HEAPSZ needed to be set.
set DB2_FMP_COMM_HEAPSZ to 1000 ( = 4 MB) I was more conservative with space because there are only 2 procedures and there is only 1 database on this instance.
After these two setting were adjusted, the procedures were successfully created and and it's corresponding packages rebinded automatically. v8.2
A many Thanks to Karen at IBM who answered my electronic PMR.
That's all Folks!
Until the next mysterious error....
cg
>>> "Carolyn GregorioGrimm " <db2udbdba-ezmlmshield-x27120733.[Email address protected] 10/22/2007 5:12:58 PM >>>
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]
******************************************************************************
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
******************************************************************************
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