IBM Support

IT31316: INTERMITTENT HANG IN SOCKET SELECT

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Intermittent hang in Text Search Extender in which no results
    are returned from the SQL query. Application status will be in
    "UOW-Executing" with nothing returned.
    
    Function stacks for DB2 co-ordinator agent will show hang in
    select:
    __select + 0x0033
    _ZN5ecmts3oss6Socket6selectERSt4listIS1_SaIS1_EES5_S5_PKm +
    0x0132
    _ZN5ecmts3oss6Socket7connectERKN7icu_3_213UnicodeStringEjRKNS1_1
    7_AddrInfoExternalEPKm + 0x089a
    _ZN5ecmts4comm13WhitneyClient4openEv + 0x0095
    _ZN5ecmts4comm16SutterPerfClient19sendAndRecvMesgOnceERNS0_13Cli
    entRequestERNS0_14ClientResponseE + 0x001b
    _ZN5ecmts4comm17WhitneyRESTClient15sendAndRecvMesgERNS0_13Client
    RequestERNS0_14ClientResponseE + 0x006c
    ...
    

Local fix

  • Restart DB2 instance during maintenance window to help avoid the
    hang.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Text Search Extenders                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade DB2 Server to v11.1 Mod 4 Fixpack 6                  *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 v11.1 Mod 4 Fixpack 6
    

Temporary fix

  • See LOCAL FIX
    

Comments

APAR Information

  • APAR number

    IT31316

  • 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

    2019-12-17

  • Closed date

    2021-03-29

  • Last modified date

    2021-03-29

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

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

    IT31448 IT31449

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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:
31 March 2021