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 MAT 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 MAT enables you to analyze DB2 data to the SQL statement level.