DB2

Execute a script similar to the following as the system DBA. Be sure to create the idm_warehouse database and the idm_warehouse/idm_warehouse user before running the script.

CONNECT TO idm_warehouse USER idm_warehouse using ’idm_warehouse’
CREATE SCHEMA idm_warehouse AUTHORIZATION idm_warehouse
GRANT CONNECT ON DATABASE TO USER idm_warehouse

To load the DDL, add the following line to the %WSHOME%\exporter\create_warehouse.db2 file:

CONNECT TO idm_warehouse USER idm_warehouse using ’idm_warehouse’

Then run the following command (assuming a Windows DB2 server):

db2cmd db2setcp.bat db2 -f create_warehouse.db2