It's all about the answers!

Ask a question

Jazz Data Warehouse on Oracle Exadata


Luca Martinucci (1.0k284109) | 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


permanent link
Rafik Jaouani (5.0k16) | 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



permanent link
Vidya Malkarnekar (1.0k15) | 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.