you might have memory issues. ask your admin to add more swap space. but
try bouncing the instance first.
|---------+--------------------------------------------------------->
| | "DANIEL CALLAHAN " |
| | <db2udbdba-ezmlmshield-x26731705.x114556510|
| | [Email address protected] |
| | |
| | 04/20/2006 04:36 PM |
|---------+--------------------------------------------------------->
>---------------------------------------------------------------------------------------|
| |
| To: "LazyDBA Discussion" <[Email address protected] |
| cc: |
| Subject: 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
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
******************************************************************
This message originated from the Internet. Its originator may or
may not be who they claim to be and the information contained in
the message and any attachments may or may not be accurate.
******************************************************************
-----------------------------------------
*******************************************************************
****
This E-mail is confidential. It may also be legally privileged. If
you
are not the addressee you may not copy, forward, disclose or use
any
part of it. If you have received this message in error, please
delete
it and all copies from your system and notify the sender
immediately
by return E-mail.
Internet communications cannot be guaranteed to be timely, secure,
error or virus-free. The sender does not accept liability for any
errors or omissions.
*******************************************************************
****
DB2 & UDB email list listserv db2-l LazyDBA home page