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

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