Implementing Siebel Business Applications on DB2 for z/OS > Preparing for Implementation on the DB2 Host > Performing Postinstallation Tasks for DB2 Connect >

Defining a Database Alias and Testing a Connection

This topic 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 your database alias, use the DB2 Configuration Assistant or the DB2 Command Line Processor. 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.

NOTE:  When 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.

Testing the Database Connection in a Windows Environment

Use the following procedure to test the database connection in a Windows environment.

To test the database connection on the Windows platform

1. To ensure that you can connect to the database alias that you have defined, you can use either the DB2 Configuration Assistant, or the DB2 Command Window or Command Line Processor.

   To use the DB2 Configuration Assistant method, start the utility, highlight the database alias that you created, and right-click.

2. Select the Test Connection option.
3. Enter an authorized user ID and password, and select ODBC and CLI as the test parameters.
4. Click Test Connection.

   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, then pressing Enter:

DB2 connect to database_alias user database_userID using database_password

where:

• database_alias is the database alias you created using DB2
• database_userID and database_password are an authorized user ID and its associated password on the DB2 host.

If the connection is successful, database connection information appears.

Testing the Database Connection in a UNIX Environment

Use the following procedure to test the database connection in a UNIX environment.

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.
3. Enter the following command:

   DB2 connect to database_alias user database_userID using database_password

   where:

   • database_alias is the database alias you created using DB2
   • database_userID and database_password are an authorized user ID and its associated password on the DB2 host.

     If your connection is valid, database connection information appears.