Hello All,

I am working on a task to find problems in two databases. One belongs to DB2v8 FP 9 while other DB2v9.1 FP3.

On AIX ver 5.3, can someone help me in fiinding following

1. DB2 Overall responsiveness
2. Network Latency
3. System ( storage ) disk responsiveness

Thanks

DBFinder

You can use the following to get the comparison chart between both the databases.

1> db2top & db2 snapshots for Database and Instance
2> netstat - identify latency in transactions due to network data transfer time
3> iostat -- system disk responsiveness

Thanks

This should be good to start investigation

Regards
DBFinder