DB2 - Problem description
Problem IT33421 | Status: Closed |
SQLGETCONNECTATTR() FUNCTION CALL WITH SQL_ATTR_GET_LATEST_MEMBER_NAME TAKING TIME DUE TO GETADDRINFO TAKING MORE TIME | |
product: | |
DB2 CONNECT / DB2CONNCT / B50 - DB2 | |
Problem description: | |
SQLGetConnectAttrW api with SQL_ATTR_GET_LATEST_MEMBER_NAME option takes upto 6ms while it takes .4 ms or even lesser in good case. [1561643972.281175 - 06/27/2019 13:59:32.281175] 49715 SQLGetConnectAttrW( hDbc=0:1, fOption=SQL_ATTR_GET_LATEST_MEMBER_NAME, pvParam=&0fffffffffff5910, cbParamMax=64, pcbParam=&0fffffffffff5840 ) [1561643972.287257 - 06/27/2019 13:59:32.287257] SQLGetConnectAttrW( pvParam="MLT3", pcbParam=8 ) 49826 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * **************************************************************** * PROBLEM DESCRIPTION: * **************************************************************** * RECOMMENDATION: * * Upgrade to v11.4.5.0. * **************************************************************** | |
Local Fix: | |
Use the IP address or put the hostname to ip resolution in /etc/hosts | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * **************************************************************** * PROBLEM DESCRIPTION: * **************************************************************** * RECOMMENDATION: * * Upgrade to v11.4.5.0. * **************************************************************** | |
Comment | |
Upgrade to v11.4.5.0. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.07.2020 03.07.2020 28.07.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |