|
Problem IC84288
|
Status: Geschlossen |
COMPARING TIMESTAMP TYPE COLUMN WITH CHAR/VARCHAR TYPE HOST VARIABLE MAY GET SUBOPTIMAL QUERY PLAN IN V97 |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - 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: *
* DB2 UDB Version v10.1 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 10.1 FixPack 1. *
**************************************************************** |
| Local-Fix: |
Change host variable type to TIMESTAMP. |
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
Problem was first fixed in DB2 UDB Version 10.1 FixPack 1. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 13.06.2012
05.11.2012
05.11.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
