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
- 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.
- 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.
- 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
|