DB2 - Problem description
Problem IT36571 | Status: Closed |
GET_CODEPAGE IS CALLED FOR EVERY PARAMETER MARKER WHICH CAUSED BAD PERFORMANCE IN DRDA WRAPPER | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - 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: * * N/A * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Refer to APAR IT36380 for the version includes the fix. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * N/A * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Refer to APAR IT36380 for the version includes the fix. * **************************************************************** | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.04.2021 06.07.2021 06.07.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |