faster is I zhink the redirected restore or u can use the db2relocatedb :
"Peter Sands" <peter_sandstechemail.com> schrieb im Newsbeitrag
news:6b009995.0307151028.2f6d35posting.google.com ...> Hi,
> I currently have a db (uw_db) using 30 DMS devices running on a
> server. I want to create a copy of this db to ( uw_db_dev) on the same
> server and instance.
> I extract (db2look) all the devices from the db uw_db , do a slight
> name change to each device iwth in the output file and re-create them
> taking the file as imput. Then do a restore db into newdb. WOuld I
> have problems with the SMS for the temp user spaces ? if I did this
> Or would it be better to do a restore with redirect ?
> Do to the amount of DMS devices I would rather automate as much as
> Which option is best ?