Hi, There seems to be hell of a lot of log archiving going on , and am I wondering if it's because it has been set up incorrectly. I currently have two methods of log archiving
1) The databases were enabled for rollforward recovery using the user exit parameter, where by full logfiles are automatically archived by TSM. 2) I was later asked to archive the logs on an hourly basis(to TSM). To achieve this I used DB2 Task Center to set up hourly schedules. The command script is as follows :- "UPDATE DB CFG FOR xyz USING logarchmeth1 USEREXIT logprimary 10 logsecond -1 logfilsiz 2000; " Any advice would be appreciated. DB2 V8.1.14.292 TSM SERVER for Windows V5.3.4.0 BA CLIENT 5.3.0.0 Thanks Bill ********************************************************************** This electronic mail message, including any attachments, is a confidential communication exclusively between Babcock International Group PLC or its subsidiary company and the intended recipient(s) indicated as the addressee(s). It contains information which is private and may be proprietary or covered by legal professional privilege. If you receive this message in any form and you are not the intended recipient you must not review, use, disclose or disseminate it. We would be grateful if you could contact the sender upon receipt and in any event you should destroy this message without delay. Anything contained in this message that is not connected with the business of Babcock International Group PLC is neither endorsed by nor is the liability of this company. Babcock International Group PLC Company number 2342138 Registered in England 2 Cavendish Square London W1G 0PX Telephone: +44(0)20 7291 5000 Fax: +44(0)20 7291 5055 Website: www.babcock.co.uk **********************************************************************