DB2 - Problem description
Problem IT24602 | Status: Closed |
CREATING NEW CONNECTIONS BETWEEN MEMBER AND CACHING FACILITY ON PURESCALE CAN FAIL WITH A TIMEOUT ON OFED ROCE STACK | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
In a Purescale cluster using Ofed Roce for remote direct memory access between members and cf's for communication. The default timeout value can be too low in some cases. A new connection creation can timeout with the following error message in the db2diag.log : 2018-02-09-15.11.49.110761-300 I26314779E698 LEVEL: Severe PID : 187214 TID : 140204891432704 PROC : db2sysc 0 INSTANCE: inst NODE : 000 DB : dbname APPHDL : 0-19404 APPID: 159.247.84.225.58036.180209201316 AUTHID : auth1 HOSTNAME: hosta EDUID : 1119 EDUNAME: db2agent (dbname) 0 FUNCTION: DB2 UDB, RAS/PD component, pdLogCaPrintf, probe:876 DATA #1 : PsConnect: cmd_connect failed: 0x80090029 DATA #1 : If a CF return code is displayed above and you wish to get more information then please run the following command: db2diag -cfrc 2018-02-09-15.11.49.111499-300 I26315478E1142 LEVEL: Severe PID : 187214 TID : 140204891432704 PROC : db2sysc 0 INSTANCE: inst NODE : 000 DB : dbname APPHDL : 0-19404 APPID: 159.247.84.225.58036.180209201316 AUTHID : hosta HOSTNAME: hosta EDUID : 1119 EDUNAME: db2agent (dbname) 0 FUNCTION: DB2 UDB, Shared Data Structure Abstraction Layer for CF, SQLE_CA_CONN_ENTRY_DATA::sqleCaCeConnect, probe:790 MESSAGE : CA RC= 2148073513 DATA #1 : String, 17 bytes PsConnect failed. DATA #2 : Connection pool link adapter number, PD_TYPE_SAL_ADAPTER_NUMBER, 8 bytes 3 DATA #3 : PsToken_t, PD_TYPE_SD_PSTOKEN, 152 bytes Eye Catcher = CATOKEN CF Server Info : - Unique Sequence Number = 4947 (0x1353) - Port Number = 56001 - Node Identifier = 1 - Instance Identifier = 0 - Netname = netname1 Local Member Info : - Device Name = ofa-v2-roe1 Transport Type = UDAPL (0x1) Cmd Connection Use Types = NORMAL (0x0) DATA #4 : unsigned integer, 8 bytes 2 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 10.5 Fix Pack 10 or higher * **************************************************************** | |
Local Fix: | |
db2stop db2set DB2_SAL_INITIAL_TIMEOUT_FOR_CONNECT_SEC=10 db2set DB2_SAL_CONNECT_MAX_TIMEOUT=20 db2start | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.04.2018 19.07.2018 19.07.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |