IBM Mainframe DB2 Performance Analysis by Using DB2PM
Yong Liu, Ibm China · Microelectronics & Computer · 2004
This article introduces how to use DB2 PM to monitor DB2 activities in IBM mainframe and how to collect the trace data for performance and problems analysis. And give some simple introductions for DB2 PM reports, such as SQL ACTIVITIES, DEADLOCK, SUSPENSION etc. Finally, give a whole process of collecting, analysis and resolving the deadlock problems during the stress testing of eCommerce product.