suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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)