Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring the Siebel Data Warehouse in DB2 for OS/390 >

Installing the Star Schema Tables on DB2 for OS/390

The following procedure installs the star schema tables into the Siebel Data Warehouse for DB2 on OS/390.

NOTE:  There is no automated utility to drop the star schema tables. In the event of a failed installation, have a DBA drop the tables before you reinstall.

To install the star schema tables for DB2 on OS/390

  1. From the Start menu, choose Programs > Siebel Enterprise Server 7.5 > Configure DB Server.
  2. In the Siebel Software Configuration Utility window, click Next to accept the default values for the following pages:
  3. In the RDBMS Platform page, select IBM DB2 UDB for OS/390 and z/OS, and then click Next.
  4. In the Siebel Database Operation page, select Install Database, and then click Next.
  5. In the Select Installation Operation page, click Install Siebel Data Warehouse Database, and then click Next.
  6. In the ODBC Data Source Name page, enter the ODBC Data Source Name for the Siebel Data Warehouse, and then click Next.
  7. In the Database User Name page, enter the Database User Name and Database Password (with double entry confirmation), and then click Next.
  8. In the Siebel Schema Qualifier page, enter the Schema Qualifier for the Siebel Data Warehouse, a Security Group ID (default is SSEROLE), and then click Next.
  9. In the Select Installation Type page, click Standard Install, and then click Next.
  10. In the Select Installation Mechanism page, click either Generate DDL into Files or Run DDL Automatically, and then click Next. You may prefer to generate DDL into files if you wish to examine the DDL information prior to executing it. If you clicked Generate DDL into Files, the installer prompts for a file name.
  11. Accept the default or change the path name. You can use the Browse feature to specify a fully qualified path name. Make sure to run the DDL before proceeding to the next step.
  12. In the Siebel Schema Layout page, click an option button, and then click Next.
  13. In the Storage Group for Table Spaces page, enter Storage group for Table spaces (default is SYSDFLT) and Storage group for Indexes (default is SYSDFLT), and then click Next.
  14. In the 4 KB Buffer Pool Name page, enter the names of the 4 KB Buffer pool (default is BP1) and the 16 KB Buffer pool (default is BP16K1) for the Siebel Data Warehouse, and then click Next.
  15. In the 32 KB Buffer Pool Name page, enter the names of the 32 KB Buffer pool (default is BP32K1) and the Index Buffer pool (default is BP2) for the Siebel Data Warehouse, and then click Next.
  16. In the Database Name Prefix page, enter the Database Name Prefix, and then click Next.
  17. In the Encoding Scheme page, click ASCII or EBCDIC, and then click Next. If you are not sure which to choose, then choose ASCII.
  18. In the Configuration Parameter Review page, review the entries. If any are incorrect, then click Previous and repair the problem. If all entries look correct, click Finish.
  19. In the runnow window, click OK.

    20. The Siebel Upgrade Wizard window opens. A command line window opens. The installer creates the Storage.ctl file and then executes the install using the parameters you specified. When complete, the command line window closes.

  20. In the Siebel Upgrade window, when the word Complete appears in the window's title bar, click OK.


 Siebel Data Warehouse Installation and Administration Guide, Version 7.5, Rev. C 
 Published: 18 April 2003