H. Features Introduced in Ingres 9.0 (Ingres 2006) : Additions to the Visual DBA Suite : Visual Configuration Differences Analyzer
 
Share this page                  
Visual Configuration Differences Analyzer
The new Visual Configuration Differences Analyzer (VCDA) tool allows you to compare the configuration information for two Ingres installations. VCDA enables you to take snapshots of the installation and compare these snapshots with either a snapshot taken at some point in the past or with a configuration snapshot taken on another machine.
For example, after you install Ingres and have tuned the configuration to meet your needs, take a snapshot of the configuration. If you encounter problems with the installation later on, take another snapshot of the configuration and compare it to the earlier snapshot to determine if any configuration changes have contributed to the problem. Keep an on-going record of configuration changes by taking a snapshot of the installation each time you change its configuration.
VCDA snapshots contain information taken from the config.dat file, the symbol table, and the vnode database, as well as environment variables set at the system and user level.
Specifically, VCDA allows you to:
Save a snapshot of the current installation configuration into a file
Compare two snapshot files, or the current installation with a saved snapshot
Restore selective groups of configuration parameters from a saved snapshot
VCDA lists the differences with an associated icon that distinguishes between those parameters that are different and those that exist in one snapshot but not in the other.
VCDA uses information from the config.dat file, which typically contains parameters that apply to the local host name only. However, if you want to concatenate the contents of all your config.dat files into a single config.dat file to distribute across multiple environments, VCDA manages this situation as follows:
The host name under which a snapshot is saved becomes part of the snapshot information.
If VCDA detects that host names other than the snapshot host name are managed within the config.dat information of the snapshot, VCDA displays them.
A host name mapping option is available in that situation, so that VCDA can compare the additional host names’ configuration parameters. If this option is not used, the parameters are compared, including their host names (that is, only parameters that are identical for the same host name in the two snapshots are considered identical).
For more information, see online help for VCDA.