db2updv111 - Update database to Version 11.1 fix pack command

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 11.1 Fix Pack 1 or later on Linux®, UNIX or Windows.



Required connection

Database. The command automatically establishes a connection to the specified database.

Command syntax

Read syntax diagramSkip visual syntax diagram db2updv111-ddatabase name-uuserid-ppassword-a-o-h

Command parameters

-d database name
Specifies the name of the database to be updated.
-u userid
Specifies the user ID.
-p password
Specifies the password for the user.
Forces all updates to be run.
Enables Oracle data dictionary-compatible views
Displays help information. When this option is specified, all other options are ignored, and only the help information is displayed.


After installing Version 11.1 Fix Pack 1 or later, update the database system catalog in the SAMPLE database by issuing the following command:
db2updv111 -d sample
If your databases were created or upgraded to Db2 Version 11.1 GA and you applied Db2 Version 11.1 Fix Pack 1 or later, then running the above command will automatically apply all updates required from Version 11.1 GA up to and including the fix pack level that you are installing.

Usage notes

Before issuing the db2updv111 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 db2updv111 command returns an error because the instance is in heterogeneous state.

The instance must be in homogeneous state before issuing the db2updv111 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 db2updv111 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.

Updates to the system catalogs include the following:
  • Creation of any new procedures available in the fix pack level that you are installing.
  • Alteration of routines to correct the definition.
  • Alteration of system administrative views to the correct definition.