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.

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