Update the DBMS for a Single DB Alias

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.

Specify Optim Directory

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.

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

Create/Select DB Alias

The next step is to select the DB Alias to update the corresponding DBMS version on the Create/Select DB Alias dialog.

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

Note: If you are using SQL Server, Sybase ASE, or Informix and have several databases on one server, the Configuration program automatically selects every DB Alias that is located on the same server.

Specify DB Alias DBMS

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

Example of the Specify DB Alias DBMS dialog

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.

Connect to Database

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.

Note: If you are updating the DBMS version for Sybase ASE, SQL Server, or Informix and you have several databases on one server, see Update Multiple DB Aliases for details.

Create/Drop Packages

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.

Example of the Create/Drop Packages dialog

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.



Feedback