Reference: Parameters for migrating the DB2 databases for the data warehouse

Use these parameters to migrate the DB2® databases for the data warehouse for reporting with IBM® Rational® Insight.

Parameters for the data warehouse

Prompt Explanation
Enter DB2 Instance to use on local host name The name of the Rational Insight DB2 instance.
Enter name of the Insight database The name of the Rational Insight database.

In the samples, the supplied database name is RIDW.

Enter username to use to connect to the database The user name of the database administrator; for example,Windows db2admin or Linux db2inst1.
Enter password for this user The password for the database administrator account.
Enter schema under which the operational data store is built The name of the Rational Insight schema for the operational data store.

In the samples, the supplied schema name is RIODS.

Enter schema under which the star schema is built The name of the Rational Insight schema for the star schema. The name can contain up to 8 letters.

In the samples, the supplied schema name is RIDW.

Enter user name that is used to run reports The Rational Insight database user who connects to the database for running and viewing reports.

In the samples, the supplied user name is rptuser.

Do you want to accept the new view definitions [1=Yes 0=No] Specify if you are willing to accept the redefinition of a view that already exists. If you accept the definitions, the view is dropped and recreated.

Feedback