470,645 Members | 1,203 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,645 developers. It's quick & easy.

Shared memory issue

BAS
Hi ,

For the past some days i could see the below error on my diag logs,

MESSAGE : Unable to create or attach to the segment used for fenced
routine
communications. Decrease the amount of database shared memory
used by
your instance, and try again

FUNCTION: DB2 UDB, routine_infrastructure, sqlerGetFMPIPC, probe:40
RETCODE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.

The environment is Aix 5.3 ML2 and db2 8.2 with fixpack 10...Can
someone help how to avoid these shared memory errors, we cannot reduce
the shared memroy as we normally run huge batch jobs which may require
big shared memory.

Thanks & Regards,
Baskar

Nov 27 '06 #1
1 3107
BAS wrote:
Hi ,

For the past some days i could see the below error on my diag logs,

MESSAGE : Unable to create or attach to the segment used for fenced
routine
communications. Decrease the amount of database shared memory
used by
your instance, and try again

FUNCTION: DB2 UDB, routine_infrastructure, sqlerGetFMPIPC, probe:40
RETCODE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
-2062614523 maps to SQL0930N.

Have a look at the user response listed in the message.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 27 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Srijit Kumar Bhadra | last post: by
14 posts views Thread by phil_gg04 | last post: by
18 posts views Thread by John DeSoi | last post: by
96 posts views Thread by BadPony | last post: by
15 posts views Thread by Rob Nicholson | last post: by
3 posts views Thread by S S | last post: by
4 posts views Thread by hugo.arregui | last post: by
1 post views Thread by Korara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.