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'. |
