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.
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.
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.

On this dialog, when you apply maintenance for Optim directory access, the User ID must match the identifier for Optim directory tables.
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.
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.
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.