Re: Logical Logs

Posted in 1996

Richard Ridley — 19 Apr 1996 22:03:08 -0400 — source: Informix-list mailing list archive (1991-1998)

Dave writes: > Can anybody tell me an easier method for changing th logfile size on > I-Online 5.x than unloading the whole database and reloading it with a > new size? When we went through and redesigned the dbspaces and table > distribution, we brought the system back up with very small log files. > This is killing us with long transaction aborts. Can anybody help? > Thanks, > > Dave You say you are having problems with long transaction aborts - this is probably due to the total size of your combined logical logs, (and your LTXHWM and LTXEHWM parameters) rather than the individual log file size. We had one site recently that had 4 logical log files, each with a size of 20 MB ! As you can imagine, this did not help performance any :) Hope this helps, Richard Ridley DHL Asia Pacific