You could BACKUP A and do a REDIRECTED RESTORE to B. It takes a little time
to set up the REDIRECTED RESTORE job if you have many tablespaces, but is
very easy to do.

Tom

-----Original Message-----
From: Bala Sosale
[mailto:db2udbdba-ezmlmshield-x8130796.[Email address protected]
Sent: Thursday, December 23, 2004 10:36 AM
To: LazyDBA Discussion
Subject: Re: db2move


Dear List,

Happy Holidays and Merry x-mas.

what is the best way to move a db2 db from server A(DB2 8.1) to server
B(DB2 8.1)?
Do I need to create the same db2 db on server B before running the move
commands on B?

what are the commands?

Thanks for all your help this year
Bala


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

*************************************************************
This message, including any attachments, may contain
confidential information intended for a specific individual
and purpose, and may be protected by law. If you are not
the intended recipient, please notify the sender by e-mail
or telephone immediately, and then immediately delete this
message. Any disclosure, copying or distribution of this
message, or the taking of any action based on it, by any
unintended recipient is strictly prohibited.

Checked by the Safelite e-mail scanner which may have
resulted in the attachments being modified or removed.

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