Updating the DBMS Version for an Optim Directory

When you select Update the DBMS Version for an Optim Directory from the Tasks menu, you are cautioned to select this task only if the Optim™ Directory is located a database that has been upgraded to a new version. This task prompts you do the following steps.

Tasks to update the DBMS version for an Optim Directory

  1. Select the Optim Directory to update and the new DBMS version.
  2. Drop the old packages, plans, or procedures and create new ones for the Optim Directory.
  3. Update the database signature for the Optim Directory.

When the process completes, the database signature is updated automatically.

Specify Optim Directory

The first step in updating the DBMS version for an Optim Directory is to specify the name of the directory. Click the down arrow to select from a list and click Proceed.

Example of the Specify Optim Directory dialog.

Specify Optim Directory DBMS

You must specify the version of the DBMS you want to use to update the Optim Directory.

Example of the Specify Optim Directory Version dialog

Click the down arrow to select a version. The version that you select must be different from the current version. If not, an error message displays. Click Proceed to connect to the database.

Connect to Database

When you update information for the Optim Directory, the Configuration program must connect to the database to access the Optim Directory Tables. On the Connect to Database dialog (see Connect to Database), specify the User ID, Password, and Connection String that allows the workstation to connect to the database. If the connection is successful, the next step is to drop the old packages, plans, or procedures and create new ones for the updated DBMS.

Create/Drop Packages

The Configuration program displays the Create/Drop Packages dialog, the Create/Drop Stored Procedures dialog, or the Bind/Drop Plans dialog, as appropriate for the DBMS you are using.

Example of the Create/Drop Packages dialog

The Drop option is selected when this dialog opens. You can select the Display SQL check box to browse the DDL statements that are generated for the drop process. To continue, click Proceed.

Note: The Configuration program attempts to drop all old packages, plans, and procedures for the specified DBMS version, even if they were never installed.

After the Drop process completes, the dialog redisplays with the Create/Refresh option automatically selected. Click Proceed to create packages, plans, or procedures to update the DBMS for the Optim Directory.

When the process completes, the database signature is updated automatically and the Complete dialog displays.



Feedback