Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2007
    Posts
    265

    Unanswered: Need help Optimizing DB2

    Hello,

    We recently set up a brand new Linux CentOS machine with DB2 UDB 8.1 FP 18 64-bit and I wanted to make sure that I have the configuration parameters all optimized. What are the various variables I should be looking at? Or be concerned about? Any help will be appreciated! Thanks!

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by db2user24 View Post
    I wanted to make sure that I have the configuration parameters all optimized
    Optimized for what?

  3. #3
    Join Date
    Nov 2007
    Posts
    265
    Quote Originally Posted by n_i View Post
    Optimized for what?
    I guess my question is too generic.. basically I was wondering about Performance Tuning DB2...I know for sure that I need to check the bufferpool size since the new machine has much more memory.. was just wondering what other parameters can be set up to ensure faster speed on the SQL queries / procedures.

    Here are some of the other parameters that have been setup on one of our current systems --

    DB2_FMP_COMM_HEAPSZ=60000
    DB2_STRIPED_CONTAINERS=YES
    DB2_HASH_JOIN=ON
    DB2COMM=tcpip
    DB2_PARALLEL_IO=*
    DB2AUTOSTART=YES

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    If the current application performance does not cause concerns, there is no need to optimize anything.

    If, on the other hand, there are specific issues with performance, they need to be analyzed and appropriate actions taken. Use snapshot monitor output to identify problem areas, such as:
    - bufferpool hit ratios;
    - sort overflows;
    - lock escalations and timeouts;
    - prefetch performance;
    - low query selectivity (rows selected to rows read ratio);
    - page cleaner efficiency;
    - etc.

    Once you have identified the problem, it will be relatively simple to determine what tuning needs to be done.

  5. #5
    Join Date
    Nov 2007
    Posts
    265
    thanks for the response, appreciate it!

  6. #6
    Join Date
    Aug 2008
    Posts
    147
    Also , look at your maintenance plans - re: indexes, statistics.
    ---------------------------------
    www.sqlserver-dba.com
    www.dba-db2.com

Posting Permissions

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