Database properties and connection information for DB2

If you use a DB2® database and upgrading, you must update the database properties of your schema repositories and user databases.

Before any clients connect to a user database, you must run the binddb2pkg command for each physical DB2 database, including the physical databases used to run all of the Rational® ClearQuest® schema repositories and user databases. The command syntax is as follows:

binddb2pkg server database DB2_admin DB2_password [port]

Run the binddb2pkg command if you are upgrading an existing user database to a version of Rational ClearQuest that includes an updated version of the DataDirect driver. For more information, see the binddb2pkg reference page.

If the database is in a DB2 instance that is not using port value 50000, you must specify the port value.

In releases earlier than version 8.0, the following fields were listed by the Maintenance Tool on the database properties pages for DB2:

Vendor (DB2)
Database Alias
User Name
Password

In latest version, these fields are listed by the Maintenance Tool on the database properties pages for DB2:

Vendor (DB2)
Database
Server
User Name
Password
Connect Options

In the latest versions, the Database field replaces the Database Alias field. The Database Alias field was used to store the alias name used by the DB2 client software. The alias name is no longer needed in the latest versions, but the DataDirect drivers require the name of the DB2 database. If the database alias is the same as the name of the DB2 database, no change is required for this field.

Another important change is the addition of the Server field. The value in the Server field must be the machine name of the server on which the DB2 database is running.

No change is necessary in the Administrator User Name and Administrator Password fields.

The Connect Options field has also been added. The valid parameters for this field are DATABASE, HOST and PORT. The parameter names are not case sensitive, but the values are. Parameters must be separated by semicolons, with no spaces in between.

The DATABASE and HOST parameters in the Connect Options field are optional.

To specify a different name for the database, use this form:

DATABASE=name

To specify a different name for the host, use this form:

HOST=host

The PORT parameter in the Connect Options field is not needed if the DB2 database is on the default port (50000), but is required if the DB2 database is on a nondefault port.

If the port number of the database is not the default (50000), enter it in this form:

PORT=number