Use the Demo180.cfg File

The CA IDMS Visual DBA product folder contains an example saved configuration file named demo180.cfg. This file can be used to do the following:

• Verify the successful installation of CA IDMS Visual DBA on the PC.
• Familiarize yourself with the CA IDMS Visual DBA tree and its objects without having to establish a mainframe connection.

To use this saved configuration file, select Open from the File menu and select demo180.cfg from the product folder. To avoid possible SQL errors when using this saved configuration, you must establish a dummy connection to the ODBC data source "DummyConnect". This DummyConnect data source is predefined in the Node window of demo180.cfg.

The Dictionary object in the saved configuration has three instances: APPLDICT, SYSDICT, and SYSTEM, but only the dictionary SYSDICT has cached objects (instances). The saved configuration contains cached instances for most of the objects in the CA IDMS Visual DBA object tree.

You may view the Detail Information Pane and the dialogs for Alter, Create, Drop, Grant, Revoke, Register, and Responsibility. You can also invoke the online help for these dialogs.

If you attempt to display information that has not been cached in this configuration file, CA IDMS Visual DBA attempts to establish a connection to the data source that was used to create this saved configuration. If you have not established the “dummy connection”, you receive an SQL error. You may also receive an SQL error if you attempt to alter, create, drop, grant, or revoke an entity without having established the “dummy connection”. If this happens, click OK to continue using demo180.cfg.

To see the result of any Alter, Create, Drop, Grant, or Revoke dialog while using the dummy connection, select the View Syntax boxes in the preference settings for the OK Action preferences. Because there is no real connection, the syntax is not executed.

Note: After you have made a dummy connection to “DummyConnect”, all database requests from CA IDMS Visual DBA return no instances or return null attributes for all nodes. You must exit and restart CA IDMS Visual DBA before any real connections can be made.