DB2 - Problem description
Problem IT18969 | Status: Closed |
TRAP WHEN RUNNING SELECT WITH WHERE IN CLAUSE ON TABLE WITH A FEW THOUSANDS PARTITIONS AND EXPLAIN MODE SET | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
The conditions required to hit this issue are: - A SELECT statement over a table with a huge number of partitions (around 1000 or more). - In the SELECT a WHERE IN clause with enough values to have around 500 partitions eliminated or more. - Before running the SELECT a 'db2 set current explain mode explain' should have been run. The stack will be corrupted (overwritten) but the rawstack dump will show ascii numbers similar to this: 0x0A000001B47F01D0 : 3832 382D 3833 332C 2038 3336 2D38 3337 828-833, 836-837 0x0A000001B47F01E0 : 2C20 3834 312C 2038 3434 2D38 3435 2C20 , 841, 844-845, 0x0A000001B47F01F0 : 3834 392D 3835 302C 2038 3532 2C20 3835 849-850, 852, 85 0x0A000001B47F0200 : 392D 3836 302C 2038 3639 2C20 3839 322C 9-860, 869, 892, 0x0A000001B47F0210 : 2038 3934 2C20 3839 392C 2039 3037 2D39 894, 899, 907-9 The stack trace should look like this: 0x09000000280ADA58 @137@sqlnx_exp_datapart_info__FP23sqlnx_exp_lolepop_parmsPUiPUcT 2PPcPi + 0x890 Stack traceback unavailable. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * NONE * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to * **************************************************************** | |
Local Fix: | |
The only way to avoid this is to avoid running with the 'explain mode' on. | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.01.2017 16.07.2018 16.07.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |