Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: optimal performance in bufferpool.

    Hi colleagues,
    could someone tell me the points to consider for optimal performance in bufferpool?

    Thank you for you help.
    DBA DB2 for LUW

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    I have posted a lot of replies on this subject over the 10 years you have been a member of this forum.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Quote Originally Posted by georgipa View Post
    could someone tell me the points to consider for optimal performance in bufferpool?
    There is just 1 point: tune it so that it fits best for your applications and workloads.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    I've been looking and no one says points to be taken intoaccount optimal to set a bufferpool.

    Thank you for your help.
    DBA DB2 for LUW

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    just looking is not enough ..
    please read the performance guide or have a look at some docs in developerswork..
    as there is
    DB2 Basics: Table spaces and buffer pools
    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
    http://www.infocura.be

  6. #6
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    This is your lucky week: IDUG : Blogs : DB2 for LUW Performance: Buffer Pool Tuning. In dutch we would say:"vers van de pers"
    Somewhere between " too small" and " too large" lies the size that is just right.
    - Scott Hayes

Posting Permissions

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