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/