Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / July 2006

Tip: Looking for answers? Try searching our database.

Migration / DEmigration

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Anurag - 24 Jul 2006 10:02 GMT
Hi Folks!
Two part question, PLEASE DO NOT IGNORE THE FIRST PART

ENVIRONMENT = DB2 ESE non-DPF 8.1 FP5 on AIX 5.x
==========
QUESTION 1
==========
I upgrade from FP5 to FP11, migrate instances, databases, rebind and
all that stuff.
Now, I want to go back to FP5. So, I reject the FP11 update using SMIT
(it works).

Questions:
(A) Can I just DEmigrate DB2 instance using db2iupdt?
(B) Can I just DEmigrate FP11 database using "migrate database"?
(C) Are there no catalog changes between FP5 and FP11 that will prevent
this?
(D) Would I not encounter problems with package binding when I
DEmigrate?

==========
QUESTION 2
==========
Any other easy way of doing this DEmigration?

Please bear in mind that although I plan to do this on dev system, I do
not have leeway on time / resources - ANY GOOF UP AND I MAY BE A "DEAD
MAN WALKING"!!

-- Anurag [in his hour of need]
Serge Rielau - 24 Jul 2006 13:36 GMT
Anurag,

There is no database migration from DB2 V8.1 to DB2 V8.2.
So all you to is flip your instance (the database doesn't care).
Now, once you have rebound you packages, if you want to go back you have
to rebind them again against the old system, not that DB2 picked up some
FP7 or FP9 smartness.
If you start using any of the new function you are committed of course.
If you drop and recreate SQL Procedures going from V8.1 to V8.2 you need
to redo that on the way back since the SQL Procedure architecture
changed (rebind is NOT good enough to pick up DB2 V8.2 SQL Procs btw. If
you want to benefit from V8.2 you need to drop/recreate)
Now the one thing I don't know is whether you can undo a call to
db2updv8 which updates your catalogs, but I suppose you should be able
to wait calling it until you're comfortable on FP11.
Depending on your level of paranoia you can do it one step at a time:
Upgrade the instance => test (downgrade up flipping the insance back)
Rebind => test (downgrade by flipping the instance and rebinding)
DROP/CREATE SQL procs => test (etc, etc...)
db2updv8 => test (dunno this one)

Cheers
Serge
Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.