1. You can change db configuration without connecting to the db.

db2 update db cfg for <db name> using ....

2. Look into ESTORE option for 'create bufferpool...' for using bigger
bufferpools in 32-bit.

.... Sushanta

-----Original Message-----
From: Edward Appiah
[mailto:db2udbdba-ezmlmshield-x46673106.[Email address protected]
Sent: Monday, November 26, 2007 4:30 PM
To: LazyDBA Discussion
Subject: Memory Allocation ...


I have 32-bit DB2 on 32-bit AIX. I created an additional bufferpool and

right after began getting this error when ever i issue a db2 command I
get
this is the db2diag.log

RETCODE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.


I cannot even issue a command to reduce the bufferpool or drop it all
together.

Can anyone tell what I have to do to fix it ?

Thanks

Edward


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




******************************************************************************************
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, Alltel requests
that you immediately notify the sender and asks that you do not read the message or its
attachments, and that you delete them without copying or sending them to anyone else.



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