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 comment
10|10000 characters needed characters exceeded

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 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 comment
    10|10000 characters needed characters exceeded