Updates the database system catalog to support the fix pack you have installed. This command can be used only on a database running DB2® Version 10.5 Fix Pack 1 or later on Linux, UNIX or Windows.
SYSADM
Database. The command automatically establishes a connection to the specified database.
>>-db2updv105-- -d--database name-------------------------------> >--+----------------------------+--+-----+--+-----+--+-----+--->< '- -u--userid-- -p--password-' '- -a-' '- -o-' '- -h-'
db2updv105 -d sample
If
your databases were created or upgraded to DB2 Version 10.5 GA and you applied DB2 Version 10.5 Fix Pack 1 or later, then running
the above command will automatically apply all updates required from
Version 10.5 GA up to and including the fix pack level that you are
installing.Before issuing the db2updv105 command, you must commit the fix pack update. Committing the fix pack update puts the instance in a homogeneous state. If the fix pack update is not committed, issuing the db2updv105 command returns an error because the instance is in heterogeneous state.
The instance must be in homogeneous state before issuing the db2updv105 command. If the instance is in heterogeneous state, issuing this command returns an error. For more details, see Database and instance operations affected by an online fix pack update in progress.
In a partitioned database environment, you must run this command from the catalog partition.
For improved performance, the db2updv105 command only apply updates that are required in order to make the databases appear as if they were created at the fix pack level that you are installing. Thus, if the command is issued more than once, no errors are reported and each of the system catalog updates is applied only once. However, if you wish to forcefully reapply all of the updates, you may do so by appending the -a parameter.