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.

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?

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

Why?


Why?

Hire a DBA.

End of the report.

Smart move... but I still think that buying much more expensive hardware would have been much better...

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.