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
Ian - 28 Sep 2005 16:21 GMT
> I am getting this:
> RETCODE : ZRC=0x8B59000D=-1957101555=SQLKF_NOMEM_BUFFER_HEAP
[quoted text clipped - 5 lines]
> 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?
jcgeorge@yahoo.com - 29 Sep 2005 13:44 GMT
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
Larry - 29 Sep 2005 13:52 GMT
Is it possible that something needs to be changed on the AIX side to
make the shared memory segments larger?
Larry Edelstein
> Sorry, it is a 64-bit instance.
>
[quoted text clipped - 5 lines]
>
> Thanks..John