TEMPTAB_NOLOG configuration parameter
Use the TEMPTAB_NOLOG configuration parameter to disable logging on temporary tables.
- onconfig.std value
- TEMPTAB_NOLOG 0
- values
0
= Enable logical logging on temporary table operations1
= Disable logical logging on temporary table operations2
= Enable logical logging on temporary table operations for primary server and disable logical logging on temporary table operations for secondary servers(HDR, RSS and SDS).On primary/standard server: same behavior as
0
On secondary servers: same behavior as
1
- takes effect
- After you edit your onconfig file and restart the database server.
Usage
This parameter can improve performance in application programs because it prevents IBM® Informix® from transferring temporary tables over the network. The setting can be updated dynamically with the onmode -wf utility.
If you enable this setting, be aware that because no data is logged when using temporary tables, rolling back a transaction on a temporary table will no longer undo the work in the temporary table.
For HDR, RSS and SDS secondary servers in a high-availability cluster, logical logging on temporary tables should always be disabled by setting the TEMPTAB_NOLOG configuration parameter to 1 or 2.
When server type changes, logging for temporary tables will be enabled/disabled depending on the current server role. It will be effective for temporary tables created afterwards.