You don't say but I hope that you are not using DB2 UDB for LUW.
In that environment, once indexe tablespaces have been identified by the
CREATE TABLE command, they cannot be moved.
The only way I know of is to use a combination of db2look to extract and
change the ddl and then to use db2move to offload and reload the data.
Hope this helps, Pierre.

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
----- Original Message -----
From: "s" <db2udbdba-ezmlmshield-x65954409.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, July 24, 2006 2:03 AM
Subject: Index Tablespaces


>I am planning to move my indexes of large and frequently table to a
> seperate tablespace. What I wonder is if I should use the same tablespace
> for all of those large tables' indexes.Or define table spaces seperately?
>
> Which one is better?
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>



DB2 & UDB email list listserv db2-l LazyDBA home page