Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / May 2007

Tip: Looking for answers? Try searching our database.

ALTER BUFFERPOOL with no DB connect

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gregor Kovač - 29 May 2007 09:06 GMT
Hi!

Is it possible to alter tablespace so that you don't connect to the
database?
The problem I have is this. I got a DB backup from a machine with 16 Gb of
RAM. There was a bufferpool set to use 10 Gb of RAM. Now I have to put it
on a machine with only 8 Gb of RAM. The restore is OK, but I'd like to
decrease that bufferpool to only use 4 Gb.

Best regards,
       Kovi

Signature

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

|  In A World Without Fences Who Needs Gates?   |
|              Experience Linux.                |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Knut Stolze - 29 May 2007 09:08 GMT
> Hi!
>
[quoted text clipped - 4 lines]
> on a machine with only 8 Gb of RAM. The restore is OK, but I'd like to
> decrease that bufferpool to only use 4 Gb.

You want to change the tablespace or the bufferpool?

You could simply start DB2 and activate the database.  If there is not
sufficient RAM, DB2 will start with very small bufferpools (usually
hidden).  Now you can change the BP and re-activate the database with the
new, reduced size.

Signature

Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Gregor Kovač - 29 May 2007 09:52 GMT
>> Hi!
>>
[quoted text clipped - 11 lines]
> hidden).  Now you can change the BP and re-activate the database with the
> new, reduced size.

We are on a 64-bit machine and Windows and when you connect to the database
the pagefile (Windows virtual memory) grows for Gbs and it takes almost an
hour for connect to succeed.
I just thought that there is a command like activate database with default
bufferpool :)))

Best regards,
       Kovi

Signature

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

|  In A World Without Fences Who Needs Gates?   |
|              Experience Linux.                |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Serge Rielau - 29 May 2007 14:39 GMT
>>> Hi!
>>>
[quoted text clipped - 16 lines]
> I just thought that there is a command like activate database with default
> bufferpool :)))
I pinged backstage and here is the recommendation:
DB2_OVERRIDE_BPF
Operating system: All
Default: not set, Values: a positive numeric number of pages OR
<entry>[;<entry>…] where <entry>=<buffer pool ID>,<number of pages>
This variable specifies the size of the buffer pool, in pages, to be
created at database activation, rollforward recovery, or crash recovery.
It is useful when memory constraints cause failures to occur during
database activation, rollforward recovery, or crash recovery. The memory
constraint could arise either in the rare case of a real memory shortage
or, because of the attempt by the database manager to allocate a large
buffer pool, in the case where there were inaccurately configured buffer
pools. For example, when even a minimal buffer pool of 16 pages is not
brought up by the database manager, try specifying a smaller number of
pages using this environment variable. The value given to this variable
overrides the current buffer pool size.
You can also use <entry>[;<entry>…] where <entry>=<buffer pool
ID>,<number of pages> to temporarily change the size of all or a subset
of the buffer pools so that they can start up.
Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.