IC92034: WHEN INSERT CURSORS ARE ENABLED THE ODBC DRIVER MAY HANG IF ARRAY SIZE IS SET TO 1

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • You have defined a DSN using the Informix ODBC driver  and have
    enabled the feature "insert cursors" , in the DSN definition,
    setting the parameter ENABLEINSERTCURSORS, or via the API call
    
       SQLSetStmtAttr (hstm, SQL_ENABLE_INSERT_CURSOR,
    (SQLPOINTER)1, 0);
    
    A program using that DSN runs insert statements using arrays of
    parameters. If, after an insert of arrays of values having a
    size bigger than 1, the subsequent insert sets the size of the
    arrays to 1, as in the following fragment of code:
    
         SQLPrepare(hStmt, myInsertStatementWithPlaceholder,
    SQL_NTS);
    
         /*the arrays to be bound to the placeholders have 3 entries
    */
         SQLSetStmtAttr(hStmt, SQL_ATTR_PARAMSET_SIZE, 3, 0);
         ...
         SQLBindParameter() calls for each placeholder
         ...
         SQLExecute(hStmt);
    
         /*the arrays to be bound to the placeholder have one
    entry*/
         SQLSetStmtAttr(hStmt, SQL_ATTR_PARAMSET_SIZE, 1, 0);
         ...
         SQLBindParameter() calls for each placeholder
         ...
         SQLExecute(hStmt);   /*this call may hang*/
    
    then the program will hang while inside the second SQLExecute().
    This doesn't happen when the "insert cursors" feature is
    disabled, which is the default.
    

Local fix

  • Disable the "insert cursors" feature.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ODBC application with insert cursors enabled and array size  *
    * is set to 1                                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The ODBC driver hang during SQLExecute API call.             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Fix has gone into CSDK 370.XC8 and CSDK 410.XC2, upgrade     *
    * CSDK to this version or higher.                              *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC92034

  • Reported component name

    IBM CSDK

  • Reported component ID

    5724C2381

  • Reported release

    370

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-05-01

  • Closed date

    2014-02-26

  • Last modified date

    2014-02-26

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

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

Fix information

Applicable component levels

  • R370 PSN

       UP

  • R370 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Informix Tools
Informix Client Software Development Kit (CSDK)

Software version:

370

Reference #:

IC92034

Modified date:

2014-02-26

Translate my page

Machine Translation

Content navigation