DB2 - Problem description
Problem IT39524 | Status: Closed |
DB2 SERVER MAY TERMINATE ABNORMALLY WHEN USING SUBSTR | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
Issuing a query with substr may cause the Db2 server to terminate abnormally. The stack looks similar to this example from Linux: 0x00007F536F25757D _Z18psmBindoutCompleteP14db2UCinterface + 0x001d 0x00007F536F24E00E _Z28sqlribnoCbToZValueExecutePsmP14db2UCinterface + 0x1b4e 0x00007F536EF044DB address: 0x00007F536EF044DB ; dladdress: 0x00007F5366F75000 ; offset in lib: 0x0000000007F8F4DB ; 0x00007F536EF04019 _Z8sqlribnoP8sqlrr_cb + 0x0079 0x00007F536F087E1D _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x04bd 0x00007F536EA960EE _Z29sqlrr_process_execute_requestP8sqlrr_cbib + 0x0f5e 0x00007F536EA6B9D3 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x02a3 0x00007F5368C4555F _ZN10pvmPackage14executeSectionEP5sqlcajb + 0x08bf 0x00007F5368C44C01 _ZN3PVM12executeQueryEjb + 0x0101 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * **************************************************************** * PROBLEM DESCRIPTION: * **************************************************************** * RECOMMENDATION: * * The issue fixed in 11.1.4.7 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * **************************************************************** * PROBLEM DESCRIPTION: * **************************************************************** * RECOMMENDATION: * * The issue fixed in 11.1.4.7 * **************************************************************** | |
Comment | |
The issue fixed in 11.1.4.7 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 30.12.2021 10.03.2022 17.04.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |