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