DB2 FOR LUW / DB2FORLUW / B50 - DB2

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.

****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to 11.5.6 or later                                   *
****************************************************************

N/A

****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to 11.5.6 or later                                   *
****************************************************************

Upgrade to 11.5.6 or later

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

29.12.2020
21.06.2021
21.06.2021