If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: How to start primary key analysis of an existing datamodel

Hi,
I am working in a insurance related project using DB2 mainframe database. It's 5 year old sytem. We store policy and coverage information in different tables. We have near about 30 tables to store all informayion and coverage related table holds the most information. Because for each transaction of a praticular policy includes on an average 6 coverages. So coverage informations are increased over time and now it stores 24 million records. Now because of this huge volume, sytem speed has degraded over time. So we are planning to make it more sclable. So we need to start primary key anaysis for whole data model. Please suggest me how should i start the analysis. Please post all you suggestions to improve the performance from database perspective. Recently we are moving to DB2 v9 version also. Will it help any way.
Thank you.