db2updv8 necessary for FP14 -> FP15?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aj - 30 Aug 2007 18:03 GMT

DB2 LUW 8.2 FP15

When going from FP14 to FP15, is it necessary to
issue the db2updv8 command for each database?

Is this only intended to be used when moving from
8.1 to 8.2 (ie FP7), or is it now a standard part
of any fixpak install?

TIA

aj

Reply to this Message

Dave Hughes - 30 Aug 2007 20:08 GMT

> DB2 LUW 8.2 FP15
>
[quoted text clipped - 3 lines]
> Is this only intended to be used when moving from 8.1 to 8.2 (ie FP7),
> or is it now a standard part of any fixpak install?

The following (from the FP15 readme [1]) would seem to suggest that it's
part of any (post FP4) fixpak installation:

"""
After installing DB2 Universal Database (UDB) Version 8.2 FixPak 4
*and later*, run the db2updv8 command to update the system catalogs...
"""

However I suppose that could be interpreted to mean "if installing FP4 or
above on a pre-FP4 installation...". It also explicitly states it's an
optional step:

"""
Running the db2updv8 command is *not required*, but some functionality in
DB2 UDB Version 8.2 will not work if this command is not run.
"""

In other words, I'm not sure but I doubt there's any harm in doing it
even when it's not required so you may as well go ahead and run it (ISTR
I've run it after each fixpak install on my servers).

[1] http://download.boulder.ibm.com/ibmdl/pub/ps/products/db2/fixes2/
english-us/db2linux2632/fixpak/FP15_MI00189/FixPackReadme.html#wq48

Cheers,

Dave.

Reply to this Message

rahul - 31 Aug 2007 11:30 GMT

> > DB2 LUW 8.2 FP15
>
[quoted text clipped - 31 lines]
>
> Dave.

what i think is
if you dont run db2updv8 any new or modified system level tables\views
\procedure wont be included

Reply to this Message