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 >

Setting Up DB2 Connect

---

To set up DB2 Connect, follow the instructions below that apply to your chosen DB2 Connect configuration.

Define a database alias. Define a database alias with the proper connection information for your database. This alias is the connect string that you specify when you install Siebel Server. Record the connect string in the copy you made of Deployment Planning Worksheet.

To define your database alias, use the DB2 Client Configuration Assistant or the DB2 Command Line Processor. For more information, refer to the IBM document Administration Guide for DB2 Universal Database for OS/390 and z/OS (version 7).

Enable ODBC. Enable ODBC to point to DB2 UDB for OS/390.

To enable ODBC to point to DB2, use the DB2 Client Configuration Assistant's BIND option to bind the CLI/ODBC Support packages.

Install TCP/IP and FTP. For instructions on installing TCP/IP, refer to the IBM document Installation Guide for DB2 Universal Database for OS/390 and z/OS (version 7).

Configuring DB2 Connect EE to Support Siebel Web Client

Using DB2 Connect EE to support the Siebel Web Client involves:

Siebel Server (running Application Object Managers to support Siebel Web Client). Typically, DB2 Connect EE is also installed on this machine.
Optionally, an additional computer on which you install IBM's DB2 Connect EE, to act as a gateway to the database.
DB2 UDB for OS/390 and z/OS.
Individual workstations running Siebel Web Client.

This approach is illustrated in the lower part of Figure 1.

Perform the following steps to configure DB2 Connect EE for a server machine.

To connect to DB2 using a DB2 Connect EE gateway

Using vendor instructions. install DB2 Connect EE on a server machine (typically the machine on which Siebel Server will be installed).

The DB2 Connect EE Server machine functions as a DB2 UDB server, with protocol support for DB2 UDB for OS/390 and z/OS.

You can also add DB2 Connect to an existing server with DB2 already installed.

On the DB2 Connect EE Server, upgrade DB2 Connect EE to the appropriate fix pack.

For information regarding the supported fix pack version, refer to Siebel System Requirements and Supported Platforms.

On the DB2 Connect EE Server machine, catalog your DB2 OS/390 database, as appropriate, using the DB2 Client Configuration Assistant or the DB2 Command Line Processor.

After installation, use a standard DB2 UDB client to access the DB2 Connect EE Server.

Configuring DB2 Connect EE to Support Siebel Dedicated Web Client

Using DB2 Connect EE to support the Siebel Dedicated Web Client involves:

A computer on which you install IBM's DB2 Connect EE, to act as a gateway to the database. This computer might be a Siebel Server machine or a separate machine.
DB2 UDB for OS/390 and z/OS
Siebel Dedicated Web Client workstations

This configuration enables a high volume of concurrent network transactions between Siebel Dedicated Web Clients and the DB2 Connect EE Server machine. This approach combines elements from both scenarios shown in Figure 1.

To connect to DB2 using a DB2 Connect EE gateway

Using vendor instructions. install DB2 Connect EE on a server machine (typically the machine on which Siebel Server will be installed).

The DB2 Connect EE Server machine functions as a DB2 UDB server, with protocol support for DB2 UDB for OS/390 and z/OS.

On the DB2 Connect EE Server, upgrade DB2 Connect EE to the appropriate fix pack.

For information regarding the supported fix pack version, refer to Siebel System Requirements and Supported Platforms.

On the DB2 Connect EE Server machine, catalog your DB2 OS/390 database, as appropriate, using the DB2 Client Configuration Assistant or the DB2 Command Line Processor.

After installation, use a standard DB2 UDB client to access the DB2 Connect EE Server.

Configuring DB2 Connect PE to Support Siebel Dedicated Web Client

Using DB2 Connect PE to support the Siebel Dedicated Web Client involves:

Siebel Dedicated Web Client workstations on which you install IBM's DB2 Connect Personal Edition (PE), to act as a gateway to the database.
DB2 UDB for OS/390 and z/OS

With this approach, users on a Siebel Dedicated Web Client connect directly to DB2. This approach is illustrated in the upper part of Figure 1.

To connect to DB2 using DB2 Connect PE

Install DB2 Connect PE on each Siebel Dedicated Web Client workstation machine.
On each machine, upgrade DB2 Connect PE to the appropriate fix pack.

For information regarding the supported fix pack version, see Siebel System Requirements and Supported Platforms.

If you previously installed a DB2 Connect run-time client, the DB2 Connect installer upgrade adds only the functionality required for the existing client. (This is also the case if you have a DB2 server or SDK installed on your workstation.)

On the workstation machine, catalog your OS/390 databases as appropriate, using the DB2 Client Configuration Assistant or the DB2 Command Line Processor.

After installation, use a standard DB2 UDB client to access DB2 Connect.

Bookshelf Home | Contents | Index | Search | PDF