Oracle^® Business Intelligence Applications Installation and Configuration Guide > Installing and Configuring Oracle BI Applications on Windows > Updating Siebel Transactional Database Schema Definitions >

Process of Applying CRM Schema Changes For DB2 on 390 or z/os

How to apply CRM schema changes for DB2 on 390 or z/os

1. Edit the following parameters in the Storage control files located in \OracleBI\dwrep\Storeage_DDL_OLTP.CTL:
   • %1 - Replace with a 2 character database name.
   • %indBufPool - Replace it with a index buffer pool name.
   • %4kBulfPool - Replace it with a 4k TBS buffer pool name.
   • %32kBufPool - Replace it with a 32K TBS Buffer Pool name.
2. On the machine where Oracle BI Applications is installed, run the following command:

   ..\OracleBI\dwrep\bin\DDLIMP /U <USER> /P <PASSWORD> /C <ODBC_CSN> >>> /G SSE_ROLE /F \OracleBI\dwrep\DDL_OLTP_DB2390.CTL> /L <..\oracleBI\dwrep\DDL_OLTP.log> /5 Y /A <SCHEMA_OWNER> /Y ..\OracleBI\dwrep\Storeage_DDL_OLTP.CTL

   Notes:

   • /P <PASSWORD> - The password for Oracle's CRM OLTP.
   • /C <ODBC connect string> - The name of the ODBC connect string.
   • For Oracle databases, use the Oracle Merant ODBC Drivers.
   • In addition, you can use the following commands:

     /W Y - (if the OLTP database is Unicode).

     /Z Y - (if the OLTP database is DB2 and Unicode or the OLTP database is MS SQL Server and Unicode).

     /B <TABLE_SPACE_NAME> - If you want to create these table in a separate table space.

     /X <INDEX_TABLE_SPACE_NAME> - If you want to create the indexes in a separate table. space.

     /Y - Storage File for DB2/390.

3. To create indices for the tables created in step 3, Run the following SQL Script from the DB2 command line utility connected to your OLTP Schema:

   ..\OracleBI\Dwrep\Create_OLTP_Db2390_index.sql