|
Problem IC65905
|
Status: Geschlossen |
INCORRECT RESULTS DUE TO WRONG TQ OPERATION PRODUCED BY NODENUMBER/DBPARTITIONNUM SCALAR FUNCTION. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problembeschreibung: |
A query with nodenumber/dbpartitionnum scalar function might
return incorrect results. The query may fail to collect rows
from
specified database partition(s) if all the following conditions
are met:
1. The query involves a UNION (could also be via view with
union or full outer join which the compiler will generate a
union for)
2. At least one branch below the UNION applies a NODENUMBER or
DBPARTITIONNUM function
3. There is a DTQ below the UNION (in db2exfmt output), and the
details of the DTQ in the db2exfmt output shows the following:
Output Streams:
--------------
...
Partitioning: (FUNC )
NODENUMBER() or PARTITION() directed to Single
Partition
...
Partition Column Names:
----------------------
+NONE |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Users who use nodenumber/dbpartitionnum scalar function in *
* DPF environment. *
****************************************************************
* PROBLEM DESCRIPTION: *
* A query with nodenumber/dbpartitionnum scalar function might *
* *
* return incorrect results. The query may fail to collect rows *
* *
* from *
* *
* specified database partition(s) if all the following *
* conditions *
* are met: *
* *
* *
* *
* 1. The query involves a UNION (could also be via view with *
* *
* union or full outer join which the compiler will generate a *
* *
* union for) *
* *
* 2. At least one branch below the UNION applies a NODENUMBER *
* or *
* DBPARTITIONNUM function *
* *
* 3. There is a DTQ below the UNION (in db2exfmt output), and *
* the *
* details of the DTQ in the db2exfmt output shows the *
* following: *
* *
* *
* Output Streams: *
* *
* -------------- *
* *
* ... *
* *
* Partitioning: (FUNC ) *
* *
* NODENUMBER() or PARTITION() directed to Single *
* *
* Partition *
* *
* ... *
* *
* Partition Column Names: *
* *
* ---------------------- *
* *
* +NONE *
****************************************************************
* RECOMMENDATION: *
* Please apply v9.1 Fix Pack 9 or later. *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Lösung |
Problem was first fixed in Version 9.1 Fix Pack 9 (s100326). |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 27.01.2010
07.05.2010
07.05.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.1.FP9
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.9
|
 |
