|
Problem IC85512
|
Status: Closed |
TRAP CALLING SQLEXECUTE FOR AN INSERT STATEMENT FOR A DB2 FOR Z/OS DATABASE. |
| product: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* CLI users connecting to host database with MRI feature *
* turned on. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB@ version 9.7.7 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 7 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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC85627
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.07.2012
24.10.2012
24.10.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
