hi,

I have some experience about this. Do you try db2 performance expert? it is very useful, it monitors, analyzes and tunes the performance of DB2 and DB2 applications, can help further optimize DB2 performance and maximize DBA productivity.

One book "DB2 High Performance Design and Tuning" should help you, you can search and find it.

--------------------------------------------------
...