|
Problem IC76122
|
Status: Geschlossen |
FED: A QUERY INVOLVING INSERT/UPDATE/DELETE IN DPF MODE CAN RETURN A SQL0901N "EMPTY PLAN LIST" ERROR |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
A query involving insert/update/delete in DPF mode can return a
SQL0901N error with message "Empty plan list detected".
Example:
INSERT INTO T1 (INFO)
(SELECT INFO
FROM T2 w
JOIN
T3 e
ON(w.EMP_ID=e.EMP_ID)
WHERE
NOT EXISTS ( SELECT '1'
FROM N1 m
WHERE m.ID = w.ID
)
ORDER BY CD, ID ASC);
DB21034E The command was processed as an SQL statement because
it was not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0901N The SQL statement failed because of a non-severe
system error.
Subsequent SQL statements can be processed. (Reason "Empty plan
list
detected!".) SQLSTATE=58004 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* all platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* A query involving insert/update/delete in DPF mode can *
* return a *
* SQL0901N error with message "Empty plan list detected". *
* *
* *
* *
* *
* *
* Example: *
* *
* *
* *
* INSERT INTO T1 (INFO) *
* *
* (SELECT INFO *
* *
* FROM T2 w *
* *
* JOIN *
* *
* T3 e *
* *
* ON(w.EMP_ID=e.EMP_ID) *
* *
* WHERE *
* *
* NOT EXISTS ( SELECT '1' *
* *
* FROM N1 m *
* *
* WHERE m.ID = w.ID *
* *
* ) *
* *
* ORDER BY CD, ID ASC); *
* *
* DB21034E The command was processed as an SQL statement *
* because *
* it was not a *
* *
* valid Command Line Processor command. During SQL processing *
* it *
* returned: *
* *
* SQL0901N The SQL statement failed because of a non-severe *
* *
* system error. *
* *
* Subsequent SQL statements can be processed. (Reason "Empty *
* plan *
* list *
* *
* detected!".) SQLSTATE=58004 *
****************************************************************
* RECOMMENDATION: *
* upgrade to version 9.5.9 *
**************************************************************** |
| Local-Fix: |
Use cursor to do the insert/update/delete |
| verfügbare FixPacks: |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
v95 fp 9
Customer won't see the error of "Empty plan list" |
| Workaround |
n/a |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 02.05.2011
12.07.2011
12.07.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.9,
9.5.FP9
|
| Problem behoben lt. FixList in der Version |
| 9.5.0.9
|
 |
