How can we convert SMS tablespace to DMS Tablespace (Automatic Storage)

[deshaipet]

Hi Friends,

Is it possible to convert SMS tablespace to a DMS tablespace with Automatic Storage ? Please, let me know the chances.

Thanks
Pandith

[Shashank1984]

The only way to accomplish what you are doing is to unload the tables, drop the tables, drop the tablespaces, recreate the tablespaces, recreate the tables and import data. You will not be able to convert from SMS to DMS with redirected restore.

Thanks,
Shashank Kharche, IBM.
DB2 for Linux, Unix & Windows -Information Management Software

[deshaipet]

Thanks a lot Shashank

You answer is really helpful to me..



Thanks
Pandith

[Shashank1984]

No worries mate, cheers !!!

Shashank Kharche, IBM.
DB2 for Linux, Unix & Windows -Information Management Software