Your doubt is well confirmed.
There is no ALTER capability to go from SMS to DMS or reverse.
Use db2look to extract ddl of each table and tablespace, Export all table
data, drop tblspc, Edit output of db2look to change the tblspc. definition
and create the new tblspc. and tables, import from ... create into ....
HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"dotyet" <do****@yahoo.com> a écrit dans le message de
news:11**********************@z14g2000cwz.googlegr oups.com...
i doubt that.
your "only" option might be to export the data/tables from the existing
tablespaces, and import/load them in new tablespaces.
regards,
dotyet