Re: Transaction log files in a SE database

In article <42kf2d$jbe@news.wwa.com> john@miso.wwa.com "pinoy_ako" writes: > Hi, > I was browsing through the manual and saw the "START DATABASE" > sql command. It says there that if you put a filename, that > filename will be the transaction log. I have two questions about > the transaction log file. > > 1. Does the transaction log file record the unload and load > statements or just the insert/delete/update statements? > (We do full unload of all tables every night) unload will never get recorded as it doesn't alter the database. load may get recorded depending on the table being loaded. > 2. After creating a transaction log file and deciding later we > don't want it anymore, would this work the same way as if > we didn't have any transaction log file to begin with? > > START DATABASE xyz WITH LOG IN "/dev/null" This may work, but we update the 'tabtype' in systables from 'L' to 'Z' to turn off transaction logging. You can also delete the 'syslog' row. You have to 'su' to informix to do this sort of thing. -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================