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.