DB2 - Problem description
Problem IT30474 | Status: Closed |
DB2 PURESCALE CLUSTER MEMBERS MAY CRASH DUE TO CERTIAN DISK IO ISSUES IN A CF NODE | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - 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: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to db2_v105fp11 or later * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 01.10.2019 14.01.2021 14.01.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |