DB2 - Problem description
Problem IT39482 | Status: Closed |
DB2 SERVER MAY TERMINATE ABNORMALLY ISSUING ILLEGAL SQL STATEMENT | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
The Db2 server may terminate abnormally when preparing certain illegal SQL statements. The stacks similar to the following: 0x000003FF88AACBC4 sqloEDUCodeTrapHandler + 0x04ac (/home/btwp3/sqllib/lib64/libdb2e.so.1) 0x000003FACD009B78 address: 0x3facd009b78 0x000003FF87CFF030 _ZNK9sqlnq_pid11fixed_valueEPiS0_PPS_S0_S0_ + 0x0070 (/home/btwp3/sqllib/lib64/libdb2e.so.1) 0x000003FF87D3FB76 _Z21sqlnq_process_gb_itemPP9sqlnq_pidP9sqlnq_quniP3loc + 0x06f2 (/home/btwp3/sqllib/lib64/libdb2e.so.1) 0x000003FF87BCDDB0 _Z25sqlnq_sem_group_by_clausePP8stknode_i10actiontypePhP3loc + 0x0534 (/home/btwp3/sqllib/lib64/libdb2e.so.1) 0x000003FF87A6D722 _Z12sqlnp_smactnP8sqlnp_cbi + 0x137a (/home/btwp3/sqllib/lib64/libdb2e.so.1) 0x000003FF87A584EE _Z12sqlnp_parserP8sqlnp_cb + 0x05ce (/home/btwp3/sqllib/lib64/libdb2e.so.1) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 version 11.1.4.7 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 version 11.1.4.7 * **************************************************************** | |
Comment | |
First fixed in Db2 version 11.1.4.7 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 21.12.2021 17.04.2022 17.04.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |