|
Problem IT09046
|
Status: Closed |
DB2 MIGHT CRASH WHILE COMPILING A QUERY REFERENCING COLUMN-ORGANIZED TABLES AND MULTIPLE COMMON SUBEXPRESSIONS. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
DB2 might crash while compiling a query referencing
column-organized tables and multiple common subexpressions.
The db2diag.log shows a trap entry with Signal #11
2015-02-18-16.16.14.403524-300 E5480023A1266 LEVEL:
Severe
PID : 9175708 TID : 55002 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-79 APPID:
*LOCAL.db2inst1.150218211523
AUTHID : DB2INST1 HOSTNAME: host1
EDUID : 55002 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler,
probe:90
MESSAGE : ADM14011C A critical failure has caused the following
type of error:
"Trap". The DB2 database manager cannot recover from
the failure.
First Occurrence Data Capture (FODC) was invoked in
the following
mode: "Automatic". FODC diagnostic information is
located in the
following directory:
"/db2diag/db2inst1/FODC_Trap_2015-02-18-16.15.38.196282_0000/".
DATA #1 : Signal Number Recieved, 4 bytes
11
DATA #2 : Siginfo, 64 bytes
0x0700001BFA00EDC0 : 0000 000B 0000 0000 0000 0033 0000 0000
...........3....
0x0700001BFA00EDD0 : 0000 0000 0000 0000 0000 0000 0000 0098
................
0x0700001BFA00EDE0 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x0700001BFA00EDF0 : 0000 0000 0000 0000 0000 0000 0000 0000
................
The trap file will contain the following stack trace:
0 sqlnoSmpPlanPass
1 sqlnoSmpPlanPass
2 sqlnoSmpPlanPass
3 sqlnoSmpPlanPass
4 sqlnoSmpPlanPass
5 sqlnoSmpPlanPass
6 sqlnoSmpPlanPass
7 sqlnoSmpPlanPass
8 sqlnoSmpPlanPass
9 sqlnoSmpPlanPass
10 sqlnoSmpPlanPass
11 sqlnoSmpPlanPass
12 sqlnoSmpPlanPass
13 sqlnoSmpPlanPass
14 sqlnoSmpPlanPass
15 sqlnoSmpPlanPass
16 sqlnoSmpPlanPass
17 sqlnoSmpPlanPass
18 sqlnoSmpPlanPass
19 sqlnoSmpPlanPass |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.5 Fix Pack 7 *
**************************************************************** |
| Local Fix: |
|
| Solution |
First fixed in DB2 Version 10.5 Fix Pack 7 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.05.2015
29.01.2016
29.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
