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 <jvandenberg AT PNP.CO DOT ZA>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
22/08/2007 10:28
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To
ADSM-L AT VM.MARIST DOT 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 : jvandenberg AT pnp.co DOT za
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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Bill Dourado
Sent: 22 August 2007 11:16 AM
To: ADSM-L AT VM.MARIST DOT 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 it-security AT pnp.co DOT za
**********************************************************************
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
**********************************************************************
|