473,324 Members | 2,581 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Relationship between recv_hist_retentn and archive log files

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
3 3438
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Aladdin | last post by:
I am using the java.util.zip package to create zip files. I can create a new archive and add files to it without any trouble. But if I already have a zip file created, how do I add a new file to...
43
by: Dan Perl | last post by:
Here is a python feature that I would like: to be able to import modules from an archive like the jar files in Java. Maybe a regular tar file? Maybe a python specific file type, let's call it a...
1
by: DB2 Convert | last post by:
Hi, A few points to confirm as I am still new with DB2. 1. What will happen if archive logging is used, however there is no userexit or manual process to move those online archived logs to...
6
by: JezB | last post by:
From a windows application, I want to provide an "archive" facility which will scan a specific directory and put specific files into some single "Archive file", a bit like a zip-file I guess, but...
1
by: Damjan | last post by:
I am looking for a way to change a file that is inside a zip archive, in python of course. The thing is, I'm doing a CGI script that accepts a zip file (an OpenOffice document), I need to make...
7
by: Enigma Curry | last post by:
I need to store a large number of files in an archive. From Python, I need to be able to create an archive, put files into it, modify files that are already in it, and delete files already in it. ...
1
by: Piet | last post by:
I've been trying to use PCLzip to extract uploaded archives with the following code: $archive = new PclZip('temp/temp.zip'); if ($archive->extract(PCLZIP_OPT_PATH, 'temp/') == 0) { die("Error :...
34
by: Alexnb | last post by:
Gerhard Häring wrote: No, it didn't work, but it gave me some interesting feedback when I ran it in the shell. Heres what it told me: Traceback (most recent call last): File...
3
by: aRTx | last post by:
I have try a couple of time but does not work for me My files everytime are sortet by NAME. I want to Sort my files by Date-desc. Can anyone help me to do it? The Script <? /* ORIGJINALI
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.