Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2009
    Posts
    153

    Unanswered: Database Performance

    Hi Experts,

    How can i improve the performance of my database?

    What are the steps to be taken care?

    How can we normalize a database which i already in use in a better way ?

    PLease help..

    Thanks In Advance.

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Buy more expensive hardware.

    Sorry, but your question is so general so that we cannot give you any serious answer. Have you applied the usual database configuration and tuning techniques that are described in the DB2 manual?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Jan 2009
    Posts
    153
    Thanks Stolze,

    We have clustered index on primary key columns.

    We have more than 150 tables in the data which will store millions of data(now its around 1000 data).

    I have be asked to give a report to improve performance What to do .

    PLease help.

    I hope indexing the columns will help improve performance but on wat basis i will index?

    TIA

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by ratheeshknair View Post

    We have clustered index on primary key columns.
    Why?


    Quote Originally Posted by ratheeshknair View Post
    I hope indexing the columns will help improve performance
    Why?
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Hire a DBA.

    End of the report.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  6. #6
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Quote Originally Posted by ratheeshknair View Post
    We have clustered index on primary key columns.
    Smart move... but I still think that buying much more expensive hardware would have been much better...

    I hope indexing the columns will help improve performance but on wat basis i will index?
    You build indexes based on your workload.


    Without a solid knowledge about the effect of certain tuning efforts, you can stab in the dark and will usually miss. So start with reading the manual to learn how DB2 works and what you can do to improve performance. Also, if you need to improve performance, it would be really good to set some performance targets that you want to reach. Otherwise, you could improve a single query extremely well - and slow down the main workload.

    In case you don't have enough time, you can use the tools that come with DB2, e.g. configuration advisor and design advisor are good starting points.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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