DB2 Memory Allocation Error

[mghale]

Greetings,

I have moved a database from the DB2 Windows Platform (Dev) to our
production AIX Server and am experiencing an issue:

The AIX platform is 5.3 and DB2 version 8.1 pixpack 9a (8.1.1.89)
There hardware is Power5 8 procs, 4 online and 8 GB of memory.

When I create the the database with the 8 bufferpools that existed in
DB2 Windows, then try to connect to the database, I receive an error
stating that an unexpected system error occurred.

In the db2diag.log file is this...
2005-10-10-12.11.15.144638-300 I3323813C393 LEVEL: Info
PID : 1020108 TID : 1 PROC : db2agent
(CNTNTVRT) 0
INSTANCE: wcmprdi1 NODE : 000 DB : WCMPRDD2
APPHDL : 0-76 APPID: *LOCAL.wcmprdi1.051010171115
FUNCTION: DB2 UDB, data protection, sqlpinit, probe:2160
MESSAGE : Database started with next LSN of 0000000000FA000C.

2005-10-10-12.11.15.145138-300 I3324207C430 LEVEL: Info
PID : 1020108 TID : 1 PROC : db2agent
(CNTNTVRT) 0
INSTANCE: wcmprdi1 NODE : 000 DB : WCMPRDD2
APPHDL : 0-76 APPID: *LOCAL.wcmprdi1.051010171115
FUNCTION: DB2 UDB, buffer pool services, sqlbCheckRegistryAndBpvars,
probe:160
MESSAGE : DB2_MMAP_READ/DB2_MMAP_WRITE has resulted in internal flags
of 0xf

2005-10-10-12.11.16.604672-300 I3324638C953 LEVEL: Severe
PID : 1020108 TID : 1 PROC : db2agent
(CNTNTVRT) 0
INSTANCE: wcmprdi1 NODE : 000 DB : WCMPRDD2
APPHDL : 0-76 APPID: *LOCAL.wcmprdi1.051010171115
FUNCTION: DB2 UDB, base sys utilities, sqleAllocateAppGroup, probe:21
MESSAGE : Failed to allocate App Ctl Shr Mem Set with follwing error.
Reduce
APPGROUP_MEM_SZ. On 32bit AIX, this problem may also happen
when the
DB memory set is too big that it spills over to the APPGROUP
memory
address. Try reducing the DB memory size by using smaller
bufferpool(s), or reducing the values for the database
configuration
parameters that affect the size of the DB memory such as
DBHEAP,
CATALOGCACHE_SZ, LOCKLIST, PCKCACHESZ, etc...
DATA #1 : Hexdump, 4 bytes
0x2FF143CC : 850F 0005 ....

2005-10-10-12.11.16.604910-300 I3325592C497 LEVEL: Severe
PID : 1020108 TID : 1 PROC : db2agent
(CNTNTVRT) 0
INSTANCE: wcmprdi1 NODE : 000 DB : WCMPRDD2
APPHDL : 0-76 APPID: *LOCAL.wcmprdi1.051010171115
FUNCTION: DB2 UDB, base sys utilities, sqleAllocateAppGroup, probe:20
RETCODE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.

2005-10-10-12.11.16.605262-300 I3326090C398 LEVEL: Info
PID : 1020108 TID : 1 PROC : db2agent
(idle) 0
INSTANCE: wcmprdi1 NODE : 000 DB : WCMPRDD2
APPHDL : 0-76 APPID: *LOCAL.wcmprdi1.051010171115
FUNCTION: DB2 UDB, base sys utilities, sqleRemoveFromDbAppGrpList,
probe:10
MESSAGE : App Group not allocated or not in DB list

2005-10-10-12.11.16.608487-300 I3326489C390 LEVEL: Info
PID : 1020108 TID : 1 PROC : db2agent
(idle) 0
INSTANCE: wcmprdi1 NODE : 000 DB : WCMPRDD2
APPHDL : 0-76 APPID: *LOCAL.wcmprdi1.051010171115
FUNCTION: DB2 UDB, data protection, sqlpterm, probe:3200
MESSAGE : Database shutdown with next LSN of 0000000000FA000C.
There is plenty of available physical memory on the server and the DBM
and DB config is set for Automatic Memeory.

The size of the 8 bufferpools together are 1.02 GB. When I cut the
bufferpool sizes in half to about 550 MB, I can then connect to the
database successfully.

Does anyone have any idea why this might be occurring?

Thanks in advance!!

[Artur]

Are you using 32-bit DB2 code?

read the article about differences in memory allocation for different
operating systems. On AIX max database shared memory is 1.25 - 2 GB,
and besides bufferpools there are other memory structures you should
check. Is can possible that your configuration is about the limit:

http://www-128.ibm.com/developerwork...cle/dm-0406qi/

Regards, Artur Wronski

[mghale]

Artur,

Thanks so much. That article was great! Definitely one to print out
and keep handy at all times. I found exactly the condition that was
affecting my situation and the article even specifies how to resolve
it.

Thanks so much! I search IBM's site a lot but sometimes without much
luck cause they have so much content sometimes it's hard to get at what
I'm needing.

Thanks for pointing this article out. I recommend this to anyone who
wants to know how DB2 memory allocation works down to the technical
nitty-gritty!

Thanks again!

Martin
Artur wrote:

Are you using 32-bit DB2 code?

read the article about differences in memory allocation for different
operating systems. On AIX max database shared memory is 1.25 - 2 GB,
and besides bufferpools there are other memory structures you should
check. Is can possible that your configuration is about the limit:

http://www-128.ibm.com/developerwork...cle/dm-0406qi/

Regards, Artur Wronski