IBM Support

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

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error 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>
    

Local fix

  • Increase the DBHEAP values.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Platforms                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 LUW v11.1 Mod 3 Fixpack 3                     *
    ****************************************************************
    

Problem conclusion

  • First Fixed in Db2 LUW v11.1 Mod 3 Fixpack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT22432

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-09-18

  • Closed date

    2018-03-16

  • Last modified date

    2018-03-16

  • APAR is sysrouted FROM one or more of the following:

    IT22428

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 March 2018