DB2 - Problem description
Problem IT35376 | Status: Closed |
DB2 MIGHT CAUSE EXCESSIVE LOGGING (SQL0952N MESSAGES) WHEN A QUERY IS INTERRUPTED. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
When queries are interrupted during execution, excessive logging of SQL0952N messages may occur in the db2diag.log. The db2diag.log file looks like this: 2020-11-09-08.17.59.621096+060 I14824A2652 LEVEL: Event PID : 58720904 TID : 46521 PROC : db2sysc 0 INSTANCE: XXX NODE : 000 DB : XXX APPHDL : 0-190 APPID: XXX UOWID : 2 ACTID: 134 AUTHID : XXX HOSTNAME: XXX EDUID : 46521 EDUNAME: db2agntcol (XXX) 0 FUNCTION: DB2 UDB, RAS/PD component, pdLogInternal, probe:999 DATA #1 : Caught String sqeAgentServices::RequestAgentForAppl. Dumping stack trace CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x090000003210CC58 IPRA.$pdLogInternal__FUlUiT1T2N41PvT1bPPc + 0x1698 [1] 0x0900000032132E98 pdLog + 0x6D8 [2] 0x0900000032EC682C RequestAgentForAppl__16sqeAgentServicesFiT1P12SQLZ_APP_HDLP23SQL KD_RQST_REPLY_FORMATP17SQLE_CONNECT_INFO + 0x29FC [3] 0x0900000032ECA140 RequestAgent__16sqeAgentServicesFiP18SQLCC_INITSTRUCT_TT1P12SQLZ _APP_HDLP23SQLKD_RQST_REPLY_FORMATT1 + 0x1A20 [4] 0x0900000032C3511C IPRA.$sqlkdProcessSmpRequest__FP8SQLKD_CBP14sqeApplicationP8sqeA gentP23SQLKD_RQST_REPLY_FORMATP18SQLZ_PDB_UNIQUE_ID + 0x24C [5] 0x0900000032C2F034 sqlkdDispatchRequest__FP23SQLKD_RQST_REPLY_FORMATP14sqeApplicati on + 0x3694 [6] 0x090000003673DB48 sqlriDispatchSmpSubagents__FP8sqlrr_cbiP10sqlri_evloUlPvT5P13SQL E_SMP_INFObT8 + 0x1308 [7] 0x090000004AC65458 cdeDispatchReq__Q2_7ibm_cde5queryFUiPvT2P13SQLE_SMP_INFObT5 + 0xE8 [8] 0x09000000493E1E58 runSingleTableQuery__Q3_7ibm_cde5query9SchedulerFv + 0x8C8 [9] 0x09000000493E1144 runCompositeQuery__Q3_7ibm_cde5query9SchedulerFv + 0x114 [10] 0x09000000493E45B0 runMasterThread__Q3_7ibm_cde5query9SchedulerFPvPi + 0x120 [11] 0x09000000493F8C50 cdeEntryPointImpl__Q2_7ibm_cde5queryFP8sqeAgentPvT2 + 0xA0 [12] 0x090000004F5AD588 startCdeSubagent__12cdeInterfaceFP8sqeAgent + 0xB8 [13] 0x0900000036745928 sqlriInvokeCde__FP8sqlrr_cb + 0x48 [14] 0x090000003509F7D8 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x5F8 [15] 0x0900000039973C5C sqlrr_smp_router__FP8sqlrr_cb + 0x18C [16] 0x090000003996F8F0 sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0x10C0 [17] 0x0900000034423450 IPRA.$sqleSubRequestRouter__FP8sqeAgentPUiPUl + 0x870 [18] 0x090000003441DF44 sqleProcessSubRequest__FP8sqeAgent + 0x2F24 [19] 0x0900000032321B48 RunEDU__8sqeAgentFv + 0xA28 [20] 0x09000000322E85F0 EDUDriver__9sqzEDUObjFv + 0x2F0 [21] 0x0900000032251514 sqloEDUEntry + 0x364 [22] 0x090000000054DFE8 _pthread_body + 0xE8 [23] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF 2020-11-09-08.18.08.662392+060 I24889A693 LEVEL: Error PID : 58720904 TID : 46521 PROC : db2sysc 0 INSTANCE: XXX NODE : 000 DB : XXX APPHDL : 0-190 APPID: XXX UOWID : 2 ACTID: 134 AUTHID : XXX HOSTNAME: XXX EDUID : 46521 EDUNAME: db2agntcol (XXX) 0 FUNCTION: DB2 UDB, base sys utilities, sqeAgentServices::RequestAgentForAppl, probe:1820 MESSAGE : Appl failed to start up on this node. Interrupt type = DATA #1 : Hexdump, 4 bytes 0x0A00000022BFAF60 : 8300 0001 2020-11-09-08.18.08.663700+060 I28355A652 LEVEL: Warning PID : 58720904 TID : 46521 PROC : db2sysc 0 INSTANCE: XXX NODE : 000 DB : XXX APPHDL : 0-190 APPID: XXX UOWID : 2 ACTID: 134 AUTHID : XXX HOSTNAME: XXX EDUID : 46521 EDUNAME: db2agntcol (XXX) 0 FUNCTION: DB2 UDB, buffer dist serv, sqlkdDispatchRequest, probe:205 RETCODE : ZRC=0xFFFFFC48=-952 SQL0952N Processing was cancelled due to an interrupt. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 or later * **************************************************************** | |
Local Fix: | |
N/A | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 or later * **************************************************************** | |
Comment | |
Upgrade to 11.5.6 or later | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.12.2020 21.06.2021 21.06.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |