DB2 - Problem description
Problem IT36380 | Status: Closed |
GET_CODEPAGE IS CALLED FOR EVERY PARAMETER MARKER WHICH CAUSED BAD PERFORMANCE IN DRDA WRAPPER | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
In Federation server, when the user querying a DRDA nickname where there are many char, varchar, or graphic columns in return list, or there are many parameter markers with type ofchar, varchar, or graphic, the performance might be bad, due to Wrapper_Utilities::get_codepage is called for each of these columns. From db2trc, you may find Wrapper_Utilities::get_codepage is called very frequently. Wrapper_Utilities::get_codepage The fix of this APAR reduces the number of calls of Wrapper_Utilities::get_codepage, from each call for a column, to a singal call for all columns. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * The users are running a DRDA wrapper. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 For LUW 11.5.6 or later versions. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * The users are running a DRDA wrapper. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 For LUW 11.5.6 or later versions. * **************************************************************** | |
Comment | |
This problem is firstly fixed on 11.5.6. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.03.2021 28.10.2021 28.10.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |