Apply Maintenance for a Single DB Alias

If you select the option on the Query Method to Apply Maintenance? dialog to apply maintenance for a single DB Alias, the task includes the following steps: create/select the DB alias; connect to the database; drop old packages, plans, or procedures; create/refresh packages, plans, or procedures. After maintenance is applied, the task is complete, or you can choose to apply maintenance for another DB Alias.

Create/Select DB Alias

When you select Apply Maintenance to a database for a single DB Alias, the Configuration program opens the Create/Select DB Alias dialog allowing you to select the DB Alias for maintenance.

Apply Maintenance for DB Alias Access - Create/Select DB Alias dialog

The only available option is to use an existing DB Alias. Specify the name of the DB Alias you want to use. To select from a list, click the down arrow. Click Proceed to open the Connect to Database dialog.

Connect to Database

The Configuration program must connect to the database to apply maintenance to the Data Dictionary, Catalog Tables, or System Tables, depending on the DBMS you are using. When the Connect to Database dialog opens, the User ID, Password, Connection String, and DB Name are populated with previously entered values.

The User ID you specify must have DBMS authorization to create or refresh database packages, plans, or procedures. You can modify these values, as needed, and click Proceed to continue.

Drop Old Packages

The Configuration program displays the Drop Old Packages (Plans, or Procedures) dialog. If you select this option and click Proceed, you can drop old packages, plans, or procedures before creating new ones. If you do not select this option, you can create/refresh the appropriate packages, plans, or procedures. The following guidelines apply:

Note: If the same qualifier applies to multiple users, or if you regularly run different builds of Optim™, then you may not want to drop the old packages (plans or procedures).

Create/Drop Packages

The Configuration program displays the Create/Drop Packages dialog (see Create/Drop Packages), the Bind/Drop Plans dialog, or the Create/Drop Stored Procedures dialog, as appropriate for the DBMS you are using. This dialog allows you to Create/Refresh the

Apply Maintenance to Another?

After you apply maintenance for a single DB Alias, the Configuration program opens the Apply Maintenance to Another DB Alias? dialog and prompts you to apply maintenance for another DB Alias:



Feedback