|
Problem IT09046
|
Status: Geschlossen |
DB2 MIGHT CRASH WHILE COMPILING A QUERY REFERENCING COLUMN-ORGANIZED TABLES AND MULTIPLE COMMON SUBEXPRESSIONS. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.5 Fix Pack 7 *
**************************************************************** |
| Local-Fix: |
|
| Lösung |
First fixed in DB2 Version 10.5 Fix Pack 7 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 21.05.2015
29.01.2016
29.01.2016 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.7
|
 |
