SQL/CA Tools
-
Automated table statistics
-
SQL/CA provides a utility that automatically updates the catalog statistics
for designated tables on a periodical basis or depending on the growth rate
of these tables.
-
Program monitoring
-
DB2/VM may automatically change the access strategy of a stored program,
due to modified database objects, used by that program. Such non-controlled
changes may result in less efficient access paths. The SQL/CA program monitoring
utility detects and reports such changes in access method and cost.
-
Data modelling facility
-
It is desirable that the characteristics of development databases match those
of the production databases as closely as possible. This ensures that access
paths chosen by DB2/VM in the development environment match those in the
production system. For modelling purposes, DB2/VM allows a DBA to modify
most catalog columns intervening in path determination. Manually updating
the catalogs however is a time-consuming process and requires knowledge of
internal data formats. SQL/CA offers a utility program to copy catalog
information from one database to another.
-