Install online fix pack updates on members and cluster caching facilities (CFs) one at a time to update a DB2® pureScale® instance to a fix pack or special build with a higher code level while the instance remains available.
Code level = Version:10 Release:5 Modification:0 Fixpack:1
Architecture level = Version:10 Release:5 Modification:0 Fixpack:1
Section level = Version:10 Release:5 Modification:0 Fixpack:1
Supports online update = Yes
Minimum committed code level required for online install =
Version:10 Release:5 Modification:0 Fixpack:0
The execution completed successfully.
For more information see the DB2 installation log at "/tmp/installFixPack.log.24174".
DBI1070I Program installFixPack completed successfully.
You can update one or more members or cluster caching facilities (CFs) while the remaining members and CFs continue to process transactions. You must update all members and CFs before you can commit the changes and update the DB2 pureScale instance. If the members and CFs are located on the same host, you must apply the fix pack update only once per host.
To install an online fix pack update on a DB2 pureScale instance:
media-dir/installFixPack -p FP-install-path -I instance-name -online -l log-file-name -t trace-file-name
Where FP-install-path is
the directory where you want to install the fix pack and media-dir is
the directory where you uncompressed the fix pack image. FP-install-path must be the same
on all hosts. In
addition, the FP-install-path must be a different
path than the currently installed DB2 version. The -online parameter
is the default and can be omitted.media-dir/installFixPack -p FP-install-path -I instance-name -online -l log-file-name -t trace-file-name -f RSCT
However,
when you use the -f parameter to force the fix
pack installation to continue, later if you decide to move back to
the previous version of the fix pack by canceling the online fix pack
update, the DB2 installer is
not able to revert the specified software (RSCT, SA MP or GPFS) to the same earlier version. Ensure you apply the fix packs to each member before you continue with the next step.
media-dir/installFixPack -p FP-install-path -I instance-name -online -l log-file-name -t trace-file-name
Where FP-install-path is
the directory where you want to install the fix pack and media-dir is
the directory where you uncompressed the fix pack image. FP-install-path must be the same
on all hosts. In
addition, the FP-install-path must be a different
path than the currently installed DB2 version. The -online parameter
is the default and can be omitted.db2instance -list
The
secondary CF must be in PEER state before updating the primary CF. db2 "SELECT ID as CF_ID, varchar(CURRENT_HOST,21) AS HOST, varchar(STATE,14) AS CF_STATE FROM SYSIBMADM.DB2_CF"
CF_ID HOST CF_STATE
------ --------------- --------------
128 cfserver56 CATCHUP(79%)
129 cfserver54 PRIMARY
2 record(s) selected.
The CATCHUP percentage value represents
the amount to which the secondary CF is caught up to the current state
of the primary CF.media-dir/installFixPack -p FP-install-path -I instance-name -online -l log-file-name -t trace-file-name
Where FP-install-path is
the directory where you want to install the fix pack and media-dir is
the directory where you uncompressed the fix pack image. FP-install-path must be the same
on all hosts. The -online parameter is the
default and can be omitted.media-dir/installFixPack -check_commit -I instance-name
If the command is successful, you can continue with the next step.
media-dir/installFixPack -commit_level -I instance-name -l log-file-name -t trace-file-name
db2pd -ruStatus
db2updv105 -d db-name
/local/tmp/FP4image/installFixPack -p /opt/ibm/db2/V10.5FP4 -I Instance1
-online -l /tmp/FP4log_mbserver53
ROLLING UPDATE STATUS: Disk Value Memory Value
Record Type = INSTANCE
ID = 0
Code Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) Not Applicable
Architecture Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) Not Applicable
State = [NONE]
Last updated = 2013/04/18:02:58:58
Record Type = MEMBER
ID = 0
Code Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000)
CECL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Architecture Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000)
CEAL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Section Level = V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000) V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000)
Last updated = 2013/04/18:07:59:48
mbserver53.domain.com: db2pd -ruStatus -localhost ... completed ok
Record Type = MEMBER
ID = 1
Code Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
CECL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Architecture Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
CEAL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Section Level = V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000) V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000)
Last updated = 2013/04/18:05:12:20
mbserver55.domain.com: db2pd -ruStatus -localhost ... completed ok
Record Type = CF
ID = 128
Code Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000400000000) Not Applicable
Architecture Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000400000000) Not Applicable
Last updated = 2013/04/18:07:31:14
Record Type = CF
ID = 129
Code Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000400000000) Not Applicable
Architecture Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000400000000) Not Applicable
Last updated = 2013/04/18:07:25:55
/local/tmp/FP4image/installFixPack -online -p /opt/ibm/db2/V10.5FP4 -I Instance1 -t trace-file-name
-l /tmp/FP4log_cfserver56
ROLLING UPDATE STATUS: Disk Value Memory Value
Record Type = INSTANCE
ID = 0
Code Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) Not Applicable
Architecture Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) Not Applicable
State = [NONE]
Last updated = 2013/04/18:02:58:58
Record Type = MEMBER
ID = 0
Code Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
CECL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Architecture Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
CEAL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Section Level = V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000) V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000)
Last updated = 2013/04/18:01:57:35
mbserver53.domain.com: db2pd -ruStatus -localhost ... completed ok
Record Type = MEMBER
ID = 1
Code Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
CECL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Architecture Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
CEAL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Section Level = V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000) V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000)
Last updated = 2013/04/18:05:12:20
mbserver55.domain.com: db2pd -ruStatus -localhost ... completed ok
Record Type = CF
ID = 128
Code Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) Not Applicable
Architecture Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) Not Applicable
Last updated = 2013/04/18:02:58:52
Record Type = CF
ID = 129
Code Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
Architecture Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
Last updated = 2013/04/18:07:25:55
db2instance -list
The
command output shows that the cfserver56 is in
PEER state:ID TYPE STATE HOME_HOST CURRENT_HOST ALERT PARTITION_NUMBER LOGICAL_PORT NETNAME
-- ---- ----- --------- ------------ ----- ---------------- ------------ -------
0 MEMBER STARTED mbserver53 mbserver53 NO 0 0 mbserver53-ib0
1 MEMBER STARTED mbserver55 mbserver55 NO 0 0 mbserver55-ib0
128 CF PRIMARY cfserver54 cfserver54 NO - 0 cfserver54-ib0
129 CF PEER cfserver56 cfserver56 NO - 0 cfserver56-ib0
HOSTNAME STATE INSTANCE_STOPPED ALERT
-------- ----- ---------------- -----
cfserver56 ACTIVE NO NO
cfserver54 ACTIVE NO NO
mbserver55 ACTIVE NO NO
mbserver53 ACTIVE NO NO
/local/tmp/FP4image/installFixPack -p /opt/ibm/db2/V10.5FP4 -I Instance1
-online -l /tmp/FP4log_cfserver54
ROLLING UPDATE STATUS: Disk Value Memory Value
Record Type = INSTANCE
ID = 0
Code Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) Not Applicable
Architecture Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) Not Applicable
State = [NONE]
Last updated = 2013/04/18:02:58:58
Record Type = MEMBER
ID = 0
Code Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
CECL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Architecture Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
CEAL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Section Level = V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000) V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000)
Last updated = 2013/04/18:01:57:35
mbserver53.domain.com: db2pd -ruStatus -localhost ... completed ok
Record Type = MEMBER
ID = 1
Code Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
CECL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Architecture Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
CEAL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Section Level = V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000) V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000)
Last updated = 2013/04/18:05:12:20
mbserver55.domain.com: db2pd -ruStatus -localhost ... completed ok
Record Type = CF
ID = 128
Code Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
Architecture Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
Last updated = 2013/04/18:07:31:14
Record Type = CF
ID = 129
Code Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
Architecture Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
Last updated = 2013/04/18:07:25:55
ROLLING UPDATE STATUS: Disk Value Memory Value
Record Type = INSTANCE
ID = 0
Code Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) Not Applicable
Architecture Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) Not Applicable
State = [NONE]
Last updated = 2013/04/18:02:58:58
Record Type = MEMBER
ID = 0
Code Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000)
CECL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Architecture Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000)
CEAL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Section Level = V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000) V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000)
Last updated = 2013/04/18:07:59:48
mbserver53.domain.com: db2pd -ruStatus -localhost ... completed ok
Record Type = MEMBER
ID = 1
Code Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000)
CECL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Architecture Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000)
CEAL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Section Level = V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000) V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000)
Last updated = 2013/04/18:09:24:18
mbserver55.domain.com: db2pd -ruStatus -localhost ... completed ok
Record Type = CF
ID = 128
Code Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
Architecture Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
Last updated = 2013/04/18:07:31:14
Record Type = CF
ID = 129
Code Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
Architecture Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
Last updated = 2013/04/18:07:25:55
/local/tmp/FP4image/installFixPack -check_commit -I Instance1
-l /tmp/checkcommit.log
The
following command output shows that online update was successful and
that all members and CF are ready for issuing the commit of the fix
pack update:DBI1446I The installFixPack command is running.
The pre-commit verification process for an online fix pack update has started....
The checks for the pre-commit verification process have been completed successfully.
If you perform a commit, the new level will be =
Version:10 Release:5 Modification:0 Fixpack:4
The execution completed successfully.
For more information see the DB2 installation log at "/tmp/FP4_checkcommit.log".
DBI1070I Program installFixPack completed successfully.
/local/tmp/FP4image/installFixPack -commit_level -I Instance1
-l /tmp/FP4_commit.log
The
following command output shows the commit was successful:DBI1446I The installFixPack command is running.
The execution completed successfully.
For more information see the DB2 installation log at "/tmp/FP4_commit.log".
DBI1070I Program installFixPack completed successfully.
ROLLING UPDATE STATUS: Disk Value Memory Value
Record Type = INSTANCE
ID = 0
Code Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
Architecture Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
State = [NONE]
Last updated = 2013/04/18:08:58:21
Record Type = MEMBER
ID = 0
Code Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000)
CECL = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000)
Architecture Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000)
CEAL = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000)
Section Level = V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000) V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000)
Last updated = 2013/04/18:07:59:48
mbserver53.domain.com: db2pd -ruStatus -localhost ... completed ok
Record Type = MEMBER
ID = 1
Code Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000)
CECL = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000)
Architecture Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000)
CEAL = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000)
Section Level = V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000) V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000)
Last updated = 2013/04/18:09:24:18
mbserver55.domain.com: db2pd -ruStatus -localhost ... completed ok
Record Type = CF
ID = 128
Code Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
Architecture Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
Last updated = 2013/04/18:07:31:14
Record Type = CF
ID = 129
Code Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
Architecture Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
Last updated = 2013/04/18:07:25:55