E Using the DDLimp Utility

This appendix contains instructions for using the DDLimp utility. It contains the following topic:

• Section E.1, "Using the DDLimp Utility to Run CTL Files"

E.1 Using the DDLimp Utility to Run CTL Files

Follow this procedure to use the DDLimp utility to run CTL files.

To use the DDLimp utility

1. Navigate to the folder OracleBI\dwrep\Upgrade\CTLFiles, and locate the specified CTL file.

2. If you changed any of the preconfigured column definitions in the CTL file for your implementation, you need to edit the CTL file to reflect the change. For example, if you renamed or resized an existing column in W_DAY_D, you need to make the same change in the CTL file. If you do not make the change in the CTL file, when the CTL file is run, the column definition will revert to the preconfigured definition. (As a customization, if a column size was changed from VARCHAR(50) to VARCHAR(100), and the same change was not made in the CTL file before running, the column will revert to the preconfigured value of VARCHAR(50), which could cause data to be truncated in some databases.)

3. For non-Teradata databases, use the DDLimp utility to run the <file_name>.ctl script. Use the following command:

   ..\OracleBI\dwrep\bin\DDLIMP /U <USER> /P <PASSWORD> /C <ODBC connect string>
   /G SSE_ROLE /I N /R Y /F <..\OracleBI\dwrep\Upgrade\CTLFiles\<FILE_NAME>.CTL>
   /L <..\oracleBI\dwrep\<FILE_NAME>.log>
   

   For example:

   DDLIMP /U SADMIN /P SADMIN /C OBIA /G SSE_ROLE
   /I N /R Y /F C:\OracleBI\dwrep\Upgrade\CTLFiles\UPGRADE_7962.CTL /L C:\OracleBI\dwrep\UPGRADE.log
   

4. For Teradata databases, use the DDLimp utility to run the <file_name>.ctl script. Use the following command:

   ..\OracleBI\dwrep\bin\DDLIMP /U <USER> /P <PASSWORD> /C <ODBC connect string>
   /G SSE_ROLE /F <..\OracleBI\dwrep\Upgrade\CTLFiles\<FILE_NAME>.CTL>
   /s N /L <..\oracleBI\dwrep\<FILE_NAME>.log>
   

   For example:

   DDLIMP /U SADMIN /P SADMIN /C OBIA /G SSE_ROLE
   /F C:\OracleBI\dwrep\Upgrade\CTLFiles\UPGRADE_7962.CTL /s N /L C:\OracleBI\dwrep\UPGRADE.log
   

E.2 Additional DDLimp Commands

The following DDLimp commands are also available:

• /P <PASSWORD> - The password for the data warehouse.

• For Oracle databases, use the Data Direct drivers.

• /C <ODBC connect string> - The name of the ODBC connect string.

• /I N - Tells DDLimp to ignore the indexes DDL defined in the CTL file if any exist. It does not change existing indexes. (The default is /I Y, which tells DDLimp to create and merge indexes from the CTL file with the indexes in the database.

• In addition, you can use the following commands:

• /W Y - If the OLAP database is Oracle and Unicode.

• /Z Y - If the OLAP database is DB2 or SQL Server and Unicode.

• /B <TABLE_SPACE_NAME> - If you want to create these tables in a separate table space. For DB2, This must be specified as 32K tablespace.

• /X <INDEX_TABLE_SPACE_NAME> - If you want to create the indexes in a separate tablespace. For DB2, This must be specified as 32K tablespace.

• /Y - Storage File for DB2/390.

• /R - Regrant tables.