Using the Product in a DB2 Environment › Analyze DB2 Data

Analyze DB2 Data

Delays in processing SQL statements are usually caused by improperly designed applications and databases, inadequate indexing, and programming errors. CA Mainframe Application Tuner can help identify application problems that occur when performing the following activities:

• Designing the application program
• Determining when an application should be rebound
• Determining the access path chosen for a query
• Designing the database

CA Mainframe Application Tuner enables you to analyze DB2 data to the SQL statement level.