467,209 Members | 1,299 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,209 developers. It's quick & easy.

db2updv8 necessary for FP14 -> FP15?

aj
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
Aug 30 '07 #1
  • viewed: 2414
Share:
2 Replies
On Thu, 30 Aug 2007 13:03:30 -0400, aj scribbled:
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?
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/ibmd...ts/db2/fixes2/
english-us/db2linux2632/fixpak/FP15_MI00189/FixPackReadme.html#wq48
Cheers,

Dave.
Aug 30 '07 #2
On Aug 30, 8:08 pm, Dave Hughes <d...@waveform.plus.comwrote:
On Thu, 30 Aug 2007 13:03:30 -0400, aj scribbled:
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?

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.
what i think is
if you dont run db2updv8 any new or modified system level tables\views
\procedure wont be included

Aug 31 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by The Bicycling Guitarist | last post: by
1 post views Thread by uthuras@hotmail.com | last post: by
10 posts views Thread by LaEisem | last post: by
1 post views Thread by Asphalt Blazer | last post: by
2 posts views Thread by Anonymous Sender | last post: by
28 posts views Thread by lovecreatesbeauty@gmail.c0m | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.