Re: Logical Logs Size

What about the following : onstat -l (LOGBUFF will be shown here)What log mode on the database (Buffered, Unbuffered, None) Version of IDS O/S running on Are temp tables in use?? Do you have temp dbspaces?? Do you use into temp with no log?? Some of the online log that shows log fill rate and checkpoint rate? Humm haa, No potatoe ;) Simmons, Keith wrote: > 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