|
Problem IC76796
|
Status: Closed |
QUERY INVOLVING TYPED TABLES WITH MULTIPLE REFERENTIAL INTEGRITY CONSTRAINTS MIGHT FAIL WITH A SQL0901N ERROR |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
A query may fail with a SQL0901N error message if the following
conditions are true:
1. There are typed tables involved.
2. The typed table has multiple referential integrity (RI)
constraints associated with it.
3. The query is a select and has an outer join referencing the
typed table
4. The query does not reference all the columns from the typed
table which are involved in the multiple RIs,
i.e. some of the constraints are unreferenced in the query. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* A query may fail with a SQL0901N error message if the *
* following *
* conditions are true: *
* *
* 1. There are typed tables involved. *
* *
* 2. The typed table has multiple referential integrity (RI) *
* *
* constraints associated with it. *
* *
* 3. The query is a select and has an outer join referencing *
* the *
* typed table *
* *
* 4. The query does not reference all the columns from the *
* typed *
* table which are involved in the multiple RIs, *
* *
* i.e. some of the constraints are unreferenced in the *
* query. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.7 FixPak 5 *
**************************************************************** |
| Local Fix: |
Rewrite the query to reference the unused columns in the query |
| 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 |
First fixed in DB2 v9.7 FixPak 5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.06.2011
06.02.2012
06.02.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
