Disable logging on temporary tables

You can disable logging on temporary tables to improve performance and to prevent IBM® Informix® from transferring temporary tables when using a primary server in a data replication environment such as with HDR secondary, RS secondary, and SD secondary servers.

To disable logging on temporary tables, set the TEMPTAB_NOLOG configuration parameter to 1.

For HDR, RSS, and SDS secondary servers in a high-availability cluster, logical logging on temporary tables must always be disabled by setting the TEMPTAB_NOLOG configuration parameter to 1 or 2.

You can use the onmode -wf command to change the value of TEMPTAB_NOLOG.