Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RRDI with remote DB2 database

Questions
Tags
Users
Badges
Silvia Mesturino
(116●24●29) retagged
Jun 04 '13, 8:07 a.m.
Can anybody point me to a consistent documentation of the configuration of the remote database ? After configuring manually the RICM database, I find that I need to run scripts to create the RIDW, but the description on the https://jazz.net/help-dev/clm/index.jsp?re=1&topic=/com.ibm.rational.rrdi.admin.doc/topics/t_deploying_vega.html  and https://jazz.net/wiki/bin/view/Main/MoreControlOverTheDB2DataWarehouseSetup are not sufficient.

0 votes

1 answer
4,366 views
0 votes

Accepted answer

Permanent link
Xuan Jiang
(378●5●8) Jun 03 '13, 5:23 p.m.
You need run script on the DB server to create data warehouse, see this page:
https://jazz.net/help-dev/clm/topic/com.ibm.rational.rrdi.admin.doc/topics/c_postinstall_manual_db_DB2_scripts.html
Silvia Mesturino selected this answer as the correct answer

2 votes

Comments
Silvia Mesturino
Jun 04 '13, 2:30 a.m.

Hi Xuan Jing, I have been studying this page for hours, and I cannot locate where the script are located. When I get to panel Configure Data Warehouse and I enter the values for the Remote database I get an error, because the RIDW database has not been created yet (I created manually the RICM database).
Or do I have to act like if I was going to create a local database ?

Silvia Mesturino
Jun 04 '13, 4:23 a.m.

Hi Huan Jing, I now executed the commands you sent me and created the RIDW database, I tried again to run step Configure Database and now I get the following error message: CRRRA0079E: The root directory cannot be used as the table space location. I did not define any table space so far for RIDW ! What shoudl I do ? In case of  RICM I had created tablespaces and the location was C: (as now).

Silvia Mesturino
Jun 04 '13, 7:14 a.m.

I am sorry, Xuan Jiang, I wrote your name wrong 2 times, please excuse me

Xuan Jiang
Jun 04 '13, 7:17 a.m.

Assuming you are using a Windows OS as your DB server, since RRDI is not allowed using a root folder for tablespace, so please create a folder first (or select an existing one but please make sure no files under it), for example, C:\RIDWTS, then input it in your setup UI as "Table Space Location".

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 403
× 84

Question asked: Jun 03 '13, 10:58 a.m.

Question was seen: 4,366 times

Last updated: Jun 04 '13, 8:07 a.m.

Confirmation Cancel Confirm