var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how to create indexes in a new tablespace
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.
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.