DB2 - Problembeschreibung
Problem IC85627 | Status: Geschlossen |
TRAP CALLING SQLEXECUTE FOR AN INSERT STATEMENT FOR A DB2 FOR Z/OS DATABASE. | |
Produkt: | |
DB2 CONNECT / DB2CONNCT / A10 - DB2 | |
Problembeschreibung: | |
Applications might trap while calling CLI (Call Level Interface) API function SQLExecute to issue an INSERT statement. It happens when an application calls SQLExecute for an INSERT statement if the application has previously called SQLExendedBind with the value of the rgbValue parameter as NULL. When the trap occurs, at the top of the function stack are these functions: SQLExecute2 SQLExecute The trap occurs only if the application is using Multi-Row Insert. Only CLI applications that are connected to DB2 for z/OS database can use Multi-Row Insert, so only applications that connect to a DB2 for z/OS database can get this trap. Applications use Multi-Row Insert by setting the CLI connection attribute or CLI statement attribute SQL_ATTR_COLUMNWISE_MRI toSQL_COLUMNWISE_MRI_ON. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * CLI users using MRI feature against zDB2. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.1.1 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows | |
Lösung | |
From v10.1 FP1 if the user binds the rgbValue to NULL in the loop while using MRI won't trap. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 31.07.2012 02.11.2012 02.11.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.1 | |
10.5.0.1 |