You can update the DBMS version for a single DB alias. However, if you are using Sybase ASE, SQL Server, or Informix® and you have multiple databases on one server, the Configuration program automatically directs you to the appropriate dialogs. The initial steps are the same whether you are updating the DBMS version for one DB Alias or multiple DB Aliases.
The first step in updating the DBMS version for a DB Alias is to specify the name of the Optim™ Directory that is associated with that DB Alias. Click the down arrow to select an Optim Directory from a list and click Proceed to connect to the database.
The Configuration program must connect to the database to access the Optim Directory tables. On the Connect to Database dialog (see Connect to Database), specify the User ID, Password, and Connection String that allows the workstation to connect to the database. If the connection is successful, you can create or select a DB Alias.
The next step is to select the DB Alias to update the corresponding DBMS version on the Create/Select DB Alias dialog.

Click the down arrow to select a DB Alias from the list of existing DB Alias names, and then click Proceed to continue.
In most cases, you must specify the DBMS version to use for the selected DB Alias on the Specify DB Alias DBMS dialog. (A DBMS version is not needed for certain data sources, such as PostgreSQL.)

Click the down arrow to select a version from the list. The version that you select must be different from the current version. If not, an error message displays. To continue, click Proceed.
If you are updating the DBMS version for only one DB Alias, the Connect to Database dialog opens. Specify the User ID, Password, and Connection String needed to connect to the selected database.
The Configuration program displays the Create/Drop Packages dialog, the Create/Drop Stored Procedures dialog, or the Bind/Drop Plans dialog, as appropriate for the DBMS you are using.

The Drop option is selected when the dialog opens. You can select the Display SQL check box to browse the DDL statements that are generated for the process. To continue, click OK.
After the Drop process completes, the dialog redisplays with the Create/Refresh option automatically selected. Click Proceed to create the following items:
When the process completes, the database signature is updated automatically and the Complete dialog displays.