Warehouse Manager Installation Guide

Enabling warehouse transformers

To enable warehouse transformers for use by the warehouse target:

  1. Start the Data Warehouse Center:
    1. Start the Control Center by clicking Start --> Programs --> IBM DB2 --> Control Center.
    2. Click the Data Warehouse Center icon in the Control Center toolbar.
  2. In the tree view on the left, locate the warehouse target for which you want to enable warehouse transformers, and open the Properties notebook.
  3. On the Database page, in the Target database area, click either Create transformers and register as fenced or Create transformers and register as unfenced. See the online help or the SQL Reference for more information about fenced and unfenced stored procedures.
  4. In the Warehouse target area, click Enable target for transformers.
  5. Click OK.
  6. Close the notebook.

A single database can contain several warehouse targets; however, you must enable the warehouse transformers for each warehouse target. If you have multiple warehouse targets in a single database and you change these settings for one warehouse target, the other warehouse targets in that database will be affected.

For example, if you drop the warehouse transformers after enabling them for several warehouse targets, a message is displayed, indicating that this change will affect other warehouse targets defined to the database. The names of the other warehouse targets will be listed in the message. You can choose to cancel the drop procedure or to continue. If you continue, any processes or steps in those warehouse targets that use warehouse transformers will not run, unless you recreate the warehouse transformers.

If you change the warehouse transformers from fenced to unfenced, or from unfenced to fenced, and there are multiple warehouse targets defined to the database, a message is displayed, indicating that this change will affect other warehouse targets defined to the database. The names of the other warehouse targets will be listed in the message. You can choose to cancel the change or to continue. If you continue, the transformers will be dropped, then recreated as specified.

[ Top of Page | Previous Page | Next Page ]