Jacques, The DB2 Database administrator requires it done every hour, the data is also backed up every hour, the reason being we can restore both dbs and data to the hour in disaster recovery scenario. He wants the USEREXIT ditched and the hrly archive kept !
Thanks Bill Jacques Van Den Berg <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> 22/08/2007 10:28 Please respond to "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> To ADSM-L@VM.MARIST.EDU cc Subject Re: [ADSM-L] DB2 Log Archiving via TSM Why, do you want it done hourly if its gets automatically archived by DB2 when the log file is full? Just let DB2 do the archiving directly to TSM. We have 21 DB2 databases all archiving directly to one TSM server with no problems. Some of them are pretty busy, writing a log file every few seconds to TSM. Regards, Jacques van den Berg TSM / Storage / SAP Basis Administrator Pick 'n Pay IT Email : [EMAIL PROTECTED] Tel : +2721 - 658 1711 Fax : +2721 - 658 1676 Mobile : +2782 - 653 8164 Dis altyd lente in die hart van die mens wat God en sy medemens liefhet (John Vianney). -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bill Dourado Sent: 22 August 2007 11:16 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] DB2 Log Archiving via TSM 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 ********************************************************************** Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to [EMAIL PROTECTED] ********************************************************************** 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 **********************************************************************
