It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×10,908
×6,076
×23

question asked: Jan 14 '14, 3:18 p.m.
question was seen: 4,483 times
last updated: Mar 06 '14, 3:59 a.m.

Related questions

FAQ - How this Forum works

Jazz Data Warehouse on Oracle Exadata

0
Luca Martinucci (1.0k●2●94●112) | asked Jan 14 '14, 3:18 p.m.
edited Jan 14 '14, 3:19 p.m.
We have Oracle installed on an Exadata machine.
We use it as the back-end database for JTS, CCM and QM applications (versions 4.0.5)
The problem arises when we try to configure the Data Warehouse: the setup wizard asks to provide a folder on the db server filesystem to contain the DW table spaces that the wizard will create.
Unluckily, it seems that Exadata has not a real filesystem associated....
Any workarounds?

Accepted answer

3
permanent link
Rafik Jaouani (5.0k●1●6) | answered Jan 14 '14, 4:19 p.m.
JAZZ DEVELOPER

Please read the following doc. You will find instructions on how to generate the data warehouse DDL and Upgrade scripts. Once generated, you can edit the setup scripts and change how the table spaces get created (though you need to use the same names).

After creating the data warehouse manually using the generated scripts, you may still have to specify a folder for the data files. But that folder will not be used.

https://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m5/index.jsp?re=1&topic=/com.ibm.jazz.install.doc/topics/r_repotools_gen_dw_ddlScripts.html&scope=null

https://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m5/index.jsp?re=1&topic=/com.ibm.jazz.install.doc/topics/r_repotools_gen_dw_upgradescripts.html&scope=null

 

Luca Martinucci selected this answer as the correct answer

One other answer

Most liked answers|Newest answers ↑|Oldest answers

2
permanent link
Vidya Malkarnekar (1.0k●1●5) | answered Jan 14 '14, 4:13 p.m.
JAZZ DEVELOPER
Hi Luca, 
I am not much familiar with Oracle Exadata, but if creating Oracle tablespaces in advance is possible, then maybe you should look into the jazz.net article -- https://jazz.net/wiki/bin/view/Main/MoreControlOverTheOracleDataWarehouseSetup. It has a section called 'Modifying the Tablespace creation step".



Comments
Luca Martinucci commented Mar 06 '14, 3:59 a.m.

The instructions provided in the article worked.

We were able to manually create the DWH database and then to run the setup wizard without being compelled to specify a tablespaces folder.

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.