|
Problem IC66499
|
Status: Closed |
Query against a parameterized based table may incorrectly return SQL0100W if the same statement failed previously. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
If you have a SELECT/UPDATE/DELETE query against a
PARAMETERIZED BASE TABLE, and if it is using parameter markers
in the WHERE clause,
then it is possible to get an incorrect SQL0100W back.
(Subsequent execution of the same sql will work properly)
This can only happen if a previous execution of the same
statement
resulted in an error, such as a rollback due to a lock timeout
or
any other query failure.
Having db2set DB2_UNION_OPTIMIZATION='PARAMETERIZE FORCE' will
increase likelihood of this issue. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* users of parameterized tables *
****************************************************************
* PROBLEM DESCRIPTION: *
* Query against a parameterized based table may *
* incorrectlyreturn SQL0100W if the same statement failed *
* previously. *
****************************************************************
* RECOMMENDATION: *
* Install this APAR *
**************************************************************** |
| Local Fix: |
Use literals instead of parameter markers. Unset
DB2_UNION_OPTIMIZATION. Check SQL0100W - re-execute to double
check. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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 9a 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 10 for Linux, UNIX, and Windows
|
| Solution |
Query against a parameterized based table may incorrectly
return SQL0100W if the same statement failed previously. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC66514
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.02.2010
14.06.2010
14.06.2010 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
