IT31149: DISTRIBUTED TRANSACTION ON DATABASE IN DPF ENVIRONMENT MIGHT ENCOUNTER TRAP

Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• When running distributed transaction on a database in DPF
  environment might encounter a trap.  A sample stack for the trap
  is shown below.
  
  0x0000100C823ECC30 0x000010000E7254BC
  _Z8sqlpgxidP8sqeAgentP9SQLP_GXIDP12SQLZ_APP_HDLPjPb + 0x052c
    ( = offset 0xE3B54BC in
  /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
  0x0000100C823ECDA0 0x000010000E226F34
  _Z19sqlpxTEntrySwitchInP8sqeAgentP9SQLP_GXIDjmPjP8SQLP_VTS +
  0x16e4
    ( = offset 0xDEB6F34 in
  /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
  0x0000100C823ECF70 0x000010000EB946F4
  _Z23sqlrr_switch_to_xa_modeP8sqlrr_cbiPcP15sqlrr_rds_xa_cbimP8SQ
  LP_VTS + 0x0454
    ( = offset 0xE8246F4 in
  /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
  0x0000100C823ED090 0x000010000EACFC58
  _Z17sqlrr_tran_routerP8sqlrr_cb + 0x2278
    ( = offset 0xE75FC58 in
  /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
  0x0000100C823ED7A0 0x000010000EA8C434
  _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x0f84
    ( = offset 0xE71C434 in
  /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
  0x0000100C823EDAB0 0x000010000B0FBE00
    ( = offset 0xAD8BE00 in
  /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
  0x0000100C823EDD10 0x000010000B0F6588
  _Z21sqleProcessSubRequestP8sqeAgent + 0x22d8
    ( = offset 0xAD86588 in
  /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
  0x0000100C823EE120 0x000010000B177958 _ZN8sqeAgent6RunEDUEv +
  0x09d8
    ( = offset 0xAE07958 in
  /head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * 250                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.1.4.6                                          *
  ****************************************************************
  

Problem conclusion

• Upgrade to 11.1.4.6
  

Temporary fix

Comments

APAR Information

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

  IT31147

• 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 PSY

     UP