Joni, There's a stat of cumulative log consumption that can be seen with Q LOG F=D, and can be reset with RESET LOGCONSUMPTION
I'm not sure how this works in normal mode - I use rollforward - but it might be worth a look. Let us know how it turns out. Steve Harris AIX and TSM Admin Queensland Health, Brisbane Australia >>> [EMAIL PROTECTED] 23/07/2002 21:57:03 >>> Hello everyone! I was just wondering if anyone has strong opinions about which mode to use for the log: rollforward or normal? And also, would anyone happen to know how much space I would have to add if I changed to rollforward mode? My log is 2324 MB and the database is 41832 MB. I was also wondering if it is a common practice to have the log be 10% the size of the database? Thanks in advance for any insight!!! Joni Moyer Associate Systems Programmer [EMAIL PROTECTED] (717)975-8338 ********************************************************************** This e-mail, including any attachments sent with it, is confidential and for the sole use of the intended recipient(s). This confidentiality is not waived or lost if you receive it and you are not the intended recipient(s), or if it is transmitted/ received in error. Any unauthorised use, alteration, disclosure, distribution or review of this e-mail is prohibited. It may be subject to a statutory duty of confidentiality if it relates to health service matters. If you are not the intended recipient(s), or if you have received this e-mail in error, you are asked to immediately notify the sender by telephone or by return e-mail. You should also delete this e-mail message and destroy any hard copies produced. **********************************************************************
