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.