Apply Maintenance for All DB Aliases

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

Apply Maintenance to DB Alias?

When you select Apply Maintenance to databases for all DB Aliases, the Configuration program prompts you to confirm maintenance for each DB Alias in the selected Optim™ Directory one at a time.

Apply Maintenance for DB Alias Access - Apply Maintenance to DB Alias? dialog

On the Apply Maintenance to DB Alias? dialog, you can do the following:

Note: The steps to connect to the database and create/drop packages, plans or procedures are the same as those described to apply maintenance for a single DB Alias.

Apply Maintenance to Another?

After you apply maintenance for a 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