Siebel Installation Guide for UNIX > Configuring Siebel Enterprise Server and Related Components > Verifying the ODBC Data Source >

Verifying the ODBC Data Source for DB2 UDB

This topic is part of Verifying the ODBC Data Source.

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

Information in this topic applies also to virtual ODBC data sources in a clustered environment.

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

For more information about the ODBC data source, see Planning RDBMS Installation and Configuration.

NOTE:  For information about verifying the ODBC data source for DB2 UDB for z/OS, see Implementing Siebel Business Applications on DB2 UDB for z/OS.

To verify the ODBC data source for DB2 UDB for UNIX and Windows (on UNIX)

1. Open a DB2 Command Window.
2. Run the following command:

   db2 get cli cfg for section EnterpriseName_DSN

   where EnterpriseName is the name given the Siebel Enterprise during initial configuration, for example SBA_80.

   Entering this command generates the following results:

   Section: EnterpriseName_DSN

   -------------------------------------------------

   dbalias=SBL

   clipkg=6

   txnisolation=1

   The dbalias is the database alias catalogued for your DB2 UDB for UNIX and Windows database server.

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

   See also Guidelines for Preventing DB2 UDB from Running Out of ODBC Statement Handles.

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. Source the siebenv.csh (C shell) or siebenv.sh (Korn or Bourne shell) file.
5. Test the connection by navigating to $SIEBEL_HOME/bin and entering the command:

   odbcsql /u database_account_name /p password /s ODBC_DSN

   where:

   • database_account_name = A valid database account name
   • password = The corresponding database account password
   • ODBC_DSN = The ODBC data source name, in the form EnterpriseName_DSN, where EnterpriseName is the name of your Siebel Enterprise

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

     If your ODBC DSN is not working, the program exits with an error message. For more information, see Verifying Network Connectivity for the Siebel Server Machine and Troubleshooting the ODBC Data Source Connection.