|
Problem IC80526
|
Status: Geschlossen |
COMPARING TIMESTAMP TYPE COLUMN WITH CHAR/VARCHAR TYPE HOST VARIABLE MAY GET SUBOPTIMAL QUERY PLAN IN V97 |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
When query statement includes a predicate comparing a TIMESTAMP
base table column with a host variable of type CHAR or VARCHAR,
a TIMESTAMP casting function may be added out of the host
variable, and that may cause the predicate to be not optimized
and evaluated very efficiently. That TIMESTAMP casting function
can be found in "Optimized Statement" section of db2exfmt
generated query plan. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fixpack 6 or later. *
**************************************************************** |
| Local-Fix: |
Change host variable type to TIMESTAMP. |
| 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 |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC84288
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 20.12.2011
14.06.2012
14.06.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP6
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.6
|
 |
