Steps to migrate a DB from ServerA to ServerB (Independent of the types of
the OS)

db2move - Used for moving User tables (DATA)
db2look - Creates DDL to create the database objects in the new environment.
In some other cases we may have to db2cfexp and db2cfimp also.

On serverA

Use db2move to export all table data to PC/IXF files
Use db2look to generate DDL for all the database objects.

Transfer PC/IXF files & Configuration profile in Binary Mode.
Transfer db2look.sql & db2move.lst in ASCII Mode.

On serverB

Make sure the version of DB2 is same with the appropriate Fixpack.
Create an instance with the same name as it was in serverA. (optional)
Create all the databases that you are moving.
Set current schema name.
Create required Buffer pools and Table Spaces for the DB.
Run the script generated by db2look
(set integrity off if you have referential constraints)
Run db2move in load mode. (Takes a while for large DB's)
Update DB CFG to reflect the source DB.
Do a Full DB/Table space Backup to take the table space out of backup
pending state and check for the integrity of the Backup.
Detect the tables that are in check pending state and bring it to normal
state. (set integrity)
Check other db objects to make sure they are in Normal State.
All the configuration parameters need to be tuned according to the current
hardware.

----- Original Message -----
From: "Fittante Tom "
<db2udbdba-ezmlmshield-x28805604.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, December 23, 2004 10:45 AM
Subject: RE: db2move


> 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.
>
>
> ---------------------------------------------------------------------
> 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