Implementing Siebel Business Applications on DB2 UDB for z/OS > Maintenance Considerations for z/OS >

Using odbcsql to Submit SQL Statements

The Siebel Server installation program installs the odbcsql utility in the SIEBSRVR_ROOT\bin directory (Windows) or the SIEBSRVR_ROOT/bin directory (UNIX) of the Siebel Server. Siebel Business 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 submit SQL statements, for example, to obtain the DB2 storage group names for data and indexes which you have to specify during the Siebel Database installation process.

NOTE:  You can also use other utilities that allow you to query and return result sets to the client.

You can also use odbcsql to test your ODBC data source after you install the Siebel Server.

To execute odbcsql

• Navigate to the SIEBSRVR_ROOT\bin directory (Windows) or the SIEBSRVR_ROOT/bin directory (UNIX) and enter the following from the command prompt:

  odbcsql /s database_alias /u username /p password

  for example:

  odbcsql /s siebsrvr_siebel /u sadmin /p sadmin

  where:

  /s = the source ODBC DSN for the connection.

  /u = the user ID.

  /p = the password.

If the odbcsql connection is successful, you can enter queries against the DB2 catalog tables. For example, the following query returns a list of all DB2 storage groups:

SELECT NAME FROM SYSIBM.SYSSTOGROUP;

To exit odbcsql, enter EXIT. For additional information on the utility, enter the following at a command prompt:

odbcsql /help

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