DB2 - Problem description
Problem IT40660 | Status: Closed |
DB2START FAILS WITH SQLE_SAL_MIXED_TRANSPORTS_ERROR WHEN ONE OF THE RDMA ADAPTERS ON THE HOST IS IN UNKNOWN STATE | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Following error will be logged in db2diag.log. 2022-01-10-13.09.04.605273+540 E5203928A1016 LEVEL: Error PID : 47317872 TID : 1 PROC : db2star2 INSTANCE: db2inst1 NODE : 001 HOSTNAME: host1 EDUID : 1 FUNCTION: DB2 UDB, Shared Data Structure Abstraction Layer for CF, sqleCAGetTransportMethod, probe:683 MESSAGE : ZRC=0x87270183=-2027486845=SQLE_SAL_MIXED_TRANSPORTS_ERROR "Netname adapters are of mixed transport types. All adapters must be configured for either RDMA or TCP." DATA #1 : String, 61 bytes The netnames specified in db2nodes.cfg are not the same type. DATA #2 : Codepath, 8 bytes 18:22 DATA #3 : unsigned integer, 8 bytes 2 DATA #4 : unsigned integer, 8 bytes 1 DATA #5 : unsigned integer, 4 bytes 2 DATA #6 : unsigned integer, 4 bytes 1 CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x090000003E290670 sqleCAGetTransportMethod + 0x18C0 [1] 0x000000010000718C DB2StartMain + 0x63DC [2] 0x00000001000002F8 __start + 0x70 2022-01-10-13.09.04.605827+540 I5204945A515 LEVEL: Error PID : 47317872 TID : 1 PROC : db2star2 INSTANCE: db2inst1 NODE : 001 HOSTNAME: host1 EDUID : 1 FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:4482 MESSAGE : ZRC=0x87270183=-2027486845=SQLE_SAL_MIXED_TRANSPORTS_ERROR "Netname adapters are of mixed transport types. All adapters must be configured for either RDMA or TCP." DATA #1 : String, 34 bytes Failed to determine transport type The reason is because the problematic RDMA adapter will be detected as using the Socket transport type. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Db2 pureScale * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 Version 11.5.8 (Mod 8 Fix Pack 0) * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Db2 pureScale * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 Version 11.5.8 (Mod 8 Fix Pack 0) * **************************************************************** | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.04.2022 21.04.2022 21.04.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |