DB2 - Problem description
Problem IT31448 | Status: Closed |
INTERMITTENT HANG IN SOCKET SELECT | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem 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 ... | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 10.5 Fix Pack 11 or higher * **************************************************************** | |
Local Fix: | |
Restart DB2 instance during maintenance window to help avoid the hang. | |
Solution | |
Workaround | |
See LOCAL FIX. | |
BUG-Tracking | |
forerunner : IT31316 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.01.2020 25.02.2020 25.02.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |