DB2 - Problem description
Problem IT36639 | Status: Closed |
DB2 PURESCALE CLUSTER MEMBERS MAY CRASH DUE TO CERTIAN DISK IO ISSUES IN A CF NODE | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
DB2 pureScale cluster members may crash when there is certian disk IO issues in a CF node and cleanup processing failure with the following pattern error in db2diag.log. 20XX-XX-XX-19.56.34.181859+540 I66829789A603 LEVEL: Event PID : 10158188 TID : 1 PROC : db2rocme 129 [db2inst1] INSTANCE: db2inst NODE : 129 HOSTNAME: DB2CF1 EDUID : 1 EDUNAME: db2rocme 129 [db2inst1] FUNCTION: DB2 UDB, high avail services, db2rocm_main, probe:1561 DATA #1 : SQLHA Event Recorder header data (struct sqlhaErPdInfo), PD_TYPE_SQLHA_ER_PDINFO, 80 bytes Original timestamp: 2019-08-27-19.56.26.551403859 DATA #2 : String, 58 bytes /home/db2inst1/sqllib/adm/db2rocme 1 CF db2inst1 129 CLEANUP DATA #3 : String, 5 bytes BEGIN 20XX-XX-XX-19.56.34.133415+540 E66816448A1448 LEVEL: Severe PID : 5570880 TID : 1 PROC : db2rocme 129 [db2inst1] INSTANCE: db2inst1 NODE : 000 HOSTNAME: DB2CF2 EDUID : 1 EDUNAME: db2rocme 129 [batinst] FUNCTION: DB2 UDB, oper system services, sqloCreatePGRPFileInternal, probe:960 MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied" DIA8701C Access denied for resource "", operating system return code was "". DATA #1 : String, 34 bytes Error openning process group file. DATA #2 : SQLHA Mirrored File Pair Structure, PD_TYPE_SQLHA_MIRROR_IO, 2136 bytes mirrorIO->left.path: /home/db2inst1/sqllib/ctrlha/.cf.129.pgrp | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * pureScale users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5 m4 fp0 or later. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * pureScale users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5 m4 fp0 or later. * **************************************************************** | |
Comment | |
First fixed in Db2 11.5 m4 fp0. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 20.04.2021 22.04.2021 22.04.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |