DB2 - Problembeschreibung
Problem IT05391 | Status: Geschlossen |
SET WRITE SUSPEND/RESUME MAY HANG WHEN IT IS NOT ABLE TO ACCESS THE DB CONFIG FILE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
Set write suspend/resume may deadlatch if it is not able to access the db config file. The following message will be seen in the db2diag.log 2014-05-27-15.09.56.282687-240 I332308A2711         LEVEL: Warning PID     : 6946998              TID : 249034         PROC : db2sysc 0 INSTANCE: db2prd               NODE : 000           DB   : PRD APPHDL  : 0-2339               APPID: *LOCAL.db2prd.140527191028 AUTHID  : DB2PRD               HOSTNAME: wbaurp10 EDUID   : 249034               EDUNAME: db2agent (PRD) 0 FUNCTION: DB2 UDB, config/install, sqlf_read_db_and_verify, probe:878 DATA #1 : <preformatted> Error on sqlf_openfile. pDbName: <NO DBNAME> pCfgFilePath /db2/PRD/db2prd/NODE0000/SQL00001/MEMBER0000/SQLDBCONF pMemberDbPath /db2/PRD/db2prd/NODE0000/SQL00001/MEMBER0000/ memberCfgFilepath /db2/PRD/db2prd/NODE0000/SQL00001/MEMBER0000/SQLDBCONF bool bGlobalFile 0 globalDbPath /db2/PRD/db2prd/NODE0000/SQL00001/ globalCfgFilepath /db2/PRD/db2prd/NODE0000/SQL00001/SQLDBCONF userExpectedSize 0 pFileOpen 0 openMode 76 callerID 405929991 retry: 0 of num_retries: 0 rc: -2029060074 CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)   [0] 0x090000000F6AABB4 pdLogPrintf + 0x60   [1] 0x090000000F9A0478 sqlf_read_db_and_verify__FPcN21bP10sqlf_dbcfdsUlP12SQLO_FHANDLEP iiT10_P5sqlca + 0xC0C   [2] 0x090000000FC75E38 sqlfIntUpdateDbCfg__FPCcN21P6db2CfgP5sqlca + 0x42C   [3] 0x09000000116EBA18 writeNew__28sqeGlobalSuspendIOStateLotchFv + 0x1A4   [4] 0x09000000116E3100 release__22@82@13520@sqlpValLotchFb + 0x3B8   [5] 0x0900000010188154 sqleSetWriteResume__FP5sqlcaP9sqeBsuEduCUl + 0x25EC   [6] 0x09000000101AD40C sqleTriggerSuspendIO__FP14db2UCinterfaceP5sqldaT2P5sqlca + 0x554   [7] 0x090000000FC10524 sqlerKnownProcedure__FiPcPiP5sqldaT4P13sqlerFmpTableP8sqeAgentP5 sqlca + 0x8F0   [8] 0x090000000FD8993C sqlerCallDL__FP14db2UCinterfaceP9UCstpInfo + 0x960   [9] 0x09000000116B6404 sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x1694   [10] 0x090000000FD73014 sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC interface + 0x7C   [11] 0x090000000FF15490 .sqljsParse.fdpr.clone.1761__FP13sqljsDrdaAsCbP14db2UCinterfaceP 8sqeAgentb + 0x37C   [12] 0x090000000F84E574 @73@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x2A0   [13] 0x090000000FE64B94 @73@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x1FC   [14] 0x090000000FE654A4 @73@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x558   [15] 0x090000000FE64718 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x21C   [16] 0x090000000FA8EA94 RunEDU__8sqeAgentFv + 0x59C   [17] 0x090000000FA8DD28 EDUDriver__9sqzEDUObjFv + 0x13C   [18] 0x090000000FA8DBB0 sqlzRunEDU__FPcUi + 0x10   [19] 0x090000000FA9E3C4 sqloEDUEntry + 0x264   [20] 0x0900000000619C90 _pthread_body + 0xF0   [21] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF Obtaining a trapfile will show the globalSuspendIOStateLotch being held and waited on by the same thread. <LatchInformation> Waiting on latch type: (SQLO_LT_globalSuspendIOStateLotch) - Address: (0x78000001f8b5640), Line: 760, File: ../include/sqleSuspend.h Holding Latch type: (SQLO_LT_globalSuspendIOStateLotch) - Address: (0x78000001f8b5640), Line: 760, File: ../include/sqleSuspend.h HoldCount: 1 Holding Latch type: (SQLO_LT_preventSuspendIOLotch) - Address: (0x78000001f8b5608), Line: 5515, File: sqleSuspend.C HoldCount: 1 </LatchInformation> | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL thats using below V10.5 FP7 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V10.5 Fixpack 7 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Upgrade to DB2 V10.5 Fixpack 7 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 05.11.2014 10.02.2016 10.02.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |