Reverting back the Fixpack
Gladiator
Is there a way we can revert back the fixpack which we applied. Say i
have installed Fixpack3 and if i wanted to revert back to Fixpack 2
again , how do i do it ? I haven't faced such situations but i am just
curious to know about it.
Thanks,
Kamal.
Ian
You don't say what platform you're using, or what version of DB2. With
DB2 9.5, you can install multiple code levels on a single box, so you
could have both 9.5 FP1 and 9.5 FP3. To switch between the fixpacks,
use the appropriate db2iupdt command. (for example:)
Say FP1 is installed in /opt/ibm/db2/V9.5.
You would install FP3 into /opt/ibm/db2/V9.5_FP3.
Then, run /opt/ibm/db2/V9.5_FP3/instance/db2iupdt to update the
instance to FP3.
To go back to FP1, use /opt/ibm/db2/V9.5/instance/db2iupdt.
If you didn't install the new Fixpack into a different path (i.e.
you just installed over the existing FP1 code), you would
have to install the FP1 code into a different path.
Darin McBride
> Gladiator wrote:
>> Hi ,
>>
>> Is there a way we can revert back the fixpack which we applied. Say i
>> have installed Fixpack3 and if i wanted to revert back to Fixpack 2
>> again , how do i do it ? I haven't faced such situations but i am just
>> curious to know about it.
>
> You don't say what platform you're using, or what version of DB2. With
> DB2 9.5, you can install multiple code levels on a single box, so you
In case the OP has v9.1, this actually started in 9.1.
> could have both 9.5 FP1 and 9.5 FP3. To switch between the fixpacks,
> use the appropriate db2iupdt command. (for example:)
>
> Say FP1 is installed in /opt/ibm/db2/V9.5.
I usually install to /opt/ibm/db2/V9.5/GA, just for this purpose. ;-) Then
FP3 goes in /opt/ibm/db2/V9.5/FP3. Conversely, if you want to have
"private" DB2s for each function, you may have /opt/finance/db2/V9.5/GA and
/opt/hr/db2/V9.5/FP2 or whatever.
> You would install FP3 into /opt/ibm/db2/V9.5_FP3.
By not using /opt/ibm/db2/V9.5 directly, but installing to a subdirectory, I
partition things differently. Up to the sysadmin to decide which one suits
them. They're about the same when you only have a couple fix packs
installed, but can be quite different if you start getting 5+ fix packs
installed at different versions. I've heard people ask why they'd ever have
so many different copies, and my answer is simple: once you go down this road
of multiple copies, it's very easy to end up with different copies for
testing, backup/backout, and more testing. There are users who do not ever
delete copies of DB2 until they completely get rid of a particular version,
partly for ISO compliance, and partly for being able to switch fix levels
quickly (db2stop/db2iupdt/db2start - on a non-clustered machine, this could
be as little as 30 seconds of downtime). And it allows them to improve
their confidence of upgrading, downgrading, and everything in between because
nothing is set in stone until they decide it is.
> Then, run /opt/ibm/db2/V9.5_FP3/instance/db2iupdt to update the
> instance to FP3.
>
> To go back to FP1, use /opt/ibm/db2/V9.5/instance/db2iupdt.
>
>
> If you didn't install the new Fixpack into a different path (i.e.
> you just installed over the existing FP1 code), you would
> have to install the FP1 code into a different path.
You can also install FP1 over top of FP3, at least on AIX, Sun, HP, and
Linux. This, too, is new in v9.1.
Gladiator
freecycle
> Thanks a lot Ian and Darin for the clarification. !!!
Could someone tell me how to revert from v8 fp17 to fp12 please?
|P
Darin McBride
That will depend very much on the platform. Backing out of a fix pack should
be covered in the online docs in detail simply because it's so variant. In
version 8, DB2 used the OS vendors' installers (installp on AIX, pkgadd on
Sun, swinstall on HP, RPM on Linux, Windows Installer on Windows), and each
of these have different capabilities as far as backing out is concerned, and
the instructions are thus also very specific to platform.
In v9, DB2 dropped the OS installers on Unix/Linux, which now means that DB2
has the same capabilities/limitations on all of these platforms... both good
and bad :-)
krx
Also, starting in V9.5 you can revert to a previous fixpack just by
installing that fixpack on top of the current higher leveled fixpack
with the "-f level" option.
For example, if you are on V9.5 FP3 and want to go back to V9.5 FP1
then just go to the FP1 installation directory and execute:
installFixPack -f level -b /opt/IBM/db2/V9.5
Darin McBride
You can do that in 9.1, too, but it's just "-f". (9.5 added more
granularity on its force options)