Hello DB2 backup experts,
I have a question also in regards to logs on DB2 UDB ver 8.
I'm using DB2 userxit program to archive the logs to disk to diferit path from active logs .The
active logs are on mirror disks ( for redundacy , is it enough?), here are my questions:
-which logs should I backup daily since I'm running my full online backup db every 2 weeks ?
-when can I rewrite this tapes for logs?
Thank you
oliver_mefford wrote:
> are you using the IBM supplied 'userexit' program?
>
> Oliver Mefford
> Senior DBA, Corporate Database Services (CDS)
> PeopleSoft, Inc. Data Center Facility
> 5840 Owens Drive, Pleasanton, CA. 94588
> Office - 925/694-9011
> Cell - 925/895-6384
>
> |---------+--------------------------------------------------------->
> | | "Joe Philip " |
> | | [Email address protected]
> | | azydba.com> |
> | | |
> | | 05/18/2004 12:29 PM |
> | | |
> |---------+--------------------------------------------------------->
> >-------------------------------------------------------------------------------------------|
> | |
> | To: "LazyDBA Discussion" [Email address protected] |
> | cc: (bcc: Oliver Mefford/PeopleSoft) |
> | Subject: moving the log files from the regular log path |
> >-------------------------------------------------------------------------------------------|
>
> We have archive logging on for our DB2 UDB 8.1 databases. Our log directory
> is getting filled up very often. Can I move the old log files (log files
> which have 10 day's earlier timestamp) and that do not have the active
> status? Is there anything else I should aware of before putting a script to
> move the old logs to archive log storage location.
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe, e-mail: [Email address protected]
> For additional commands, e-mail: [Email address protected]
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe, e-mail: [Email address protected]
> For additional commands, e-mail: [Email address protected]
DB2 & UDB email list listserv db2-l LazyDBA home page