Implementing Siebel Business Applications on DB2 UDB for z/OS > Preparing for Implementation on the DB2 Host > Additional Postinstallation Steps for DB2 Connect >

Defining a Database Alias and Testing a Connection

This section describes how to define a database alias and test a connection.

When you create a connection to DB2 on z/OS, the connection is defined with a database alias that has the appropriate connection information for your database. This alias is the connect string that you specify when you install the Siebel Server. Record the connect string in the copy you made of Deployment Planning Worksheet.

To define a database alias

To define your database alias, use the DB2 Configuration Assistant or the DB2 Command Line Processor.

NOTE:  If you define database aliases, you must add the TXNISOLATION parameter to the database alias entry in the db2cli.ini file and set it to have a value of 1.

For information on setting values in the db2cli.ini file and for using the DB2 Configuration Assistant or Command Line Processor, refer to the relevant IBM documentation.

To test the database connection on the Windows platform

1. To ensure that you can connect to the database alias that you have defined, use either the DB2 Configuration Assistant or the DB2 Command Window or Command Line Processor.
2. To use the DB2 Configuration Assistant method, start the utility then highlight the database alias that you created, and right-click.

   A dialog box appears allowing you to select an option to test the connection.

3. Enter an authorized user ID and password, and select ODBC and CLI as the test parameters.

   The following message indicates a successful connection:

   CLI connection tested successfully.
   ODBC connection tested successfully.

Alternatively, you can use the DB2 Command Window or the DB2 Command Line Processor to test the database connection by typing the following and then pressing ENTER:

DB2 connect to dbalias user database userid using database password

where dbalias is the database alias you created using DB2 and userid and password are an authorized user ID and its associated password on the DB2 host.

If the connection is successful, database connection information appears.

To test the database connection on the UNIX platform

1. Open a UNIX shell.
2. Go to the SIEBSRVR_ROOT directory, that is, the directory in which the Siebel Server is installed, for example, home/siebel/siebsrvr.
3. Enter the following command:

   DB2 connect to database_alias user user_ID using password

   where dbalias is the database alias you created using DB2 and user_ID and password are an authorized user ID and its associated password on the DB2 host.

   If your connection is valid, database connection information appears.