Bookshelf Home | Contents | Index | Search | PDF

Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse > Database Parameters and Requirements for Siebel Data Warehouse >

IBM DB2 UDB zOS and OS/390-Specific Database Requirements for Siebel Data Warehouse

---

The following requirements apply to IBM DB2 RDBMS usage for zOS and OS/390:

• The Siebel Analytics applications communicate with IBM DB2 UDB for z/OS and OS/390 (running on zSeries servers) through IBM DB2 Connect middleware.

  The following editions of DB2 Connect are supported:

  • DB2 Connect Enterprise Edition (EE). This edition is installed on a midtier server such as an Informatica Server/Client, DAC, and Siebel Analytics.
  • DB2 Connect Unlimited Edition (UE). This edition provides the functionality of DB2 Connect Enterprise Edition but is priced differently.
• The ODBC driver for all connections must use the IBM DB2 ODBC Driver.
• Make the appropriate connections using the DB2 Client Configuration Assistant.
• Use the variable settings shown in Table 4.

Table 4.  Variable Settings for IBM DB2 UDB zOS and OS/390 Databases

Parameter	Recommended Setting	Notes
IDTHTOIN	1800
CDSSRDEF	Any
STARJOIN	1	This setting indicates that star join is enabled. The one table with the largest cardinality is the fact table. However, if there is more than one table with this cardinality, star join is not enabled.

Bookshelf Home | Contents | Index | Search | PDF