RE: Logical Logs Size
Fred 30 Gb seems rather large for total log space (in fact almost 19 Gb seems large). What is the size of your database? How quickly are you using the logs? What are your Long transaction limits set to? How often do you hit this long transaction? Can you (should you) split theses transactions into smaller success units? Is a transaction being started and held open but nothing done causing the roll-back? As a start point I would set each log to handle the work done in 50 - 60 minutes of average engine activity and to have enough logs to hold 24 hours of activity. Keith -> -----Original Message----- -> From: oxow@yahoo.com [mailto:oxow@yahoo.com] -> Sent: Wednesday, July 23, 2003 11:29 AM -> To: informix-list@iiug.org -> Subject: Logical Logs Size -> -> -> Hi, -> -> Well, in order to avoid amongother things several Long transactions -> aborded, I have decided to increase to size of the logical logs. -> -> This is what the actual configuration is : -> Total Logs Size : 18957068 KB -> Logs Number : 375 -> 35 Logs of 15000 KB -> 340 Logs of 50000 KB -> -> This is what I want to do : -> Total Logs Size : 30720000 KB -> Logs Number : 200 -> Size of one Log :153600 KB -> -> So could I know what you are thinking of this new configuration ? -> Any comment is welcome. -> -> I will really appreciate if you would answered me. -> Thxs a lot in advance. -> -> Best Regards -> Fred -> ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ********************************************************************************** sending to informix-list