DB2 - Problem description
Problem IT35117 | Status: Closed |
DB2HAICU -DISABLE FAILS ON ZLINUX | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
This APAR affects only HADR on zLinux managed by db2haicu db2haicu -disable hits the following error: .. Are you sure you want to disable high availability (HA) for the database instance 'db2inst1'. This will lock all the resource groups for the instance and disable the HA configuration parameter. The instance will not failover if a system outage occurs while the instance is disabled. You will need to run db2haicu again to enable the instance for HA. Disable HA for the instance 'db2inst1'? [1] 1. Yes 2. No 1 Disabling high availability for instance 'db2inst1' ... .. Locking the resource group for DB2 database partition '0' ... Locking the resource group for DB2 database partition '0' was successful. Unable to disable automation on remote host 'test. Refer to the db2diag.log for more details. db2diag.log will show: 2019-12-01-13.10.37.993395-240 I6363A328 LEVEL: Error PID : 29093 TID : 4396832143184 PROC : db2havend (db2ha) INSTANCE: db2inst1 NODE : 000 HOSTNAME: test FUNCTION: , , , probe:4382 DATA #1 : libsqlha: sqlhaInvokeCommandImpl call error from wrapper lib 46 Error 46 = DB2HA_ERR_OPERATION_NOT_IMPLEMENTED (The operation is not supported by this library) 2019-12-01-13.10.37.993715-240 E6692A2173 LEVEL: Severe PID : 29093 TID : 4396832143184 PROC : db2havend (db2ha) INSTANCE: db2inst1 NODE : 000 HOSTNAME: test FUNCTION: DB2 UDB, high avail services, sqlhaInvokeCommand, probe:16276 RETCODE : ECF=0x9000052F=-1879046865=ECF_SQLHA_INTERNAL Internal SQLHA Error DATA #1 : String, 8 bytes test DATA #2 : String, 2 bytes su DATA #3 : String, 40 bytes - db2inst1 -c 'db2haicu -remote_disable' DATA #4 : String, 4 bytes root DATA #5 : SQLHA Remote Command Output, PD_TYPE_SQLHA_COMMAND_RESPONSE, 3508 bytes commandResponse->callRC: 0x9000052F commandResponse->output: NOT_POPULATED DATA #6 : SQLHA Control Block, PD_TYPE_SQLHA_CONTROL_BLOCK, 4160 bytes sqlhaCB->timeout: 1200 sqlhaCB->runMode: PASS_THRU sqlhaCB->options: NONE sqlhaCB->vendorHandle: NULL sqlhaCB->sqlhaClusterHandle->clusterHandle: 0 sqlhaCB->sqlhaClusterHandle->clusterFlags: 0 sqlhaCB->sqlhaClusterHandle->clusterErrorNum: 0 sqlhaCB->sqlhaClusterHandle->errorMessage: sqlhaCB->sqlhaClusterHandle->clusterCommand: DATA #7 : SQLHA Cluster Session Handle, PD_TYPE_SQLHA_INVOKE_COMMAND_STRUCT, 10184 bytes invokeCommandStruct->nodeName: test invokeCommandStruct->command: su invokeCommandStruct->arguments: - db2inst1 -c 'db2haicu -remote_disable' invokeCommandStruct->username: root invokeCommandStruct->output: NOT POPULATED invokeCommandStruct->sqlhaClusterHandle->clusterHandle: 0 invokeCommandStruct->sqlhaClusterHandle->clusterFlags: 0 invokeCommandStruct->sqlhaClusterHandle->clusterErrorNum: 0 invokeCommandStruct->sqlhaClusterHandle->errorMessage: invokeCommandStruct->sqlhaClusterHandle->clusterCommand: CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x000003FFA699E47E sqlhaInvokeCommand + 0xC02 [1] 0x000003FFA6AEABE6 sqlhaExecuteCommand + 0x10E [2] 0x0000000080017BEE _Z29_sqlhaUseHAvendExecuteCommandjPv + 0x18E [3] 0x00000000800096E2 _Z25sqlhaInvokeVendorFunctionPv + 0x106E [4] 0x0000000080007672 main + 0xF4A [5] 0x000003FFA33254D2 __libc_start_main + 0x112 [6] 0x0000000080006036 db2havend (db2ha) + 0x6036 2019-12-01-13.10.38.021906-240 E8866A485 LEVEL: Error PID : 27611 TID : 4396074010448 PROC : db2haicu INSTANCE: db2inst1 NODE : 000 HOSTNAME: test FUNCTION: DB2 UDB, high avail services, sqlhaUIRunRemoteHaicuCmds, probe:1190 MESSAGE : ECF=0x9000052E=-1879046866=ECF_SQLHA_FAILED SQLHA API call error DATA #1 : (0/1): The 'su - db2inst1 -c 'db2haicu -remote_disable'' command failed to execute on host 'test'. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * HADR automation using db2haicu on zLinux * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade server to First fixed in v11.1 Mod 4 Fixpack 5 * **************************************************************** | |
Local Fix: | |
Manually run db2haicu to disable automation | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * HADR automation using db2haicu on zLinux * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade server to First fixed in v11.1 Mod 4 Fixpack 5 * **************************************************************** | |
Comment | |
First fixed in v11.1 Mod 4 Fixpack 5 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 01.12.2020 29.03.2021 29.03.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |