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?

toms1981

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

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?

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.

toms1981

原帖由 huyuhui001 于 2007-4-15 13:02 发表
Please refer to the following info.
每个 32 位 DB2 实例能够对 4 GB 内存寻址。通常希望将大部分内存给缓冲池专用，但是，AIX、HP-UX 和 Windows 上的内存分段会将最大缓冲池的大小限制在 4 GB 以内。即使是 ...

Yes I totally agreed. At the same time, I will do some testing where upgrade one of the instance to 64 bits but not sure will it affect the performance for 32 bits communicate to 64 bits.

Do you have any experience modifying the extended shared memory?

toms1981

Too bad... Extended shared memory doesn't solve the problem. Anyone got others suggestion?

toms1981

yes. I know that 32-bits got limitation on shared memory where only allowed to use up to 1.75 GB. that's why I'm asking whether got alternative solution to solve this issue? I read from other forum where they said can extend the shared memory but it doesn't work when I tried. kindly pls advise.

toms1981

its already in 3 different instances for 3 databases.

toms1981

Nope. I'm in Malaysia now...