|
Problem IC82127
|
Status: Geschlossen |
SECTION ACTUALS VALUES MIGHT BE INCORRECT IN FEDERATED SYSTEM |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
The section actuals values might be incorrect in federated
system. You can confirm this by comparing the section actuals
with the output of count queries. For example, let us consider
the following SQL:
SELECT COL1, COL2
FROM TAB1, TAB2
WHERE TAB1.COL = TAB2.COL AND COL1 > 9;
The section actuals are shown in access plan ( db2exfmt output )
as follows:
Rows
Rows Actual
RETURN
( 1)
Cost
I/O
|
5
8
HSJOIN
( 2)
32.35
2
/-------+-------\
5 50
10 50
TBSCAN TBSCAN
( 3) ( 4)
12.57 12.57
1 1
| |
50 50
NA NA
TABLE: SCHEMA1 TABLE: SCHEMA1
TAB1 TAB2
Here, optimizer had estimated 5 rows satisfying the condition
'COL1 > 9', but section actuals suggest that there were actually
10 rows.
In order to confirm the correctness of section actuals, the
following count query can be used for this example:
SELECT COUNT(*) AS CNT_GT_9
FROM TAB1
WHERE COL1 > 9;
Here, if value of CNT_GT_9 is not 10 then section actual value
for plan operator TBSCAN(3) is incorrect. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* FEDERATED SYSTEM USERS *
****************************************************************
* PROBLEM DESCRIPTION: *
* The section actual values might be incorrect. It can be *
* confirmed by using appropriate count queries as described in *
* "Error Description" section. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 9.7 Fix Pack 6 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
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 |
Fixed in DB2 9.7 Fix Pack 6 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 20.03.2012
05.06.2012
05.06.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP6
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.6
|
 |
