Re: Longtx transaction log help
Posted in 2005
Jean Sagi — — source: Usenet: comp.databases.informix
It will speed the load process. Once the data is up a level 0 archive enables logs again, is just for faster loading of data. J. Neil Truby wrote: > "Jean Sagi" <jeansagi@myrealbox.com> wrote in message > news:1114277905.df63baa2cee2a38df035e605293a4c3f@teranews... > >>You could also redirect the logs and backup device to /dev/null and let >>IDS to automatically backup them. >> > > > Yeah, you could, but discarding the logs in this way will not help him one > iota with a long transaction issue. > Paul Mosser's remedy - temporarily change the logging mode of the database - > is spot on. > > Neil Truby > Ardenta Limited > > > sending to informix-list