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 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
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
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
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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.
...
|
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 :...
|
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...
|
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
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
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....
|
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
|
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...
| |