Data Warehouse tablespaces folder
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
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