DB2 - Problem description
Problem IT25138 | Status: Closed |
THE "DB2CLUSTER -CM -ENTER -MAINTENANCE COMMAND" MAY FAIL DUE TOTSA RESOURCES PROBLEM | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
Once user executes "db2cluster -cm -enter -maintenance" command, it may return error: -bash-4.2$ sudo /opt/IBM/db2/V10.5/FP9/bin/db2cluster -cm -enter -maintenance -debug Unable to enter maintenance mode on the local host. A diagnostic log has been saved to '/tmp/ibm.db2.cluster.NMNqaa'.. In the diagnostic file one can observe message similar to following: 2018-05-14-07.56.58.130870-300 E14673A1008 LEVEL: Error PID : 4718904 TID : 1 PROC : db2cluster INSTANCE: db2inst1 NODE : 000 HOSTNAME: node01 EDUID : 1 FUNCTION: , , , probe:2681 RETCODE : ECF=0x9000053B=-1879046853=ECF_SQLHA_STOP_NODE_FAILED Node stop failed DATA #1 : String, 66 bytes libsqlha: sqlhaOfflineDomainNode() call error from wrapper library DATA #2 : String, 506 bytes Line # : 19048---2632-110 The operation was rejected by one or more nodes, probably because one or more resources are online or there was an error encountered in determining if any resources are online. node01: 2632-054 The requested operation failed due to the rejection from the resource class IBM.CHARMControl. Message returned from the resource class: 2621-793 Node "node01" cannot be made offline. System Automation Manager reports that there are resources online on this node.. ; FFDC ID: DATA #3 : signed integer, 4 bytes 98349 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 m4fp4 or later * **************************************************************** | |
Local Fix: | |
db2stop member/cf ; db2stop instance on ; touch /var/db2/.db2_maintenance_`hostname -s`; -------------- wait for all mount resources on that host to go to "failed offline" state; db2cluster -cm -enter -maintenance; | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.05.2018 29.11.2018 29.11.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |