|
Problem IC76487
|
Status: Closed |
DB2 CAN RETURN SQL0901N WHEN COMPILING SQL STATEMENTS ACCESSING TABLES WITH GENERATED COLUMNS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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 |
| Problem Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
The problem has been fixed in DB2 v9.7 Fix Pack 5. |
| Workaround |
Add the generated column to the SQL statement. |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC76640
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.05.2011
09.11.2011
09.11.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
