Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    14

    Unanswered: how to create indexes in a new tablespace

    Hi,
    I have few tables and few indexes to be created in DB2 v8.1.2 over linux.

    I have created 2 tablespaces(DMS) TBS1 & TBS2
    I have created the tables in tablespace1 i.e TBS1
    Now how can i create the indexes(both normal,unique) indexes in the other tablespace i.e TBS2.

    The documentation says that when we create DMS tablespaces,we have the option of moving or creating the indexes in another tablespace.

    Can anyone give me examples of creation of normal and unique indexes in a separate tablespace other than the one created for tables.

    Any help is appreciated.

    Sri

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The specification of which tablespace to use for indexes is made in the CREATE TABLE statement (assuming that DMS is used for the tablespace used by the table). Check out the SQL Reference for details.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •