Technical Blog Post
Abstract
A change when entering pureScale maintenance since DB2 V11.1 FP3
Body
When you put pureScale hosts into maintenance mode, don't be surprised with the following message.
You may see this if you are on DB2 V11.1 Mod Pack 3 Fixpack 3.
# /opt/IBM/DB2/V11.1.3/bin/db2cluster -cm -enter -maintenance
Starting from V11.1.3.3, when a specific host wants to enter -cm maintenance mode with "db2cluster -cm -enter -maintenance" command,
the DB2INSTANCE variable needs to be set prior to running it.
This is added as part of the feature to allow multiple hosts to be in maintenance at the same time.
Same DB2INSTANCE requirement applies for "-cm -exit -maintenance" as well.
The behavior of putting all hosts at once "-cm -enter/-exit -maintenance -all" is not changed and doesn't require DB2INSTANCE to be set.
The following DB2 manual page also has the change log.
https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.wn.doc/doc/c0061179.html
• Db2 pureScale host maintenance enhancement offers support for multiple hosts to enter and exit maintenance mode while maintaining the quorum.
This enhancement allows hosts to be down for an extended period of time while performing other maintenance tasks.
Specify the instance name by setting the DB2INSTANCE environment variable before executing the db2cluster -cm -enter/-exit -maintenance commands.
Following command output is an example for doing that where Db2 instance is 'db2inst1' and installation path is '/opt/IBM/DB2/V11.1.3'.
( This should be run by 'root' user. )
# export DB2INSTANCE=db2inst1
# /opt/IBM/DB2/V11.1.3/bin /db2cluster -cm -enter -maintenance
Host 'host1' has entered maintenance mode.
UID
ibm11139860