IT19781: IN A DPF DATABASE INSTANCE, IN RARE TIMING CONDITION A SEG-FAULT/TRAP CAN OCCUR IN FUNCTION SQLPSETTID()

DB2 Version 11.1 Mod1 Fix Pack1 iFix001 for Linux, UNIX, and Windows
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
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
Db2 Version 11.1 Mod4 Fix Pack4 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 4 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• In a v11.1.1.1 and DPF database instance, in rare timing
  conditions a seg-fault/trap can occur in function sqlpSetTID().
  
  The stack dump will have a stack similar to this:
  
  <StackTrace>
  -------Frame------ ------Function + Offset------
  0x09000000201857A0 sqlpSetTID__FP8sqeAgentP11SQLP_TENTRYCb +
  0x3A0
  0x0900000020186088
  sqlpGetTEntryForApp__FP8sqeAgentCbPP11SQLP_TENTRY + 0x288
  0x09000000201867B0 sqlpsttr__FP8sqeAgent + 0x130
  0x0900000020059EAC sqlpAppStart__FP8sqeAgentiPi + 0x22C
  0x0900000020072DE8
  sqlpWriteNextLsnGapLrecIfRequired__FP14sqlpMasterDbcbP8sqeAgent
  + 0x568
  0x0900000020074AEC
  sqlpterm__FP16sqeLocalDatabaseP8sqeAgentP5sqlcaCUl + 0x188C
  0x090000001F5A224C CleanDB__16sqeLocalDatabaseFbP5sqlca + 0x12AC
  0x090000001F59B988
  ExecuteDBShutdown__16sqeLocalDatabaseFP8sqeAgentPbP5sqlcai +
  0x708
  0x090000001F58D2D0
  TermDbConnect__16sqeLocalDatabaseFP8sqeAgentP5sqlcai + 0x2B10
  0x090000001FC1356C
  AppStopUsing__14sqeApplicationFP8sqeAgentUcP5sqlca + 0x14EC
  

Local fix

• Fixed in fixpack inclusive of this APAR fix.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 11.1 Mod1 Fix Pack 1 iFix001                  *
  ****************************************************************
  

Problem conclusion

• First fixed in DB2 11.1 Mod1 Fix Pack 1 iFix001
  

Temporary fix

Comments

APAR Information

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

• 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