Data Warehouse tablespaces folder
![]()
Luca Martinucci (1.0k●3●97●112)
| asked Feb 20 '14, 5:42 a.m.
edited Feb 20 '14, 4:40 p.m. by Jennifer Cianchetta-Riordan (251●2)
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
![]()
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
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.