Apply Maintenance for Optim Directory Access

At times, it may be necessary to refresh or update the packages, plans, or procedures needed to access the Optim™ directory tables. Generally, you apply maintenance for Optim directory access when installing a new version of Optim. To refresh or update the packages, plans, or procedures for the Optim directory tables, select Apply Maintenance for Optim Directory Access from the Tasks menu.

Specify Optim Directory

The first step in applying maintenance for Optim directory access is to provide the name of the Optim directory. The Configuration program prompts for this information by presenting the Specify Optim Directory dialog (see Specify Optim Directory). You must select Use Existing Optim Directory and Registry Entry, select an Optim directory name, and click Proceed to open the next dialog.

Connect to Database

When applying maintenance for Optim directory access, the Configuration program must connect to the database to create or refresh the packages, plans, or procedures. On the Connect to Database dialog, you must provide the User ID, Password, and Connection String that the workstation needs to connect to the Optim directory.

Apply Maintenance for Optim Directory Access - Connect to Database dialog

On this dialog, when you apply maintenance for Optim directory access, the User ID must match the identifier for Optim directory tables.

Create/Drop Packages

Before creating or refreshing packages, plans, or procedures for the Optim directory tables, the Configuration program displays the Create/Drop Packages or Create/Drop Stored Procedures dialog (see Create/Drop Packages), or the Bind/Drop Plans dialog (see Bind/Drop Plans). You can choose to browse the DDL statements generated to create or refresh the packages, plans, or procedures. In addition, if the specified Optim directory tables are not the ones you want to use, you can cancel the process.

Add Default Tables

After packages, plans, or procedures are created for the Optim directory, the Configuration program prompts you to add default tables to the Optim directory. If you select the check box, the Configuration program verifies that default Calendars and Currency tables are in the Optim directory. If not found, these tables are loaded automatically.

Apply Maintenance to Another?

Before completing the task to Apply Maintenance for Optim Directory Access, the Configuration program prompts you to apply maintenance for access to another Optim directory. If you select the check box, you can repeat the maintenance process. To end the task, clear the check box and click Proceed.



Feedback