If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > db cfg BUFFPAGE param in v8 and v9 - obsolete or not?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-28-09, 14:51
MarkhamDBA MarkhamDBA is offline
Registered User
 
Join Date: Dec 2008
Location: Toronto, Canada
Posts: 381
db cfg BUFFPAGE param in v8 and v9 - obsolete or not?

v8.2/AIX5.3 moving to v9.5.1/AIX6.1
v8 manual says BUFFPAGE db cfg par is obsolete, yet v9.5 says that it is being still used. See below:

v8 documentation:
The following database configuration parameters are obsolete:
buffpage: In previous versions, you could create or alter a buffer pool using a default size, and the value of buffpage would be taken as the default. In Version 8, you should explicitly specify the size of your buffer pools, using the SIZE keyword on the ALTER BUFFERPOOL or CREATE BUFFERPOOL statements.

v9.5 documentation:
for ALTER BUFFERPOOL command - The number of pages is the new number of pages to be allocated to this specific buffer pool. You can also use a value of -1, which indicates that the size of the buffer pool should be the value found in the buffpage database configuration parameter.

So what is the truth?
__________________
DB2 v9.5 ESE on AIX v6.1/ v9./10 on z/OS

Last edited by MarkhamDBA; 05-28-09 at 15:05.
Reply With Quote
  #2 (permalink)  
Old 05-28-09, 17:49
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
When IBM says it is deprecated that means they are putting people on advance notice that it should not be used and will be removed at some date in the future. IBM is pretty good about providing compatibility from one release to another, so they have left it in the code for now, but at some point it may be suddenly gone.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #3 (permalink)  
Old 05-29-09, 10:24
MarkhamDBA MarkhamDBA is offline
Registered User
 
Join Date: Dec 2008
Location: Toronto, Canada
Posts: 381
thanks, Marcus
__________________
DB2 v9.5 ESE on AIX v6.1/ v9./10 on z/OS
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On