Skip to Content
author's profile photo Former Member
Former Member

DB2 Performance

Hello,

We have installed DB2 UDB V8.2 FIXPAK 11 64-bit as a backend for SAP ERP 2005 system.

The values for BufferPool Size is the key for DB2 DB Performance? or is there any other parameters I have to know about?

At present, the server has 6GB Main memory and 20GB swapspace.

At the time of SAP installation, the SAPINST tool created a BufferPool with the value 500. Do you know, how much in MB does this 500 represents?

I really appreciate your response.

Thank you,

Nikee

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Aug 01, 2006 at 06:37 AM

    Hi Nikee,

    the initial size of the bufferpool is typically too small for productive systems. Did you use a new installation kit that creates your database with uniform 16K pagesize?

    If not, you have to maintain at two bufferpools.

    You can use

    db2 " select bpname, npages*pagesize/1024/1000 from syscat.bufferpools "

    to find out your bufferpool sizes in MB. Please have a look at note 584952 for recommended settings and tuning infos.

    Regards

    Frank

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 04, 2006 at 01:01 AM

    Nikee,

    From transaction DB6cockpit you can go to performance -> Bufferpools, this will show you the bufferpools in your system and how they are performing. It also shows their page size.

    You can get more information by going to configuration in DB6COCKPIT and using functions for bufferpools.

    You can use Alter Bufferpool command to change bufferpool size, but keep in mind other applications being run on the same machine.

    Cheers,

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.