Updating the DBMS Version for a DB Alias

When you select Update DBMS Version for a DB Alias from the Tasks menu, you are cautioned to select this task only if the DB Alias references a database that has been upgraded to a new version. This task prompts you to do the following steps.

  1. Select the Optim Directory that contains the DB Alias.
  2. Select the DB Alias and the new DBMS Version, if appropriate. (A DBMS version is not needed for certain data sources, such as PostgreSQL.)
  3. Drop the old packages, plans, or procedures and create new ones for the Optim™ Directory.

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



Feedback