On the same system:
0) Backup the source tablespace
1) run db2llok with the -e option and others (GRANTS, etc.).to extract the DDL of the table(s) and of all objects pertasining to the tables(s). For exampole if they all have the same schema name use -z SCHEMANAME
2) run db2move dbname export and specify tables to be moved by susing proper option. This extracts the data.
2a) You may want to edit the output file to see if everything is there as you will want it.
3) Drop the SMS tablespace
4) Create the required tablespace as DMS with same name as SMS. db2look generates the command to create the tables in the tablespace with the same name.
5) run the output file of db2 look as: db2 -tf filename. The file has a connect to dbname in it. It will create the DDL for all objects.
6) run db2move dbname load to move the data in. The loads are all nonrecvoerable.
7) backup the new tablespace and validate your new data.
Regards, Pierre.

----- Message d'origine -----
De: Tummala Sreenivas <db2udbdba-ezmlmshield-x10716359.[Email address protected]
Date: Mercredi, Juin 27, 2007 7:17 am
Objet: RE: Conversion of SMS table spaces to DMS table spaces.
À: LazyDBA Discussion <[Email address protected]

> Hi Gurus!
>
>
> One of our customers is interested in migrating table spaces
> from SMS to
> DMS. Can you please advise as to how this can be done and what
> is the effort
> required say for 100 tables?
>
>
> Thanks and Regards
> Sreenivas
>
>
>
> -----------------------------------------------------------------
> ----
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>

Pierre Saint-Jacques

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