By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,672 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

Cannot allocate additional FCM - v8.2 DPF

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.