Re: Transaction log grows w/o transactions

Peter Levine (peterl@minerva.robadome.com) wrote: : I've noticed that the transaction log of our SE 4.1 engine increases : when there is apparently no database activity occurring. : The timestamp on the transaction log is more current than the : timestamps on amy of the .dat or .idx files which comprise the : database and I've seen the byte count grow as well. : Whats going on? Transient files (temporary tables) are in some cases recorded in the transaction log too. For example, a "SELECT ... INTO TEMP sel_temp" will generate log records (but not "SELECT ... INTO TEMP sel_temp WITH NO LOG"). If you want to investigate, use the SE dblog utility to display log records since your last apparent database activity. If temporary tables are being created, you will se the build (BU) and erase (ER) records for them, with pathnames in the DBTEMP directory. -Jeff