Re: problem with memory allocation, DB2 UDB 8.1 fixpack 6

Re: problem with memory allocation, DB2 UDB 8.1 fixpack 6

 

  

something is wrong with the size of bufferpool id 1. Its probably too big
or you have pinned set on. Take a look at the size of it
and reduce it. Right now you are using the default 4096 page bufferpool of
40 pages.






"Maxim Ness "
<db2udbdba-ezmlms
hield-x58319854.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
04/20/2006 03:35
PM Subject
problem with memory allocation, DB2
UDB 8.1 fixpack 6










Hello DBA's,
I am getting this into db2diag.log

ZRC=0x8B0F0007ÿ

2006-04-20-14.16.36.281000 Instance:PSFT Node:000
PID:3188(db2syscs.exe) TID:5892 Appid:C0A80615.FA05.00AE80160355
common communication sqlcctcptest Probe:11 Database:PSFTPROD


2006-04-20-14.17.00.578000 Instance:PSFT Node:000
PID:3188(db2syscs.exe) TID:2780 Appid:AC1003E9.M40A.01E400181820
SQO Memory Management sqloGetMemChunks Probe:10 Database:PSFTCRP4

Error from Virtual Alloc:
0x08B6817C : 0x00000008 ....

2006-04-20-14.17.00.687000 Instance:PSFT Node:000
PID:3188(db2syscs.exe) TID:2780 Appid:AC1003E9.M40A.01E400181820
buffer pool services sqlbinit Probe:500 Database:PSFTCRP4

BufferPool memory allocation failed
0x08B68CA8 : 0x8B0F0010
2006-04-20-14.17.01.406000 Instance:PSFT Node:000
PID:3188(db2syscs.exe) TID:2780 Appid:AC1003E9.M40A.01E400181820
buffer pool services sqlbStartPools Probe:2 Database:PSFTCRP4

ADM6073W The table space "SYSCATSPACE" (ID "0") is configured to use
buffer
pool ID "1", but this buffer pool is not active at this time. In the
interim
the table space will use buffer pool ID "4096". The inactive buffer pool
should become available at next database startup provided that the
required
memory is available.




The database_memory parameter is Dynamic and i do have free memory
available on the box. How can i allocate more memory to Instance? Database
?



Thank you !


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page