Why need to restore , after migration ???? for FP 6 to 10 ?????



Lekharaju Ennam


-----Original Message-----
From: Serge Rielau
[mailto:db2udbdba-ezmlmshield-x31590248.[Email address protected]
Sent: Wednesday, August 31, 2005 10:36 AM
To: LazyDBA Discussion
Subject: Re: db2 migration

I would choose option (1).
Also I wouldn't worry about applying FP10 on the source unless you find a
backup APAR in the list of APARs fixed.
Remember to run db2updv8 after the restore is done to pick up new routines
and catalog changes.
Also if you use SQL Procedures I recommend dropping and recreating them all
since DB2 V8.2 (FP7) eliminated the C-Compiler.
If there are problems you want to know about them now and not puzzle in 6
months when the app developer decides to refresh the procs.

Cheers
Serge


"Maxim Ness " <db2udbdba-ezmlmshield-x12888802.[Email address protected]
wrote on 08/31/2005 09:58:16 AM:

> Hello DBA's,
>
> Currently we have DB2 8.1 fixpack 6a running of Windows 2000 server. The
> goal is to transfer the configuration and data to the new windows 2003
> server with DB2 8.1 fixpack 10.
>
> Is there any known issues with fixpack 10 ?
>
> What is the best way to migrate the server ? As far as i can see i have 3

> options:
>
> 1. ( Upgrade source DB2 server to fixpack 10 ? ) , do a backup of data,
> install DB2 8.1 with fixpack 10 to the destination server and do
> redirected restore.
> 2. Install DB2 8.1 with fixpack 10 to the destination server and do
> redirected restore and move data with db2look/export-load commands. Can i

> use db2move ? RTFM says that it is to be used only on workstation.
> 3. Pay to IBM to do the work :)
>
> Thanks in advance.
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>



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