When we run a column analysis job by default the table and indexes are created in DB2 IADB database and IADBSPACE tablespace. Is there a configuration in Information Analyzer that enables us to specify the tablespace where the table and index should be created? We would like to create indexes and tables in separate tablespaces.
This topic has been locked.
2 replies Latest Post - 2012-07-03T16:59:12Z by iadev
Pinned topic Tablespaces for Tables and Indexes in IADB
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-07-03T16:59:12Z at 2012-07-03T16:59:12Z by iadev
RobertDickson 0600009JMM65 PostsACCEPTED ANSWER
Re: Tablespaces for Tables and Indexes in IADB2012-07-03T14:01:07Z in response to iadevHi,
I do not believe that level of control is available via the GUI. I suggest that you open a PMR to see if there is some non-documented (but supported) way to do what you desire.