DIA8305C Memory allocation failure occurred

toms1981

I installed my DB2 Version 8.1 at AIX server 5.3 64 bits.
I created one 32 bits database then when I trying to increase the bufferpool up to 1GB then I will hit this error.
I did do some research where it was caused by the Shared Memory of the OS but I understand that AIX is not able to tune for shared memory so if there any solution to solve this problem?

wangchi

make sure your AIX is running at 64 bit mode.

toms1981

AIX is running with 64 bits but DB2 is running with 32 bits.

wolfop

检查ulimit。
不过32位的东西，也可能遇到就是address space限制了，干嘛不用64BIT

toms1981

I had set the ulimit to unlimited. The reason why I used 32 bits is because I do have 3 databases in the server (8GB Memory) with 3 diferent instances. One of the instance is served for OLAP cube and its doesn't support 64 bits database therefore I standardize all the databases to 32 bits.

Some of the website suggested to change this configuration  export EXTSHM=ON
db2set DB2ENVLIST=EXTSHM but changing this configuration will have some impact on performace. So what should I do?

itubie

why u make sys so complicated
we want to enjoy life
but not enjoy trouble
so
just use 64bit db2 media
and just use only one instance

ensure your mem is sufficient

raullew

原帖由 toms1981 于 2007-4-13 15:35 发表
I had set the ulimit to unlimited. The reason why I used 32 bits is because I do have 3 databases in the server (8GB Memory) with 3 diferent instances. One of the instance is served for OLAP cube a ...

I wonder why u need 3 instances
If u r implementing an OLAP warehouse using DPF with an OLTP system not using DPF, I think u need another machine to accomplish this , or both will be impacted in performence by each other

huyuhui001

Using 32bit database on 64bit OS may cause some unexpected issue. There is limitation of memory usage on 32bit DB2 database.

toms1981

原帖由 itubie 于 2007-4-13 17:20 发表
why u make sys so complicated
we want to enjoy life
but not enjoy trouble
so
just use 64bit db2 media
and just use only one instance

ensure your mem is sufficient

Of course everyone want to enjoy life so if I have the choice I will just use 64 bits for my db2. With the limited budget, resources, and OLAP limitation, I believe this is the best I can do. Unless you are able to upgrade the IBM OLAP software where it support 64 bits???

toms1981

原帖由 huyuhui001 于 2007-4-15 09:19 发表
Using 32bit database on 64bit OS may cause some unexpected issue. There is limitation of memory usage on 32bit DB2 database.

Yes, I understand and agreed with you but as mentioned earlier I dont have the choice due to IBM OLAP Cube only support 32 bits therefore I was thinking to set EXTSHM=ON to solve my problem but I just worried there will be some impact so I just wish to discuss with you guys who expert in DB2.