DB2 - Problem description
Problem IT21835 | Status: Closed |
IMPROVE PD DIAGNOSTICS FOR DB2HACFSVERIFYMAINTENANCEMODE() AND DB2HACFSSETCLUSTERCONFIGURATION() FUNCTIONS. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
In pureScale cluster following command might fail: db2cluster -cfs -enter -maintenance Unable to enter file system maintenance mode on the local host. See the DB2 Information Center for more details. A diagnostic log has been saved to '/tmp/ibm.db2.cluster.DTad7a'. In the database logs we can find following entries, that indicates something happened in db2haCFSVerifyMaintenanceMode(), db2haCFSSetClusterConfiguration() functions: 2016-10-20-18.46.29.174171-300 I1576A340 LEVEL: Info PID : 55836728 TID : 1 PROC : db2cluster INSTANCE: NODE : 000 HOSTNAME: host0001 EDUID : 1 FUNCTION: , , , probe:2595 DATA #1 : String, 65 bytes /opt/IBM/db2/V10.5/FP5SB/bin/db2cluster -cfs -enter -maintenance 2016-10-20-18.46.45.282916-300 I1917A463 LEVEL: Severe PID : 55836728 TID : 1 PROC : db2cluster INSTANCE: NODE : 000 HOSTNAME: host0001 EDUID : 1 FUNCTION: DB2 UDB, high avail services, sqlhaCFSCallFunctionDirect, probe:114 MESSAGE : ECF=0x9000052E=-1879046866=ECF_SQLHA_FAILED SQLHA API call error DATA #1 : String, 22 bytes DB2CFS function error. DATA #2 : signed integer, 4 bytes 28 2016-10-20-18.46.45.298378-300 I2381A380 LEVEL: Severe PID : 55836728 TID : 1 PROC : db2cluster INSTANCE: NODE : 000 HOSTNAME: host0001 EDUID : 1 FUNCTION: DB2 UDB, high avail services, sqlhaCFSVerifyMaintenanceMode, probe:2168 RETCODE : ECF=0x9000052E=-1879046866=ECF_SQLHA_FAILED SQLHA API call error 2016-10-20-18.47.06.816796-300 I2762A509 LEVEL: Severe PID : 55836728 TID : 1 PROC : db2cluster INSTANCE: NODE : 000 HOSTNAME: host0001 EDUID : 1 FUNCTION: DB2 UDB, high avail services, sqlhaCFSCallFunctionDirect, probe:114 MESSAGE : ECF=0x9000061D=-1879046627=ECF_SQLHA_CFS_OUTPUT_NOT_RECOGNIZED The output from the CFS call is not recognized. DATA #1 : String, 22 bytes DB2CFS function error. DATA #2 : signed integer, 4 bytes 33 2016-10-20-18.47.06.828009-300 I3272A416 LEVEL: Warning PID : 55836728 TID : 1 PROC : db2cluster INSTANCE: NODE : 000 HOSTNAME: host0001 EDUID : 1 FUNCTION: DB2 UDB, oper system services, sqloMessage, probe:1 MESSAGE : Cannot obtain registry variables DATA #1 : Hexdump, 4 bytes 0x0FFFFFFFFFFCB0E0 : FFFF EC6E ...n 2016-10-20-18.47.06.829356-300 I3689A373 LEVEL: Severe PID : 55836728 TID : 1 PROC : db2cluster INSTANCE: NODE : 000 HOSTNAME: host0001 EDUID : 1 FUNCTION: DB2 UDB, high avail services, sqlhaUIEnterMaintenanceModeForCFS, probe:2269 MESSAGE : ZRC=0x827300AA=-2106392406=HA_ZRC_FAILED "SQLHA API call error" 2016-10-20-18.47.06.830129-300 I4063A319 LEVEL: Error PID : 55836728 TID : 1 PROC : db2cluster INSTANCE: NODE : 000 HOSTNAME: host0001 EDUID : 1 FUNCTION: DB2 UDB, bsu security, sqlex_read_aud_cfg, probe:100 RETCODE : ZRC=0x00000000=0=PSM_OK "Unknown" 2016-10-20-18.47.06.841174-300 I4383A424 LEVEL: Error PID : 55836728 TID : 1 PROC : db2cluster INSTANCE: NODE : 000 HOSTNAME: host0001 EDUID : 1 FUNCTION: DB2 UDB, bsu security, sqlexAuditGetInstanceSettings, probe:0 MESSAGE : ZRC=0x805C0136=-2141454026=SQLEX_AUD_CFG_FILE_ERR "Write to audit log failed" DATA #1 : Hex integer, 4 bytes 0x40000011 2016-10-20-18.47.06.844332-300 E4808A349 LEVEL: Error PID : 55836728 TID : 1 PROC : db2cluster INSTANCE: NODE : 000 HOSTNAME: host0001 EDUID : 1 FUNCTION: DB2 UDB, high avail services, sqlhaUIMain, probe:927 MESSAGE : ZRC=0x827300AA=-2106392406=HA_ZRC_FAILED "SQLHA API call error" However there are no trace points in these functions and nothing is dumped to the database logs. This makes it difficult to pursue the cause of the failure. The purpose of this APAR is to enhance the problem determination code within these two functions to dump more diagnostic data when the problem occurs. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 2 Fix Pack 2 or higher * **************************************************************** | |
Local Fix: | |
No local workaround available. | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT18708 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.08.2017 24.10.2017 24.10.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |