By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,236 Members | 1,292 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,236 IT Pros & Developers. It's quick & easy.

Relationship between recv_hist_retentn and archive log files

P: n/a
Hi. I was just wondering if someone could help me understand the
relationship between the recv_hist_retention value and archive logs
(and pruning of history file).

My understanding is that the history file will be automatically pruned
at the number of days specified in the recv_hist_retentn parameter.
First of all, is that correct? Secondly, does the archive logs, that
are older than the value in recv_hist_retentn value, also get deleted
automatically. Kind of like "prune history xxxxxxxxxx and delete".

Thanks in advance,

Kush

Oct 12 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Right, the file gets pruned of entries older than the number of days
specified, but...
NUM_DB_BACKUPS controls also what gets PRUNED. No entry that refers to logs
and backups part of the value (say 5 which makes the restore set) will be
deleted if older than the prune day value.
The following Google search woll help you: db2 prune and delete

ASFAIK, the actual backup images do not get deleted in V8.2.
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Kush" <ra*****@ca.ibm.coma écrit dans le message de news:
11**********************@i3g2000cwc.googlegroups.c om...
Hi. I was just wondering if someone could help me understand the
relationship between the recv_hist_retention value and archive logs
(and pruning of history file).

My understanding is that the history file will be automatically pruned
at the number of days specified in the recv_hist_retentn parameter.
First of all, is that correct? Secondly, does the archive logs, that
are older than the value in recv_hist_retentn value, also get deleted
automatically. Kind of like "prune history xxxxxxxxxx and delete".

Thanks in advance,

Kush
Oct 12 '06 #2

P: n/a
If you are using Automatic backups, the backups greater than the
NUM_DB_BACKUPS are automatically deleted if they are on disk.

The logs are not so elegantly handled. A "PRUNE HISTORY xxxxxx AND
DELETE" is required to have DB2 delete old archive logs.

In V9, I have a query to generate the PRUNE statement using the new
sysibmadm.db_history view. The xxxxxx timestamp is:
select min(start_time) as minbkup
from sysibmadm.db_history
where operation = 'B'
and operationtype in ('F','N')

This subquery is wrapped in a larger query that formats the command.

Dale McInnis (IBM) unofficially mentioned that they were
re-architecting this process in a future version in an IDGUG
presentation.

Norm

Pierre Saint-Jacques wrote:
Right, the file gets pruned of entries older than the number of days
specified, but...
NUM_DB_BACKUPS controls also what gets PRUNED. No entry that refers to logs
and backups part of the value (say 5 which makes the restore set) will be
deleted if older than the prune day value.
The following Google search woll help you: db2 prune and delete

ASFAIK, the actual backup images do not get deleted in V8.2.
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Kush" <ra*****@ca.ibm.coma écrit dans le message de news:
11**********************@i3g2000cwc.googlegroups.c om...
Hi. I was just wondering if someone could help me understand the
relationship between the recv_hist_retention value and archive logs
(and pruning of history file).

My understanding is that the history file will be automatically pruned
at the number of days specified in the recv_hist_retentn parameter.
First of all, is that correct? Secondly, does the archive logs, that
are older than the value in recv_hist_retentn value, also get deleted
automatically. Kind of like "prune history xxxxxxxxxx and delete".

Thanks in advance,

Kush
Oct 13 '06 #3

P: n/a
Thanks guys. This answers my question basically that I DO need "Prune
History xxxxx and DELETE" or "Prune Logifile xxxxx " . Thanks for your
answers.

Kush
Norm wrote:
If you are using Automatic backups, the backups greater than the
NUM_DB_BACKUPS are automatically deleted if they are on disk.

The logs are not so elegantly handled. A "PRUNE HISTORY xxxxxx AND
DELETE" is required to have DB2 delete old archive logs.

In V9, I have a query to generate the PRUNE statement using the new
sysibmadm.db_history view. The xxxxxx timestamp is:
select min(start_time) as minbkup
from sysibmadm.db_history
where operation = 'B'
and operationtype in ('F','N')

This subquery is wrapped in a larger query that formats the command.

Dale McInnis (IBM) unofficially mentioned that they were
re-architecting this process in a future version in an IDGUG
presentation.

Norm

Pierre Saint-Jacques wrote:
Right, the file gets pruned of entries older than the number of days
specified, but...
NUM_DB_BACKUPS controls also what gets PRUNED. No entry that refers tologs
and backups part of the value (say 5 which makes the restore set) will be
deleted if older than the prune day value.
The following Google search woll help you: db2 prune and delete

ASFAIK, the actual backup images do not get deleted in V8.2.
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Kush" <ra*****@ca.ibm.coma écrit dans le message de news:
11**********************@i3g2000cwc.googlegroups.c om...
Hi. I was just wondering if someone could help me understand the
relationship between the recv_hist_retention value and archive logs
(and pruning of history file).
>
My understanding is that the history file will be automatically pruned
at the number of days specified in the recv_hist_retentn parameter.
First of all, is that correct? Secondly, does the archive logs, that
are older than the value in recv_hist_retentn value, also get deleted
automatically. Kind of like "prune history xxxxxxxxxx and delete".
>
Thanks in advance,
>
Kush
>
Oct 13 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.