Siebel Installation Guide for UNIX: Servers, Mobile Web Clients, Tools > Installing the Siebel Server >

Verifying the ODBC Data Source for DB2 UDB

The Siebel Server installation program automatically creates an ODBC system data source name (DSN) that it uses to connect to the Siebel Database Server. Prior to verifying the Siebel Server ODBC data source, make sure that the Siebel Server service is started.

CAUTION:  Do not change the default settings created automatically with the ODBC data source.

To verify the ODBC data source for DB2 UDB for Windows and UNIX and for DB2 UDB for z/OS and OS/390

1. Open the db2cli.ini file in the $SIEBEL_HOME directory and make sure that there is a section called [siebsrvr_enterprise name], where enterprise name is the name given the Siebel Enterprise during installation; its default name is siebel.
2. Verify that the following two values are present in the section:

   dbalias = aliasname (the database alias catalogued for your DB2 UDB for Windows and UNIX or DB2 UDB for z/OS and OS/390 database server)

   txnisolation = 1

   If the section is missing, run the configdb2 script in $SIEBEL_HOME/bin to set it, and then reverify that the section is present.

3. Verify that the SIEBEL_UNIXUNICODE_DB environment variable is set to DB2.

   NOTE:  If you use Siebel Marketing, which requires simultaneous heterogeneous database connectivity, set this variable to ORACLE, regardless of your database platform.

4. Test the connection by navigating to $SIEBEL_HOME/bin and entering the command:

   odbcsql /u user_name /p password /s ODBC DSNW

   where:

   ODBC DSN = The database connect string

   If you do not receive an error message, the ODBC connection is working.