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 >
Connecting to the Database Using DB2 Connect
You install the Siebel Database Server on DB2 UDB for OS/390 and z/OS using either manual execution methods or the Database Server Configuration Utility on a client Siebel Server. (Installation methods are discussed in Siebel Schema Installation on the DB2 Host.) Subsequently, you will execute SQL on DB2.
There are two methods you can use to execute the SQL files from a designated Siebel Server:
- Method 1. Install DB2 Connect and configure ODBC to connect to DB2, then use an ODBC utility (such as odbcsql
from Siebel Systems) or a version control tool for file execution. To use this method, review Configuration Options for DB2 Connect to determine the configuration appropriate to the Client your enterprise supports, then follow the instructions in Setting Up DB2 Connect
- Method 2. Install TCP/IP and use FTP (or any other file transfer program) to transfer files to DB2, then use a native IBM utility such as SPUFI for file execution. This method is outside the scope of this guide. If you want to execute SQL using IBM native utilities, refer to IBM documentation.
Bookshelf Home | Contents | Index | Search | PDF |
Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS Published: 18 April 2003 |