DB2 - Problembeschreibung
Problem IC66499 | Status: Geschlossen |
Query against a parameterized based table may incorrectly return SQL0100W if the same statement failed previously. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
Query against a parameterized based table may incorrectly return SQL0100W if the same statement failed previously. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC66514 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 19.02.2010 14.06.2010 14.06.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
9.7.0.2 |