Informix MACH11: How to change default logging behavior for temp tables -- Posted by inturi on Thursday, March 13 2008
IDS always logs the explicit temp tables -- temp tables created using "create temp table" or "select into temp" syntax-- unless u specify "with no log" option. Internal temp tables -- created due to sorting or grouping-- are always created with no log option.

This can be a problem for MACH11 applications running at secondary servers.

You cannot create logging temp tables at MACH11 secondary servers (HDR, SDS and RSS).

To avoid application recompilation to change the explicit temp table default logging mode, set the following onconfig paramter. This changes the default logging mode for explicit temp tables to non-logging.

TEMPTAB_NOLOG 1