suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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)