Analysis Options


Archiving the analysis results
The archiving option records the analyzed SQL statements, their EXPLAIN results and all SQL/CA warnings issued into the SQL/CA archive tables. These archives may prove useful in managing the performance of SQL applications. A number of archive report queries is provided with the product.
Updating Table Statistics before analysis
DB2/VM and the EXPLAIN command rely heavily on statistical data recorded in the DB2 catalog tables. To obtain reliable EXPLAIN results, it is essential that these statistics be up to date. When requested, the auto-statistics option will issue an UPDATE STATISTICS command for all tables referenced by the application being analyzed.
Command Analysis in server mode
As an alternative for interactive analysis, the analysis request may be forwarded to a virtual machine, executing the SQL/CA analysis program in server mode.