Bookshelf Home | Contents | Index | Search | PDF

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

Using Odbcsql to Verify Database Connectivity

---

The Siebel Server installation program installs a utility called odbcsql in the SIEBSRVR_ROOT\bin directory of your Siebel Server. Siebel eBusiness Applications use this program to perform operations on the DB2 database whenever these operations are performed from the midtier—that is, from the Siebel Server.

You can use odbcsql to obtain DB2 storage group names for data and indexes that you will be prompted for during the Siebel Database Server installation process.

It is recommended that you use odbcsql to test your ODBC data source after you install the Siebel Server.

To execute odbcsql

Enter the following text at a command prompt, as appropriate for your operating system:

odbcsql /source database_alias /user username /password password

for example:

odbcsql /source siebsrvr_siebel /user sadmin /password sadmin

Using odbcsql, you can then enter queries against the DB2 catalog tables, for example:

SELECT NAME FROM SYSIBM.SYSSTOGROUP;

This query returns a list of all DB2 storage groups.

To exit odbcsql, enter EXIT.

For additional information, enter the following at a command prompt:

odbcsql /help

The odbcsql utility is also useful in troubleshooting postinstallation connectivity problems that come from the ODBC layer of your installation.

Bookshelf Home | Contents | Index | Search | PDF