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.
Authorization
SYSADM
Required connection
Database. The command automatically establishes a connection to the specified database.
Command syntax
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.
- -a
- Forces all updates to be run.
- -o
- Enables Oracle data dictionary-compatible views
- -h
- Displays help information. When this option is specified, all other options are ignored, and only the help information is displayed.
Example
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.
- 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.