it is not possible !
Tables & indexes must be in the same TBS

Mathieu

-----Message d'origine-----
De : Prabhakar Baru Krishnan
[mailto:db2udbdba-ezmlmshield-x18789474.[Email address protected]
Envoyé : lundi 31 janvier 2005 07:29
À : LazyDBA Discussion
Objet : Can we separate tables and indexes in SMS ?


db2 create table address ( oid bigint not null, address1 varchar(255),
address2 varchar(255) ) in USER32KTS index in USERSPACE1

DB21034E The command was processed as an SQL statement because it was not
a
valid Command Line Processor command. During SQL processing it returned:
SQL0285N The indexes and/or long columns for table
"ADMINISTRATOR.ADDRESS"
cannot be assigned to separate table spaces because the primary table
space
"USER32KTS" is a system managed table space. SQLSTATE=42839
My question is:
Can we separate tables and indexes with system managed tablespace ?

Thanks & Regards,
Prabhakar.


---------------------------------------------------------------------
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