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 IT36232 Status: Closed

HANDLE THE ISSUE WHEN 'NULL' VALUE RETURNED FOR NO SHREDDER WORKER, TO
AVOID A MEMBER CRASH IN PURESCALE.

product:
DB2 FOR LUW / DB2FORLUW / B50 - DB2
Problem description:
PS member crashed on stack:

-------Frame------ ------Function + Offset------
0x090000000F8E3584
sqlpshrFlushLogBufForOnlineMembers__FP8sqeAgentP19sqlpDbcbLookup
TableRUlPsUlPv + 0x340
0x090000000F9532C4
sqlpGroupOperationDriver__FP8sqeAgentP19sqlpDbcbLookupTablePFP8s
qeAgentP19sqlpDbcbLookupTableRUlPsUlPv_iT3PvCUi + 0x60C
0x090000000F8257A0
executeOperationOnLocalView__15sqlpDbcbsHandleFP9sqeBsuEduPFP8sq
eAgentP19sqlpDbcbLookupTableRUlPsUlPv_iT2PvCUi + 0x3A0

db2diag:
=========
2020-04-27-07.35.21.958712-240 I224852457A533       LEVEL:
Severe
PID     : 16973950             TID : 78780          PROC :
db2sysc 6
INSTANCE: db2xxxxs             NODE : 006           DB   :
xxxxxx
APPHDL  : 6-63885              APPID: 1.2.2.1.1.2
AUTHID  : db2db2             HOSTNAME: xxxxxxxxx0
EDUID   : 78780                EDUNAME: db2agent (xxxxxx) 6
FUNCTION: DB2 UDB, buffer dist serv,
sqkdBdsBufferTable::getNextReply, probe:20
RETCODE : ZRC=0x81590016=-2124873706=SQLKF_NODE_FAILED "Node
Recovery"


2020-04-27-07.35.21.959692-240 I224853526A514       LEVEL: Error
PID     : 16973950             TID : 78780          PROC :
db2sysc 6
INSTANCE: db2xxxxs             NODE : 006           DB   :
xxxxxx
APPHDL  : 6-63885              APPID: 1.2.2.1.1.2
AUTHID  : db2db2             HOSTNAME: xxxxxxxxx0
EDUID   : 78780                EDUNAME: db2agent (xxxxxx) 6
FUNCTION: DB2 UDB, buffer dist serv, sqlkd_rcv_init, probe:30
RETCODE : ZRC=0x81590016=-2124873706=SQLKF_NODE_FAILED "Node
Recovery"

2020-04-27-07.35.21.960214-240 E224854041A402       LEVEL: Error
PID     : 16973950             TID : 2057           PROC :
db2sysc 6
INSTANCE: db2xxxxs             NODE : 006
HOSTNAME: xxxxxxxxx0
EDUID   : 2057                 EDUNAME: db2fcms 6
FUNCTION: DB2 UDB, fast comm manager, sqkfTcpLink::closeConn,
probe:25
DATA #1 : 
Link info: node 5; type 6; state 2; session 1; activated 1

2020-04-27-07.35.23.366726-240 I224854444A8827      LEVEL: Error
PID     : 16973950             TID : 2057           PROC :
db2sysc 6
INSTANCE: db2xxxxs             NODE : 006
HOSTNAME: xxxxxxxxx0
EDUID   : 2057                 EDUNAME: db2fcms 6
FUNCTION: DB2 UDB, fast comm manager,
sqkfTcpServices::identifyUntrustedIncomingEvent, probe:41
MESSAGE : Error while waiting for connect() completion with node
5. rc = -2129723367. status = 3; port = 60000
DATA #1 : Hexdump, 1648 bytes
0x0780000004FE6FE8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
..........
.........
2020-04-27-07.35.23.375995-240 I224863272A474       LEVEL: Error
PID     : 16973950             TID : 2057           PROC :
db2sysc 6
INSTANCE: db2xxxxs             NODE : 006
HOSTNAME: xxxxxxxxx0
EDUID   : 2057                 EDUNAME: db2fcms 6
FUNCTION: DB2 UDB, fast comm manager,
sqkfSendConduit::HandleConnectLostEvent, probe:10
MESSAGE : Node link dropped by remote peer:
DATA #1 : Hexdump, 2 bytes
0x0A0000000E3FE842 : 0005
..

2020-04-27-07.35.23.376309-240 I224863747A479       LEVEL: Error
PID     : 16973950             TID : 2057           PROC :
db2sysc 6
INSTANCE: db2xxxxs             NODE : 006
HOSTNAME: xxxxxxxxx0
EDUID   : 2057                 EDUNAME: db2fcms 6
FUNCTION: DB2 UDB, fast comm manager,
sqkfSendConduit::HandleConnectLostEvent, probe:20
MESSAGE : Handling conn lost due to event:
DATA #1 : Hexdump, 8 bytes
0x0A0000000E3FE9E8 : 0780 0000 04FE 6F80
......o.

2020-04-27-07.35.23.376661-240 I224864227A479       LEVEL: Error
PID     : 16973950             TID : 2057           PROC :
db2sysc 6
INSTANCE: db2xxxxs             NODE : 006
HOSTNAME: xxxxxxxxx0
EDUID   : 2057                 EDUNAME: db2fcms 6
FUNCTION: DB2 UDB, fast comm manager,
sqkfSendConduit::HandleConnectLostEvent, probe:30
MESSAGE : Informing node failure. link state =
DATA #1 : Hexdump, 4 bytes
0x0A0000000E3FE844 : 0000 0002
....

2020-04-27-07.35.23.376988-240 I224864707A428       LEVEL: Event
PID     : 16973950             TID : 2057           PROC :
db2sysc 6
INSTANCE: db2xxxxs             NODE : 006
HOSTNAME: xxxxxxxxx0
EDUID   : 2057                 EDUNAME: db2fcms 6
FUNCTION: DB2 UDB, base sys utilities, sqleSendNodeFailure,
probe:6390
DATA #1 : 
SD: Requested synchronous member failure recovery for member =
[5] with seq. no = 87
.....
...
2020-04-27-07.36.19.607769-240 E224897726A824       LEVEL: Error
PID     : 16973950             TID : 77041          PROC :
db2sysc 6
INSTANCE: db2xxxxs              NODE : 006           DB   :
xxxxxx
APPHDL  : 6-63891              APPID: 1.2.2.1.1.2
AUTHID  : ATTNYADM             HOSTNAME: lxdbd2t059
EDUID   : 77041                EDUNAME: db2agent (xxxxxx) 6
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler,
probe:30
MESSAGE : ADM14005E  The following error occurred: "Trap".
First Occurrence
          Data Capture (FODC) has been invoked in the following
mode:
          "Automatic".  Diagnostic information has been recorded
in the
          directory named

"/home/db2xxxxs/sqllib/db2dump/DIAG0006/FODC_Trap_20xx-xx-xx-07.
36.19
          .605200_16973950_77041_006/".
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Crash recovery                                               *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* update to Db2 11.5 Mod 4 Fixpack 0 or higher                 *
****************************************************************
Local Fix:
N/A
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* Crash recovery                                               *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* update to Db2 11.5 Mod 4 Fixpack 0 or higher                 *
****************************************************************
Comment
First fixed in Db2 11.5 Mod 4 Fixpack 0
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
15.03.2021
25.08.2021
25.08.2021
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)