|
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) |
