suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT33691 Status: Closed

ON DPF INSTANCE APPLICATIONS MAY HANG WHILE DOING A COMMIT

product:
DB2 FOR LUW / DB2FORLUW / B50 - DB2
Problem description:
The diaglog can have a message like:

2020-03-19-18.20.12.746861+540 I28835813E666        LEVEL: Info
PID     : 11413                TID : 17592823509344 PROC :
db2sysc 5
INSTANCE: db2inst1             NODE : 005
HOSTNAME: XXXX
EDUID   : 148                  EDUNAME: db2pdbc 5
FUNCTION: DB2 UDB, base sys utilities, sqlePdbProcessRequest,
probe:70
DATA #1 : 
Request discarded for reason: 33
Type of request discarded: 80000017
Return code for request discarded: -952
Sender node of request discarded: 8
Counter of request discarded: 26
Reply type of request discarded: 2
app handle: 0-9190; app stamp: 1339535110; app state: 1
Interrupt request: 80000055
Interrupt type: 8300000a

The coord on Member 0 is in this stack:

semtimedop + 0x0038
sqkfChannel::WaitRecvReady(int, int, int) + 0x1104
sqkfChannel::ReceiveBuffer(sqkfBuffer**, int) + 0x0d48
sqkdBdsBufferTable::getNextBuffer(sqkfBuffer**, SQLKD_CB*) +
0x1198
0x000010000CFBE954
0x000010000CFB5E60
0x000010000CFB7848
sqlkdReceiveReply(SQLKD_RQST_REPLY_FORMAT*) + 0x0820
sqlkdInterrupt(SQLKD_INTERRUPT_FORMAT*, sqlca*, sqlrr_cb*) +
0x1b10
sqlrr2pd(sqlrr_cb*, SQLR_PE_TRAN_RQST*, int, int*,
SQLR_PE_TRAN_RPLY**) + 0x0a40
sqlrkprp(sqlrr_cb*, SQLXA_CALL_INFO*, int, int, int, unsigned
int, char*, int*, int*) + 0x1560
sqlrrcom_dps(sqlrr_cb*, int, int, SQLXA_CALL_INFO*) + 0x37e8
sqlrrcom(sqlrr_cb*, int, int) + 0x1464
sqlrr_commit(db2UCinterface*) + 0x0134
pvmPackage::executeSection(sqlca*, unsigned int, bool) + 0x0628
PVM::executeQuery(unsigned int, bool) + 0x0280

The member which is not responding any more can have a stack
like:

0x00001000186CBF78 semtimedop + 0x0038
  0x000010000D0141D4 _ZN11sqkfChannel13WaitRecvReadyEiii +
0x1104
  0x000010000D023E88
_ZN11sqkfChannel13ReceiveBufferEPP10sqkfBufferi + 0x0d48
  0x000010000CFD3D88
_ZN18sqkdBdsBufferTable13getNextBufferEPP10sqkfBufferP8SQLKD_CB
+ 0x1198
  0x000010193B7EB350 0x000010000CFBE954
  0x000010193B7EB3C0 0x000010000CFB5E60
  0x000010193B7EB4F0 0x000010000CFB7848
  0x000010000CFB8CA0
_Z17sqlkdReceiveReplyP23SQLKD_RQST_REPLY_FORMAT + 0x0820
  0x000010000C5D4364
_Z26sqleReceiveAndMergeRepliesP24SQLE_RECEIVE_MERGE_INPUTP25SQLE
_RECEIVE_MERGE_OUTPUTP5sqlcaP8sqlrr_cb + 0x05f4
  0x000010000CFB2DB0
_Z14sqlkdInterruptP22SQLKD_INTERRUPT_FORMATP5sqlcaP8sqlrr_cb +
0x2760
  0x000010000FA9E960 _Z16sqlrr_sub_rrsvptP8sqlrr_cbi + 0x1b40
  0x000010000FA7A0C8
_Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x1068
  0x000010193B7EDB80 0x000010000C49BB60
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.5.5.0 or higher                            *
****************************************************************
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
24.07.2020
20.11.2020
20.11.2020
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)