470,647 Members | 1,328 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

Backup and Logfiles

We decided to root for a backup strategy using online incremental
backups which include the log files (avail since DB v8.2). Now I
wondered, if DB2 automtically deletes the archived logfiles after
executing of online backup using that option or if we still need to
remove them manually.

Regards,
Janick

Nov 24 '06 #1
2 1495
DB2 does not delete log files unless you tell it to. The last thing support
wants is you on the phone saying: The system ate my log files.

The option to include log files basically "copies" the log files that were
active from the start to the end of the backup into the backup images.
They are left in the log path. The last active log file when the backup
terminates is closed at its current size.
This will also cause it to archive if you are using either of DB2UEXT2 or
V8/9 LOGARCHMETH's.
If that is the case, the log files will be in the archive, the logpath and
also in the image.

If you nedd more, get back to me, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<ja******@gmail.coma écrit dans le message de news:
11*********************@14g2000cws.googlegroups.co m...
We decided to root for a backup strategy using online incremental
backups which include the log files (avail since DB v8.2). Now I
wondered, if DB2 automtically deletes the archived logfiles after
executing of online backup using that option or if we still need to
remove them manually.

Regards,
Janick
Nov 24 '06 #2
Pierre, thanks for your answer.

I went for setting LOGARCHMETH1 to a dedicated path where the logfiles
will be activated on backup. So we have an easy solution to get the
archived logfiles on a different disk than the active ones, where they
can easily be deleted.

Regards,
Janick

Pierre Saint-Jacques schrieb:
DB2 does not delete log files unless you tell it to. The last thing support
wants is you on the phone saying: The system ate my log files.

The option to include log files basically "copies" the log files that were
active from the start to the end of the backup into the backup images.
They are left in the log path. The last active log file when the backup
terminates is closed at its current size.
This will also cause it to archive if you are using either of DB2UEXT2 or
V8/9 LOGARCHMETH's.
If that is the case, the log files will be in the archive, the logpath and
also in the image.

If you nedd more, get back to me, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<ja******@gmail.coma écrit dans le message de news:
11*********************@14g2000cws.googlegroups.co m...
We decided to root for a backup strategy using online incremental
backups which include the log files (avail since DB v8.2). Now I
wondered, if DB2 automtically deletes the archived logfiles after
executing of online backup using that option or if we still need to
remove them manually.

Regards,
Janick
Nov 25 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Courtis Joannis | last post: by
1 post views Thread by Andrew E | last post: by
reply views Thread by richardb | last post: by
1 post views Thread by Oliver Spiesshofer | last post: by
reply views Thread by Knokmans | last post: by
10 posts views Thread by Michael Hoffmann | last post: by
2 posts views Thread by clilush | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.