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.