Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2013

    Unanswered: How to optimise bufferpool hit ratio

    Hi All,

    Can anyone please guide me how to optimize the bufferpool hit ratio if the application downs the bufferpool hit ratio.
    The application is in progress and at that time i cannot increase the size of the bufferpool?

    What will be the first step to increase bufferpool hit ratio.

    Thanks in advance.

  2. #2
    Join Date
    Apr 2012
    Provided Answers: 17
    Consider doing some basic research and education first. The start point is the documentation. If you are inexperienced it is easier to use the self tuning memory option that DB2 provides, read about STMM here:

  3. #3
    Join Date
    Apr 2006
    Provided Answers: 11
    short questions get short answers
    indicate at least some info about db2level - platform - table - application - bufferpool settings - and at last : do not post generic questions, (the doc resolves these) but specific problems..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts