Bookshelf Home | Contents | Index | PDF     

Oracle® Business Intelligence Applications Installation and Configuration Guide > Preinstallation and Predeployment Considerations for Oracle BI Applications >

IBM DB2 UDB zOS and OS/390 and Z/os-Specific Database Guidelines for Oracle Business Analytics Warehouse

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

  • The 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 Oracle Business Intelligence.
      • 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 6.
Table 6. 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.
  
Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.