IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    IT19781

  • 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-03-20

  • Closed date

    2017-05-01

  • Last modified date

    2017-05-01

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
29 June 2020