|
Problem IC76487
|
Status: Geschlossen |
DB2 CAN RETURN SQL0901N WHEN COMPILING SQL STATEMENTS ACCESSING TABLES WITH GENERATED COLUMNS |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
DB2 can return SQL0901N when compiling SQL statements. The error
code contain the following message:
SQL0901N The SQL statement failed because of a non-severe
system error.
Subsequent SQL statements can be processed. (Reason "Bad Plan;
Unresolved QNC
found".) SQLSTATE=58004
The SQL statements should meet the following conditions:
1. The SQL statement access tables which contain generated
columns
2. The SQL statement has join predicates that reference the
columns on which the generated column is based
3. The generated column is not explictly referenced in the SQL
statement |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All users running DB2 v9.7 Fix Pack 4 and earlier *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 can return SQL0901N when compiling SQL statements. The *
* error *
* code contain the following message: *
* *
* *
* *
* SQL0901N The SQL statement failed because of a non-severe *
* *
* system error. *
* *
* Subsequent SQL statements can be processed. (Reason "Bad *
* Plan; *
* Unresolved QNC *
* *
* found".) SQLSTATE=58004 *
* *
* *
* *
* The SQL statements should meet the following conditions: *
* *
* *
* *
* 1. The SQL statement access tables which contain generated *
* *
* columns *
* *
* 2. The SQL statement has join predicates that reference the *
* *
* columns on which the generated column is based *
* *
* 3. The generated column is not explictly referenced in the *
* SQL *
* statement *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.7 Fix Pack 5. *
**************************************************************** |
| Local-Fix: |
Add the generated column to the SQL statement. |
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
The problem has been fixed in DB2 v9.7 Fix Pack 5. |
| Workaround |
Add the generated column to the SQL statement. |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC76640
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 19.05.2011
09.11.2011
09.11.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP5
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.5
|
 |
