Hi DBA gurus,
I need some sugestions , plans how you implemented online backups for a big size db? how often you
backup the db, and copy the archoved logs to tapes, how about active logs to tapes..etc?
Are other files I need also for restore db ?


Isabella

ighiurea wrote:

> 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]
>
> ---------------------------------------------------------------------
> 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