It's all about the answers!

Ask a question

RRDI with remote DB2 database


Silvia Mesturino (1162429) | asked Jun 03 '13, 10:58 a.m.
retagged Jun 04 '13, 8:07 a.m. by Francesco Chiossi (5.7k11119)
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.

Accepted answer


permanent link
Xuan Jiang (37858) | answered 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

Comments
Silvia Mesturino commented 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 commented 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 commented Jun 04 '13, 7:14 a.m.

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


Xuan Jiang commented 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 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.