installFixPack - Update installed Db2 database products command
Update the installed Db2 database products in a given location, on all UNIX and Linux® platforms, to the same level as the image. If there are multi-copy Db2 database products installed, the installFixPack command updates one copy at a time according to the path specified.
This command can be found at the top directory in the image.
Fix pack installation will proceed when the database manager (DBM) of every instance (and in a partitioned database environment, every database partition) related to the installation path is stopped, and all Db2 libraries are unloaded. If all the preconditions are satisfied, installFixPack will update those instances and DAS related to the installation path. An additional manual update is not required. For all UNIX and Linux operating systems, the djxlink bind command will be launched automatically when the database is reconnected or when applications are restarted.
In some cases, you may specify different force options to continue the fix pack installation, for example, when not all DBMs are stopped, or Db2 libraries remain loaded. installFixPack will continue, but you may need to manually update the instances and DAS, as well as restart the applications.
For a partitioned database environment instance, install the fix pack on all the database partitions, while the instance update is only needed on the instance owning database partition. To keep the instance fully functional after the update, it is recommended to install all the products and features on all the database partitions, at least on the instance owning database partition.
If you are applying the fix pack to a dsf instance type (that is, a Db2 pureScale® instance associated with the Db2 copy in a Db2 pureScale environment), you must install the fix pack to a new path. You cannot apply the fix pack to the original installation path. The path where the fix pack is installed must be different than the existing installation. In addition, this new path must be the same on all hosts. When installing a fix pack to a new location, the Db2 pureScale instance does not need to be stopped before installing the fix pack.
If
you are applying the fix pack to an ese instance type, you can either
apply the fix pack on top of the original installation path or you
can install the fix pack to a new path. If you install the fix pack
on top of the original installation path, the instance must be stopped
before applying the fix pack. For details, see: Installing
a fix pack to update a Version 9.8 ese or dsf instance type
Authorization
Root installations require root user authority. For non-root installations, you must log on with the user ID that owns the non-root installation.
Required Connection
None
Command syntax
Command parameters
- -n
- Specifies non-interactive mode. When specified, you must also specify -b, -p, and -c. This mode can be used for applications to provide all the required information at the command line in an unattended mode.
- -b base-install-path
- Specifies
the base path where the Db2 database
product has been installed. Mandatory when -n is specified. The length of the
path is limited to 128 characters and is a full path name.
The -b option is not required for a non-root installation of Db2, but it is still mandatory for a root installation. If -b is used in a non-root install, the value of base-install-path must be the user's HOME/sqllib directory, or else the path is considered invalid. If -b is not provided in a non-root install, the Db2 installer will use the user's HOME/sqllib as the install path and continue. But, if -b is used and the provided install path has a Db2 copy installed by a root user, the path is considered invalid since the Db2 copy can only be updated by the user who installed it.
- -c NLPACK_location
- Specifies the location of the related Db2 National
Language Pack (NLPACK). This parameter is mandatory when -n is specified. The
Db2
NLPACK location needs to be provided explicitly if all of the following conditions are met:
- The -n option is specified.
- The installation requires National Language (non-English) support.
- The Db2 NLPACK is neither on the Db2 DVD nor in the same subdirectory as the Db2 database product being installed.
- -f
-
Force option. -f with no argument is not supported.
The following force arguments can be combined. For example,
-f level -f db2lib
. - -f level
- Forces
the installation of an earlier level fix pack or current level fix pack. If the fix pack image is
for a later level than the installed Db2 database product, this option is ignored. Note: If this option is specified, the instance is not automatically updated during the installFixPack execution. You have to manually update the instance using the db2iupdt command.Important: The Tivoli® System Automation (TSA) and the IBM General Parallel File System (GPFS™) cannot be downgraded with the -f level parameter. To downgrade these systems you must complete the following steps:
- Drop the instance.
- Uninstall Db2 including TSA/GPFS.
- Reinstall Db2 pureScale with the TSA/GPFS level required.
- -f db2lib
- This parameter is ignored in a Db2 pureScale environment. Force installFixPack to bypass the checking on Db2 library loading. To ensure that the instances or applications work properly after the installation, the DBM must be stopped for all the related instances (including all database partitions for the related partitioned database environment instances), and all Db2 libraries related to the installation path must be unloaded.
- -f NOTSAMP
- This parameter is ignored in a Db2 pureScale environment. Specifies that the SA MP should not be updated (applicable only to root installation).
- -f install
- Force the installFixPack command to bypass all checking on Db2 library loading and checking that the instance and DAS are stopped. To ensure that the instances or applications work properly after the installation, the DBM must be stopped for all the related instances (including all database partitions for the related partitioned database environment instances), and all Db2 libraries related to the installation path must be unloaded. If this option is specified, neither the instance nor DAS are updated. After the installation, you need to manually update the instance and DAS. Also, note that the options update, install, and ha_standby_ignore are mutually exclusive and cannot be specified in the same installation.
- -f update
- Force the installFixPack command to bypass all the checking on Db2 library loading, and checking that the instance and DAS are stopped. To ensure that the instances or applications work properly after the installation, the DBM must be stopped for all the related instances (including all database partitions for the related partitioned database environment instances), and all Db2 libraries related to the installation path must be unloaded. If this option is specified, both the instance and DAS are updated. Also, note that the options update, install, and ha_standby_ignore are mutually exclusive and cannot be specified in the same installation.
- -f ha_standby_ignore
- This parameter ignores the check for the sqllib directory by forcing the installFixPack command to bypass this check. For example, the check for sqllib directory is ignored in a clustered environment where the standby node does not have the sqllib library mounted. To ensure that the instances or applications work properly after the installation, the DBM must be stopped for all the related instances (including all database partitions for the related partitioned database environment instances), and all Db2 libraries related to the installation path must be unloaded. If this option is specified, neither the instance nor DAS are updated. After the installation, you need to manually update the instance and DAS. Also, note that the options update, install, and ha_standby_ignore are mutually exclusive and cannot be specified in the same installation.
- -f noWPAR
- This parameter is ignored in a Db2 pureScale environment. Applicable to AIX® 6.1 or later in a global environment. Force installFixPack not to do any checking or any actions on the AIX system workload partitions (WPARs) which share the Db2 copy being updated on the global environment. If -f noWPAR is specified, you must manually update the instances and DAS on each system WPAR that shares this Db2 copy.
- -f nobackup
- This parameter is ignored in a Db2 pureScale environment. Force installFixPack to not backup installation files when the components are updated. If you choose not to backup the files, the space requirement of the installation directory is reduced. However, choosing not to backup the files also means that if any errors occur, the Db2 installer will not be able to perform a rollback operation. In this case, you will need to manually clean up the files and reinstall the fix pack.
- -f TSAMP
- Force the installFixPack command to continue the fix pack installation process and update the current version of IBM® Tivoli System Automation for Multiplatforms (SA MP) to the latest version. Specify this parameter, if the current version of Tivoli SA MP is different from the version that was previously installed by the Db2 installer. If you cancel the fix pack installation process, Tivoli SA MP does not revert to an earlier version.
- -f GPFS
- Force the installFixPack command to continue the fix pack installation process and update the current version of IBM General Parallel File System ( GPFS) to the latest version. Specify this parameter, if the current version of GPFS is different from the version that was previously installed by the Db2 installer. If you cancel the fix pack installation process, GPFS does not revert to an earlier version.
- -f RSCT
- Force the installFixPack command to continue the fix pack installation process and update the current version of IBM Reliable Scalable Cluster Technology (RSCT) to the latest version. Specify this parameter, if the current version of RSCT is different from the version that was previously installed by the Db2 installer. If you cancel the fix pack installation process, RSCT does not revert to an earlier version.
- -p FPPath
- Specify where the fix pack is to be installed. In a Db2
pureScale environment,
this parameter is mandatory. Consider the following when using this
parameter:
- When this
parameter is specified, instances are not updated automatically. You must manually update the
instances using the db2iupdt command.
When
working with a Db2
pureScale environment,
the choice of whether to run the db2iupdt command on all hosts depends on the
type of fix pack update being applied.
- For information about online fix pack updates, see Installing online fix pack updates to a higher code level on a Db2 pureScale instance.
- For information about offline fix pack updates, see Installing offline fix pack updates to a Db2 pureScale instance (manual method)
- If you are installing a fix pack to update a Db2 pureScale instance (dsf type instance), the path where the fix pack is installed must be different than the existing installation, and, this path must be the same on all hosts. For fix pack installations outside of a Db2 pureScale environment, the path can be different than the existing installation.
- When this
parameter is specified, instances are not updated automatically. You must manually update the
instances using the db2iupdt command.
When
working with a Db2
pureScale environment,
the choice of whether to run the db2iupdt command on all hosts depends on the
type of fix pack update being applied.
- -show_level_info
- Displays the following fix pack online update attributes for the
current level of code.
- The architecture level.
- The code level.
- Information on whether this level of code can be installed online.
- Information on the minimum committed level required before installing online.
- -commit_level
- Updates the pureScale instance to a new level of code. This option is mandatory for an online fix pack update and its scope is limited to Db2 pureScale environments.
- -check_commit
- Verifies whether the Db2 pureScale instance is ready for a commit.
- -I pureScale-instance
- Specifies the pureScale instance name.
- -online
- Specify this option to start or continue with a fix pack online update. In a fix pack online update, the Db2 cluster can run different levels of code as long as the specified code level is same as the current effective code level (CECL) or higher. Note that during a fix pack online update, the activation of the new level of code can take place while the instance is up and running. This will be the default option when -I pureScale-instance option is used for pureScale fix pack update.
- -offline
- Specify this option to start or continue with an offline update. In an offline update, the Db2 cluster cannot run different levels of code. Note that during an offline update the activation of the new level of code can only take place while the whole instance is down.
- -quiesce_time_out mins
- Specifies how long the command waits before disconnecting applications from the given member. Once this timeout is reached, any active units of work remaining at the time are interrupted. If this parameter is not specified, default timeout value of 2 minutes is used.
- -H hostsListFile
- This parameter can only be specified in a Db2
pureScale environment.
This parameter enables a fix pack update across multiple hosts. All
hosts specified in the host list file must have the same service level.
When this parameter is specified, you cannot specify the -L parameter.Note: After running the installFixPack command with this parameter, always check the log file to ensure that there are no installation errors on any of the remote hosts.
- -L
- Indicates the fix pack is to be applied locally to the current host only. When this parameter is specified, you cannot specify the -H parameter.
- -l log-file
- Specifies the log file. For root installations, the default log file is /tmp/installFixPack.log$$, where $$ represents the process ID. For non-root installations, the default log file is /tmp/installFixPack_userID.log, where userID represents the user ID that owns the non-root installation. If the IBM Tivoli System Automation for Multiplatforms (SA MP) is being installed or updated with the installFixPack command, the corresponding log file will be located in the same directory as Db2 log files.
- -t trace-file
- Turns on the debug mode. The debug information is written to the file name specified.
- -h | -?
- Displays help information.
Usage notes
- If you have Db2 Text Search installed and Text Search is running on any instances related to the Db2 copy, installation attempts to stop the Text Search service but continues with the installation.
-
Format of the host list file can be shown in the following section:
HOST=host1 host1.HOSTNAME=<hostname1> HOST=host2 host2.HOSTNAME=<hostname2> ...
Examples
- To perform an interactive update from GA to Fix Pack 1 when
Db2 Enterprise Server
Edition is
installed on /opt/ibm/db2/COPY1, from the Fix Pack 1 image,
issue:
./installFixPack -b /opt/ibm/db2/COPY1 -l log-file-name -t trace-file-name
- To perform a silent update from GA to Fix Pack 1 when Db2 Enterprise Server
Edition is installed on
/opt/ibm/db2/COPY1, from the Fix Pack 1 image,
issue:
./installFixPack -b /opt/ibm/db2/COPY1 -c full_path_to_NLPACK_image -n -l log-file-name -t trace-file-name
- If for any reason the installed Db2 database
product files get corrupted, instead of uninstalling and installing again to refresh the
installation, issue:
./installFixPack -f level -b full_path_where_DB2_product_installed -l log-file-name -t trace-file-name
- To reduce the space requirement of the
installation directory,
issue:
./installFixPack -f nobackup -b full_path_where_DB2_product_installed -l log-file-name -t trace-file-name
- To apply a fix pack to update a Db2
pureScale instance (dsf
type instance), the path where the fix pack is installed must be different than the existing
installation, and, this path must be the same on all
hosts:
./installFixPack -b full_path_where_DB2_product_installed -p path_where_DB2_fixPack_installed -L -l log-file-name -t trace-file-name
- To apply a fix pack to
update an ese instance type, the path can be the same as the existing installation, or the path can
be different (it is recommended that the fix pack is installed is different than the existing
installation):
./installFixPack -b full_path_where_DB2_product_installed -p full_path_where_DB2_product_installed -L -l log-file-name -t trace-file-name
- In a Db2
pureScale environment,
to apply a fix pack update across multiple
hosts:
./installFixPack -b full_path_where_DB2_product_installed -p full_path_where_DB2_product_installed -H hostsListFile -l log-file-name -t trace-file-name
- To display information related to the
online fix pack update such as the current level of
code:
./installFixPack –show_level_info -l log-file-name -t trace-file-name
- To check whether the Db2 instance is
ready for a commit:
./installFixPack -check_commit -I pureScale-instance -l log-file-name -t trace-file-name