Re: How many logical log is needed

Posted in 2000

Obnoxio The Clown — Sat, 15 Jul 2000 12:29:56 BST — source: Informix-list mailing list archive (1991-1998)

From: JasonYLPang@pg.SLR.com > >The size of database is around 40G. Currently, I have 100 logical log with >each log 20MB (Total is 2G). Is my logical log size sufficient to support >my >database? Recently, I'm facing a lot of long transaction. Is it because of >insufficient logical log?? I couldn't tell based on the size of your database and the size of your logs whether you have sufficient space. However, the fact that you're getting lots of long transaction rollbacks hints that you don't have enough log space. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com