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  and 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:
Silvia Mesturino selected this answer as the correct answer

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.