By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

db2updv8 necessary for FP14 -> FP15?

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.