Database Management Technology

The DBAnalyzer Client Consoles are used to manage multiple remote Ingres installations from a single workstation. Each console connects to the DBAnalyzer Console Server on the target node. The client installation is performed with the DBAnalyzer Install Shield setup wizard which installs and configures the Win32 client environment. To start the setup wizard double click on Setup.exe in the download directory. Respond to the prompts for licensing, installation directory, and Windows program group. At the end of the installation process you will be prompted for the DBAnalyzer definition database node and the Ingres installation ID for that node.

Definition Database Node
The definition database stores common configuration data for all DBAnalyzer subsystems, typically there is only one definition database for the entire DBAnalyzer installation.

Enter the TCP node name where the definition database resides. You must have TCP connectivity with the node name specified. TCP connectivity can be tested with the ping command from the DOS shell prompt.

ping node_name

If the definition database node name is not known at install time you can set the value later from the DOS shell:

"%DBA_SYSTEM%"\bin\dba_setenv DBA_DEFINITION_NODE node_name

To determine the current definition node setting:

"%DBA_SYSTEM%"\bin\dba_prenv

Definition Database Install ID
The DBAnalyzer definition database is created in a specific Ingres installation running on the node specified above. Each Ingres installation has a unique two character identifier stored in the Ingres environment table. To determine the installation identifier log on to the node defined above, establish the proper Ingres environment and issue the following shell command:

ingprenv II_INSTALLATION (Unix & Windows)

show logical II_INSTALLATION (VMS)

This command will return the two character installation identifier.

The installation identifier is used to determine the listener address of the DBAnalyzer Console Server on the node specified above. If the installation id is not know at install time you can set the value later from the DOS shell prompt:

"%DBA_SYSTEM%"\bin\dba_setenv DBA_DEFINITION_IID install_id

To determine the current installation id setting issue the following from the DOS shell:

"%DBA_SYSTEM%"\bin\dba_prenv