IT36561: INFORMIX ODBC ERROR -11092 DRIVER NOT CAPABLE WHEN COMMITTING TRANSACTION

APAR status

• Closed as program error.

Error description

• The following error message may be seen when committing or
  rolling back a message flow transaction that involves an ODBC
  access to an Informix database:
  
  BIP2322E: Database error: SQL
  State 'HYC00'; Native Error Code '-11092'; Error Text
  '[Informix][Informix ODBC Driver]Driver not capable.'.
  
  This can occur if the Informix database does not have logging
  enabled. The solution is to enable logging.
  For example, create the database with a buffered log:
  CREATE <database> WITH BUFFERED LOG;
  
  However, it may not always be possible for a
  user to enable logging on an Informix database, particularly an
  old legacy database. Therefore this APAR will provide an
  environment variable option to allow the user to choose to
  ignore the -11092 Informix error when committing or rolling
  back a transaction, so that the system log does not get flooded
  with these errors.
  

Local fix

• Enable database logging if possible.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of IBM Integration Bus v10 and IBM App Connect
  Enterprise v11 and v12 using ODBC connectivity to Informix.
  
  
  Platforms affected:
  MultiPlatform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  The following error message may be seen when committing or
  rolling back a message flow transaction that involves an ODBC
  access to an Informix database:
  
  BIP2322E: Database error: SQL State 'HYC00'; Native Error Code
  '-11092'; Error Text '[Informix][Informix ODBC Driver]Driver not
  capable.'.
  
  This can occur if the Informix database does not have logging
  enabled. The solution is to enable logging.
  For example, create the database with a buffered log:
  
  CREATE <database> WITH BUFFERED LOG;
  
  However, it may not always be possible for a user to enable
  logging on an Informix database, particularly an old legacy
  database. Therefore this APAR will provide an environment
  variable option to allow the user to choose to ignore the -11092
  Informix error when committing or rolling back a transaction, so
  that the system log does not get flooded with these errors.
  

Problem conclusion

• A new environment variable MQSI_ODBC_INFORMIX_NO_TRXN_LOGGING
  has been added. If this environment variable is set to any
  value, the Informix native error -11092 will be ignored if
  returned for a failed ODBC commit or rollback.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v10.0      10.0.0.24
  v11.0      11.0.0.14
  v12.0      12.0.2.0
  
  The latest available maintenance can be obtained from:
  http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
  
  If the maintenance level is not yet available,information on
  its planned availability can be found on:
  http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
  ---------------------------------------------------------------
  

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

• Fixed component name

  INTEGRATION BUS

• Fixed component ID

  5724J0540

Applicable component levels