IBM Support

IC85512: TRAP CALLING SQLEXECUTE FOR AN INSERT STATEMENT FOR A DB2 FOR Z/OS DATABASE.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error 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.
    

Local fix

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                                 *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC85512

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    970

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-07-25

  • Closed date

    2012-10-24

  • Last modified date

    2012-10-24

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC85627

Fix information

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC85512

Modified date: 24 October 2012