home clear 64x64
en blue 200x116 de orange 200x116 info letter User
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 IT22428 Status: Closed

THE INSTANCE CAN TRAP IN XA FUNCTION TRAPPED IS SQLPRESETXIDINTENTRY WHEN
DBHEAP IS SET TO A LOW VALUE

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
The Instance can trap in XA function trapped is
sqlpResetXidInTEntry.

db2diag.log:

2017-08-22-03.28.27.526104-240 I1418212A634         LEVEL: Error
PID     : 12189790             TID : 235439         PROC :
db2sysc 0
INSTANCE: db2inst1             NODE : 000           DB   :
SAMPLE
APPHDL  : 0-14032              APPID:
10.111.3.73.50392.170822215123
AUTHID  : DB2INST1             HOSTNAME: db2host
EDUID   : 235439               EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services, sqlpxreg, probe:460
RETCODE : ZRC=0x80100027=-2146435033=SQLP_PROTO
          "Transaction manager function called in wrong
context."
          DIA8039C XA error with request type of "". XA protocol
error.

2017-08-22-03.28.27.538680-240 I1418847A1278        LEVEL:
Warning
PID     : 12189790             TID : 235439         PROC :
db2sysc 0
INSTANCE: db2inst1             NODE : 000           DB   :
SAMPLE
APPHDL  : 0-14032              APPID:
10.111.3.73.50392.170822215123
AUTHID  : DB2INST1             HOSTNAME: db2host
EDUID   : 235439               EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services, sqlpxreg,
probe:6590
MESSAGE : xidp and xaFlags:
DATA #1 : Hexdump, 140 bytes
0x0A000000E73F8958 : 5741 5344 0000 0024 0000 0036 0000 015E
WASD...$...6...^
0x0A000000E73F8968 : 08D7 B33D 0000 0001 0A5B D224 9CD9 9CB2
...=.....[.$....
0x0A000000E73F8978 : 8351 5536 777B 6628 0E47 F1D2 39BB F037
.QU6w{f(.G..9..7
0x0A000000E73F8988 : 0000 015E 08D7 B33D 0000 0001 0A5B D224
...^...=.....[.$
0x0A000000E73F8998 : 9CD9 9CB2 8351 5536 777B 6628 0E47 F1D2
.....QU6w{f(.G..
0x0A000000E73F89A8 : 39BB F037 0000 0001 0000 0000 0000 0000
9..7............
0x0A000000E73F89B8 : 0000 0000 0001 0000 0000 0000 0000 0000
................
0x0A000000E73F89C8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x0A000000E73F89D8 : 0000 0000 0000 0000 0000 0000
............
DATA #2 : unsigned integer, 4 bytes
1048576

2017-08-22-03.28.27.548215-240 I1420126A186       LEVEL: Warning
PID:12189790 TID:235439 NODE:000 Title: SQLP_TENTRY
Dump
File:/db2/db2dump/db2host/db2inst1/12189790.235439.000.dump.bin

2017-08-22-03.28.27.575944-240 I1420313A184       LEVEL: Warning
PID:12189790 TID:235439 NODE:000 Title: SQLP_DBCB
Dump
File:/db2/db2dump/db2host/db2inst1/12189790.235439.000.dump.bin

2017-08-22-03.28.27.535223-240 I1420498A634         LEVEL: Error
PID     : 12189790             TID : 250088         PROC :
db2sysc 0
INSTANCE: db2inst1             NODE : 000           DB   :
SAMPLE
APPHDL  : 0-16340              APPID:
10.111.3.88.54613.170822215725
AUTHID  : DB2INST1             HOSTNAME: db2host
EDUID   : 250088               EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services, sqlpxreg, probe:460
RETCODE : ZRC=0x80100027=-2146435033=SQLP_PROTO
          "Transaction manager function called in wrong
context."
          DIA8039C XA error with request type of "". XA protocol
error.

...
2017-08-22-03.28.27.729159-240 I1431016A634         LEVEL: Error
PID     : 12189790             TID : 261654         PROC :
db2sysc 0
INSTANCE: db2inst1             NODE : 000           DB   :
SAMPLE
APPHDL  : 0-16334              APPID:
10.111.3.85.44087.170822215720
AUTHID  : DB2INST1             HOSTNAME: db2host
EDUID   : 261654               EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services, sqlpxreg, probe:460
RETCODE : ZRC=0x80100027=-2146435033=SQLP_PROTO
          "Transaction manager function called in wrong
context."
          DIA8039C XA error with request type of "". XA protocol
error.

2017-08-22-03.28.27.837054-240 I1431651A1278        LEVEL:
Warning
PID     : 12189790             TID : 261654         PROC :
db2sysc 0
INSTANCE: db2inst1             NODE : 000           DB   :
SAMPLE
APPHDL  : 0-16334              APPID:
10.111.3.85.44087.170822215720
AUTHID  : DB2INST1             HOSTNAME: db2host
EDUID   : 261654               EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services, sqlpxreg,
probe:6590
MESSAGE : xidp and xaFlags:
DATA #1 : Hexdump, 140 bytes
0x0A0000010CFF8958 : 5741 5344 0000 0024 0000 0036 0000 015E
WASD...$...6...^
0x0A0000010CFF8968 : 08D7 B3C2 0000 0001 0A50 AB40 2289 C245
.........P.@"..E
0x0A0000010CFF8978 : C809 5048 C41E 751E 35F4 7459 DDD4 17DC
..PH..u.5.tY....
0x0A0000010CFF8988 : 0000 015E 08D7 B3C2 0000 0001 0A50 AB40
...^.........P.@
0x0A0000010CFF8998 : 2289 C245 C809 5048 C41E 751E 35F4 7459
"..E..PH..u.5.tY
0x0A0000010CFF89A8 : DDD4 17DC 0000 0001 0000 0000 0000 0000
................
0x0A0000010CFF89B8 : 0000 0000 0001 0000 0000 0000 0000 0000
................
0x0A0000010CFF89C8 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x0A0000010CFF89D8 : 0000 0000 0000 0000 0000 0000
............
DATA #2 : unsigned integer, 4 bytes
1048576

2017-08-22-03.28.27.862579-240 I1432930A228       LEVEL: Warning
PID:12189790 TID:261654 NODE:000 Title: SQLP_TENTRY
Dump
File:/db2/db2dump/db2host/db2inst1/FODC_Trap_2017-08-22-03.28.27
.799007_0000/12189790.261654.000.dump.bin

2017-08-22-03.28.27.628134-240 I1433159A634         LEVEL: Error
PID     : 12189790             TID : 268850         PROC :
db2sysc 0
INSTANCE: db2inst1             NODE : 000           DB   :
SAMPLE
APPHDL  : 0-16330              APPID:
10.111.3.89.38816.170822215717
AUTHID  : DB2INST1             HOSTNAME: db2host
EDUID   : 268850               EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services, sqlpxreg, probe:460
RETCODE : ZRC=0x80100027=-2146435033=SQLP_PROTO
          "Transaction manager function called in wrong
context."
          DIA8039C XA error with request type of "". XA protocol
error.

FODC_Trap_2017-08-22-03.28.27.799007_0000:

12189790.235439.000.trap.txt:
...

-------Frame------ ------Function + Offset------
0x090000001B5DD794 sqlpResetXidInTEntry__FP11SQLP_TENTRY + 0x144
0x090000001BD771D0
sqlpxrbk__FP8sqeAgentP15SQLXA_CALL_INFOP9SQLP_GXIDPP11sqlo_xlatc
h + 0x940
0x090000001BD228CC
sqlpxrbk__FP8sqeAgentP15SQLXA_CALL_INFOP9SQLP_GXIDPP11sqlo_xlatc
h + 0x204
0x090000001BD2417C
sqlrrbck_dps__FP8sqlrr_cbiN22P15SQLXA_CALL_INFOP9SQLP_GXID +
0x294
0x090000001BD1D84C sqlrrbck__FP8sqlrr_cbiN32P15SQLXA_CALL_INFO +
0x1944
0x090000001BD1BD20 sqlrr_rollback__FP14db2UCinterface + 0x1D8
0x090000001BF9E3A0
sqljsRollbackBeforeConnectReset__FP14db2UCconHandle + 0x264
0x090000001BF9EDFC
@72@sqljsCleanup__FP8sqeAgentP14db2UCconHandle + 0x1F8
0x090000001BF9CA4C
@72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x1050
0x090000001B9EB95C RunEDU__8sqeAgentFv + 0x40E1C
0x090000001B960738 RunEDU__8sqeAgentFv + 0x124
0x090000001A775AE4 EDUDriver__9sqzEDUObjFv + 0x130
0x090000001A4072D4 sqloEDUEntry + 0x3A0
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* All Platforms.                                               *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 v10.5 Fixpack 10 or later.                    *
****************************************************************
Local Fix:
Increase the DBHEAP values.
Solution


Workaround


not known / see Local fix


BUG-Tracking


forerunner  : 
follow-up : IT22432 


Timestamps


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

18.09.2017
16.07.2018
16.07.2018


Problem solved at the following versions (IBM BugInfos)




Problem solved according to the fixlist(s) of the following version(s)