|
Problem IC84288
|
Status: Closed |
COMPARING TIMESTAMP TYPE COLUMN WITH CHAR/VARCHAR TYPE HOST VARIABLE MAY GET SUBOPTIMAL QUERY PLAN IN V97 |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
Problem was first fixed in DB2 UDB Version 10.1 FixPack 1. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.06.2012
05.11.2012
05.11.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
