Re: Informix Log Tunning and ohter..

Umesh Patel wrote: > > Informix Guru- > > I have couple question about log files, log sizes and database layout: > 1) I have approx. 6 GB of database ( 2-3 GB of data inside ), how many > log files would be appropriate and what size. > Currently I have 30 MB physical log > and 220 MB logical log ( 10 MB per log with 22 log ). > Should I increase the size of logs as per recommended. We do not have > any problem with log get full during > routine transaction, the only time we had problem when we issue alter > table on big table. > The optimal size of your logical logs is really determined by the level of update activity on your server. You don't want to waste disk space, and increase archive/restore times, by having unnecessarily large logs, but you want them to be large enough so that: 1. They take a reasonable time all to fill. For example, if your site has no weekend cover, you want to make sure that, in the event of failure of log back-ups, your logs don't fill before you come in. 2. Users don't experience aborted transactions because of a lack of log size. If you could arrange to do your alter table out-of-hours, and switch off logging for the duration, you'll probably be OK. On the otheer hand, disk space is cheap. Neil Truby Chase Manhattan Bank Bournemouth, Uk