The actual command is
DB2 BACKUP DATABASE DBNAME TO F
You could use the following script I've created to run a backup from
database1 to database2 if you wanted to change the name of the Database.
This utility was created to clear databases as if to recreate a template.
**************** You could just run this without any Parameters and it
will tell you how to use it
@ECHO OFF
if .%1==. goto ABORT
if .%2==. goto ABORT
if .%3==. goto ABORT
if .%4==. goto ABORT
@ECHO ON
db2 restore database %1 from %2 to %4 into %3 without rolling forward
rem pause
db2 backup database %3 to %2
GOTO OUT
:ABORT
ECHO USAGE: resback [Src Database] [Src Drive Letter] [Des Database] [Des
Drive Letter]
ECHO ie: resback VASDB01 F VASDB02 D
:OUT
Please note the destination database must be created before this will
work.
Dave Valdez
Sr. Systems Integrator/Support Engineer
Glory USA Inc.
[Email address protected]
"deepak" <db2udbdba-ezmlmshield-x1331572.[Email address protected]
12/24/2004 01:34 AM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
RE: db2move
I would prefer a db2 backup on machine A and then do a db2 restore on
server B
Rgds
Deepak
-----Original Message-----
From: Bala Sosale
[mailto:db2udbdba-ezmlmshield-x8130796.[Email address protected]
Sent: Thu 12/23/2004 9:05 PM
To: LazyDBA Discussion
Cc:
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
DISCLAIMER:
This message contains privileged and confidential information and is
intended only for the individual named.If you are not the intended
recipient you should not disseminate,distribute,store,print, copy or
deliver this message.Please notify the sender immediately by e-mail if you
have received this e-mail by mistake and delete this e-mail from your
system.E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted,corrupted,lost,destroyed,arrive late
or incomplete or contain viruses.The sender therefore does not accept
liability for any errors or omissions in the contents of this message
which arise as a result of e-mail transmission. If verification is
required please request a hard-copy version.
---------------------------------------------------------------------
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