RIDW tables in wrong DB for RDDI setup

Hello.
If you have created the DW database, but it is currently empty then you
can still use it. Just walk through the jts/setup steps one more time
specifying the right database for the Data Warehouse steps this time. If
not then just create a new empty database as described in the online help.

If you want to clean-up the CCM database you should compare the two
databases after the DW database was properly initialized by the
jts/setup and drop all the tables in the schemas that you see used by
the DW such as RIDW, RIODS, CONFIG, etc. You can also just leave them
there as they will take up much space and risk of accidentally loosing
your CCM data does not justify the clean-up.

Hope this helps,
Peter.


On 9/12/2011 9:53 AM, miwalker wrote:

I went through the RDDI setup and think I either missed or did a step
incorrectly. After I completed the setup I brought up query studio
and when I run anything I get a rc=16 saying it can't find table
RIDW.*.

I setup a database called DW and specified it in the configuration.
When I look in my DB2 I see that those RIDW.* tables are actually
under the CCM database.

I'm assuming during one of the setup steps that I mistakenly specified
CCM as the db instead of DW. What's the best way to fix this? Should
I drop and recreate the DW database? What step creates the tables in
the db? I found the step that creates the db but can't find where the
tables get created.

Thanks Peter. That worked for me and the error is gone.

Your video on setting up RRDI was very useful. Any chance you'll be doing one on creating new reports once you have it installed? :)

Hello.
If you have created the DW database, but it is currently empty then you
can still use it. Just walk through the jts/setup steps one more time
specifying the right database for the Data Warehouse steps this time. If
not then just create a new empty database as described in the online help.

If you want to clean-up the CCM database you should compare the two
databases after the DW database was properly initialized by the
jts/setup and drop all the tables in the schemas that you see used by
the DW such as RIDW, RIODS, CONFIG, etc. You can also just leave them
there as they will take up much space and risk of accidentally loosing
your CCM data does not justify the clean-up.

Hope this helps,
Peter.


On 9/12/2011 9:53 AM, miwalker wrote:

I went through the RDDI setup and think I either missed or did a step
incorrectly. After I completed the setup I brought up query studio
and when I run anything I get a rc=16 saying it can't find table
RIDW.*.

I setup a database called DW and specified it in the configuration.
When I look in my DB2 I see that those RIDW.* tables are actually
under the CCM database.

I'm assuming during one of the setup steps that I mistakenly specified
CCM as the db instead of DW. What's the best way to fix this? Should
I drop and recreate the DW database? What step creates the tables in
the db? I found the step that creates the db but can't find where the
tables get created.

Hello.
We posted these two, which a colleague of mine created:

https://jazz.net/forums/viewtopic.php?t=18866

Peter.