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

Defining a Database Alias and Testing a Connection

The information in this section describes how to define a database alias and test a connection.

In creating a connection to DB2 on the zSeries, a connection is defined with a database alias that has the proper 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 more information, refer to the IBM documentation.

To test the connection on the Windows platform

1. Launch the Configuration Assistant, highlight the database alias that you just created, and right click.

   This brings up an additional dialog that allows you to test the connection.

2. Test the connection on the Windows platform using one of the methods below:

   Supply the userid and password and choose both ODBC and CLI as the test parameters.

   • If using the DB2 command window, enter

   DB2 connect to dbalias user database userid using database password

   • If using the DB2 Command Line Processor, enter

   connect to dbalias user database userid using database password

If the connection is successful you will see output similar to the following:

Database Connection Information

Database server = DB2 OS/390 7.1.1'1

SQL authorization ID = SADMIN

Local database alias = Q105

To test the connection on the UNIX platform

1. Open a UNIX shell.
2. Source the siebenv.csh file.
3. Enter the following command:

   DB2 connect to database_alias user user_ID using password

   where:

   user_ID = a valid user name on the DB2 host.

   password = the appropriate password for that user name.

If your connection is valid, database connection information appears; for example:

Database Connection Information

Database server = DB2 OS/390

SQL authorization ID = SADMIN

Local database alias = PS01

To verify the connection to the database using the Configuration Assistant

1. Launch the IBM DB2 Configuration Assistant.
2. Choose the appropriate database alias and from the Selected option section choose Test Connection.
3. From here you may test the CLI and ODBC connections using an authorized userid and password.

   The following message indicates a successful connection:

   CLI connection tested successfully.

   ODBC connection tested successfully.