Running the database preparation scripts

Copy the database preparation scripts from the BIL assets and run them.

About this task

To run the database preparation scripts:

Procedure

  1. Navigate to the SCRIPTS/DataBase directory in your BIL assets.
  2. Copy the scripts specific to your database type: DB2® or Oracle.
  3. Modify each script to provide information that is unique to your implementation, such as schema names.
  4. Run each Alter and Drop script.
    Note: Each script is independent from the others, so the order in which they are run is not important. It is, however, important that each script is run.

What to do next

If your implementation requires history to be stored, you will have to recreate the history triggers after finishing the BIL data load. To complete this task, use the Create Triggers script provided with InfoSphere® MDM.