|
Problem IC76796
|
Status: Geschlossen |
QUERY INVOLVING TYPED TABLES WITH MULTIPLE REFERENTIAL INTEGRITY CONSTRAINTS MIGHT FAIL WITH A SQL0901N ERROR |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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 |
| 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 |
First fixed in DB2 v9.7 FixPak 5 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 04.06.2011
06.02.2012
06.02.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.5
|
 |
