Support for Informix

Latest versions	fixlist
11.1.0.7
10.5.0.9
10.1.0.6
9.8.0.5
9.7.0.11
9.5.0.10
9.1.0.12

Have problems? - contact us.
Register for free
Contact form

DB2 - Problem description

Problem IT22432	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 / B10 - 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: ... <StackTrace> -------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 </StackTrace>
Problem Summary:
**************************************************************** * USERS AFFECTED: * * All Platforms * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 LUW v11.1 Mod 3 Fixpack 3 * ****************************************************************
Local Fix:
Increase the DBHEAP values.
available fix packs:
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
Solution
First Fixed in Db2 LUW v11.1 Mod 3 Fixpack 3
Workaround
not known / see Local fix
Timestamps
Date - problem reported : Date - problem closed : Date - last modified :	18.09.2017 16.03.2018 16.03.2018
Problem solved at the following versions (IBM BugInfos)

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