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.