Topic
2 replies Latest Post - ‏2012-07-03T16:59:12Z by iadev
iadev
iadev
5 Posts
ACCEPTED ANSWER

Pinned topic Tablespaces for Tables and Indexes in IADB

‏2012-07-03T12:37:40Z |
Hello

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.

Thanks
Updated on 2012-07-03T16:59:12Z at 2012-07-03T16:59:12Z by iadev
  • RobertDickson
    RobertDickson
    43 Posts
    ACCEPTED ANSWER

    Re: Tablespaces for Tables and Indexes in IADB

    ‏2012-07-03T14:01:07Z  in response to iadev
    Hi,

    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.

    Regards,
    Robert
    • iadev
      iadev
      5 Posts
      ACCEPTED ANSWER

      Re: Tablespaces for Tables and Indexes in IADB

      ‏2012-07-03T16:59:12Z  in response to RobertDickson
      Hello Robert

      Thanks for your quick response.