IFX_XASTDCOMPLIANCE_XAEND

In earlier releases of IBM Informix database servers, an internal rollback of a global transaction freed the transaction. In releases later than XPS 8.40 and IDS 9.40, however, the default behavior after an internal rollback is not to free the global transaction until an explicit rollback, as required by the X/Open XA standard. By setting the DISABLE_B162428_XA_FIX configuration parameter to 1, you can restore the legacy behavior as the default for all sessions.

The IFX_XASTDCOMPLIANCE_XAEND environment variable can override the configuration parameter for the current session, using the following syntax. Valid IFX_XASTDCOMPLIANCE_XAEND values are 1 and 0.

>>-setenv--IFX_XASTDCOMPLIANCE_XAEND--+-1-+--------------------><
                                      '-0-'
 

0

Frees global transactions only after an explicit rollback

1

Frees global transactions after any rollback

This environment variable can be particularly useful when the server instance is disabled for new behaviour by the DISABLE_B162428_XA_FIX configuration parameter, but one client requires the new behaviour. Setting this environment varable to zero supports the new behaviour in the current session.