Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > IBM DB2 > Re: Archive log...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 4 Topic 8875 of 9520
Post > Topic >>

Re: Archive logs?

by "Mark A" <nobody@[EMAIL PROTECTED] > May 11, 2008 at 07:38 AM

> "Kofa" <kovacs.it@[EMAIL PROTECTED]
> wrote in message
> Could you please elaborate on that?
> According to the docs, an archived log file may be renamed and reused.
> Should I use a LOGARCHMETH1 like
> DISK:some-path? Would that result in unused (not active) logs files
> being copied to some-path, and then reused? Or could I supply a user
> exit that 'archives' log files by deleting them?

The syntax you would probably want to use is DISK:/path...  The archive
logs 
will automatically be copied from the active log path to that path
specified 
in the LOGARCHMETH1 parm. You do not need any exit program if you use this

parm.

It is always possible that an archived log file might need to be used. For

example if you needed to restore from a backup and roll forward the logs.

You will need to manually purge the archive logs (unless you have Version 
9.5) via a cron script (an exit program is not needed). You will want to 
keep the archive logs at least until before the last backup (so you can
roll 
the logs forward from the backup time to the current time or end of logs),

and maybe longer if you need to ever restore the next-to-last backup and 
then roll forward.
 




 4 Posts in Topic:
Archive logs?
Kofa <kovacs.it@[EMAIL  2008-05-10 07:36:58 
Re: Archive logs?
"Mark A" <no  2008-05-10 22:31:35 
Re: Archive logs?
Kofa <kovacs.it@[EMAIL  2008-05-10 23:08:16 
Re: Archive logs?
"Mark A" <no  2008-05-11 07:38:50 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 21:01:41 CST 2008.