Hi
To rename the database you can use any of the following options

1) Use db2relocatedb and specifiy the new name in config file. You have to retart the instance once this is done.
2) Use restore database using INTO clause. and provide the new name.

You can restore specific tablespaces if archive logging (logretain) is enabled.
Regards
Sakkariya Nalakath




________________________________

From: Tripathy Saroj Kumar [mailto:db2udbdba-ezmlmshield-x66321820.[Email address protected]
Sent: Thu 12/29/2005 4:42 PM
To: LazyDBA Discussion
Subject: Help needed..



Hi,

I am a new bee to Db2; I want to rename the database and then want to do
the restore operation on it. For restoring the database, I want to
select only "SYSCATSPACE" of Tablespaces and full Archived Logs. Is it
possible to take the restore?



Thanks in advance.
Saroj


This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




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