468,103 Members | 1,318 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Cannot allocate additional FCM - v8.2 DPF

I am getting this:
RETCODE : ZRC=0x8B59000D=-1957101555=SQLKF_NOMEM_BUFFER_HEAP
"No memory available in 'FCMBP Heap'"
DIA8300C A memory heap error has occurred.

and this
FUNCTION: DB2 UDB, fast comm manager, sqlkfResrcFreeMemCheck, probe:100
MESSAGE : Shared mem. set is not big enough for more FCM buffers. Cur
size: 297598976, Max size: 320307200, Needed size: 437059584

When trying to increase my FCM_NUM_BUFFERS from 65536 to 98304. I am
increasing because I originally got this when executing an import:
FUNCTION: DB2 UDB, fast comm manager, sqlkf_alloc_buffer, probe:55
MESSAGE : Ran out low/med priority buffers. Total=65536; Num in
freelist=13095; med thres=13107; hi thres=6553

Anybody have any clues why I cannot allocate more memory to FCM.

I am on AIX 5.3, DB2 v8.2 FP9 with DPF.
(2) P575's, 8 partitions each, 32GB Memory per p575

I am not paging - so looks like I have available memory on the box.

Any help would be appreciated.

Thanks, John

Nov 12 '05 #1
3 2062
Ian
jc******@yahoo.com wrote:
I am getting this:
RETCODE : ZRC=0x8B59000D=-1957101555=SQLKF_NOMEM_BUFFER_HEAP
"No memory available in 'FCMBP Heap'"
DIA8300C A memory heap error has occurred.

and this
FUNCTION: DB2 UDB, fast comm manager, sqlkfResrcFreeMemCheck, probe:100
MESSAGE : Shared mem. set is not big enough for more FCM buffers. Cur
size: 297598976, Max size: 320307200, Needed size: 437059584


Are you running with a 32-bit instance?
Nov 12 '05 #2
Sorry, it is a 64-bit instance.

Also, I seem to be running out of FCM buffers during an Import.

There appears to be many Imports in the ETL scripts, so I am not sure
if I can easily change them all to Loads (due to
politics/testing/change control).

Thanks..John

Nov 12 '05 #3
Is it possible that something needs to be changed on the AIX side to
make the shared memory segments larger?

Larry Edelstein

jc******@yahoo.com wrote:
Sorry, it is a 64-bit instance.

Also, I seem to be running out of FCM buffers during an Import.

There appears to be many Imports in the ETL scripts, so I am not sure
if I can easily change them all to Loads (due to
politics/testing/change control).

Thanks..John

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by sks_cpp | last post: by
3 posts views Thread by Michael | last post: by
1 post views Thread by rveloso | last post: by
12 posts views Thread by paul | last post: by
2 posts views Thread by saneman | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.