|
Problem IC76640
|
Status: Geschlossen |
DB2 CAN RETURN SQL0901N WHEN COMPILING SQL STATEMENTS ACCESSING TABLES WITH GENERATED COLUMNS |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - 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.5 *
****************************************************************
* 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 FP5. *
**************************************************************** |
| Local-Fix: |
Add the generated column to the SQL statement. |
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 26.05.2011
31.05.2011
31.05.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP5
|
| Problem behoben lt. FixList in der Version |
