RRDI with remote DB2 database
Silvia Mesturino (116●24●29)
| asked Jun 03 '13, 10:58 a.m.
retagged Jun 04 '13, 8:07 a.m. by Francesco Chiossi (5.7k●1●11●19)
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
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).
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
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.