It's all about the answers!

Ask a question

Data Warehouse tablespaces folder


Luca Martinucci (942277105) | asked Feb 20 '14, 5:42 a.m.
edited Feb 20 '14, 4:40 p.m. by Jennifer Cianchetta-Riordan (2512)
What is the exact purpose of the Data Warehouse tablespaces folder that must be specified when you run the setup wizard?
According to the infocenter, the setup wizard creates the DW database tablespaces in that folder.
I wonder whether this folder is temporary or permanent for DW purposes.
After the setup wizard has successfully completed, can we remove the folder?
Many DBAs do not like to let an application write on the DB server filesystem, so they ask us to verify this point.

Accepted answer


permanent link
Francesco Chiossi (5.7k1719) | answered Feb 20 '14, 8:51 a.m.
Hello Luca,

the Data Warehouse tablespaces must be an existing folder in the database machine.
It will contain the physical files for the data warehouse tablespaces, so it cannot be deleted afterwards.

You can find the details on the tablespaces, by DBMS on the following topics (it's in a section you need to expand like Oracle table spaces details...):

DB2 data warehouse setup scripts
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m5/index.jsp?re=1&topic=/com.ibm.rational.rrdi.admin.doc/topics/c_postinstall_manual_db_DB2_scripts.html&scope=null

Oracle data warehouse setup scripts
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m5/index.jsp?re=1&topic=/com.ibm.rational.rrdi.admin.doc/topics/c_postinstall_manual_db_oracle_scripts.html&scope=null

SQL Server data warehouse setup scripts

http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m5/index.jsp?re=1&topic=/com.ibm.rational.rrdi.admin.doc/topics/c_postinstall_manual_db_sql_scripts.html&scope=null
 
Best Regards,

Francesco Chiossi
Luca Martinucci selected this answer as the correct answer

Your answer


Register or to post your answer.