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

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.