Switch Tablespace Type During directed restore

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

spshealy@yahoo.com - 16 Mar 2005 20:55 GMT

If you have tablespaces that were SMS tablespaces and you redirect the
containers during a restore can you make them DMS constainers?

Thank,
Scott Shealy

Reply to this Message

dotyet - 16 Mar 2005 21:03 GMT

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

Reply to this Message

Pierre Saint-Jacques - 16 Mar 2005 23:59 GMT

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.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

> i doubt that.
>
[quoted text clipped - 3 lines]
> regards,
> dotyet

Reply to this Message