I have a db is in archive mod (LOGRETAIN = RECOVERY) and logprimary is set to 3. Pat the log file is / arch_log. If I go in that path i have:
S0000000.LOG
S0000001.LOG
S0000002.LOG
S0000003.LOG
S0000004.LOG
S0000005.LOG
S0000006.LOG
But the active logs are only S0000004.LOG S0000005.LOG S0000006.LOG (db cfg >>> First active log file S0000004.LOG) ?
Others can delete ??? I can not automate the delete logs archived ?
Help me please !!!!
5  13589 
Hi,
I wouldn't delete that old log files easily. They are inactive and could be deleted, yes. But then you wouldn't be able to restore a backup from the days these log files have been active.
So if you're sure you won't need to restore backups e.g. older than 7 days, then you could delete the log files older than this.
Regards,
Bernd
Hi docdiesel,
thank you for your reply.
My problem is this: I must set the DB for full online backup includes logs all day with VERITAS. I set LOGRETAIN = RECOVERY and USEREXIT = ON. Veritas makes backup without problem but does not erase the log achieved!
So that the filesystem where there are logs will be filled very soon!!!
How can I do? I do not know where most beat their heads!
Hi,
I don't know Veritas, but we once had a database where we used the DB2 userexit db2uext2 to archive (and then delete) the logs automatically into our ADSM server (now called TSM). Please have a look at the site of IBM where they provide an article called "Setting Up a User Exit on DB2 UDB V8 to Archive Database Logs". This could be helpful to you, from the DB2 side. From the Veritas side, well, I can't tell, I'm sorry.
Best regards,
Bernd
Please contract Viretas support. Viretas netbackup have two options for db2 archive log file ,one is COPY, the other is move.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Åâãåíèé Êîñåíêî |
last post by:
Hi!
I need to fresh a zip-archive using zipfile. However, it seems it is no
function to fresh the archive. When I use the append-mode of ZipFile, the
written file is merely appended to the archive while the old copy is still in
the archive. As a result, there are several files with the same name in the
archive. Is it valid state of the archive?
I would to achieve the result using a delete/remove operation, but it is also
is not...
|
by: Phil Latio |
last post by:
We have despatch process which kicks out picking information into text
files at hourly intervals.
The text files are named sequentially by process; 'ABC.txt',
'ABC01.txt', 'ABC02.txt' for one process, or 'XYZ.txt', 'XYZ01.txt' for
another process.
The folder contents would look like this;
ABC.txt
ABC01.txt
|
by: James Johnson |
last post by:
Dear C#dex,
You can automate a POST and interrogate the resulting HTTP stream using
code such as:
HttpWebRequest hwreq = (HttpWebRequest)WebRequest.Create(url);
hwreq.Method = "POST";
hwreq.ContentType = "application/x-www-form-urlencoded";
hwreq.ContentLength = buffer.Length;
hwreq.Proxy = new WebProxy("Gloriadias", true);
|
by: Philip Nestingen |
last post by:
I wrote a function to delete specific messages in an archive sync. It works
just find as long as the url (file name) does not include any illegal
characters. Is there a way to use cdoex to delete the messages as an
alternative or someway to replace the illegal characters? Below is the
function which takes a single parameter. Such as
(file://./storeage/domain/MBX/archive/Inbox/goodStuff.EML) and it delete the
email.
If the file name is...
|
by: Peter Thorne |
last post by:
I am a perl newbie who is trying to write a script to automate a
task.
I have a large collection of compressed archives (mostly .tar.gz,
tar.bz2, tar.Z, .tgz etc). This are stored in a number of directories
/ sub-directories).
I am looking for a script that will recursively extract a single file
from each of these archives e.g. the file INSTALL, for the extracted
file to be moved to a different location and renamed to the name of
| | |
by: (PeteCresswell) |
last post by:
I've got apps where you *really* wouldn't want to delete certain items by
accident, but the users just have to have a "Delete" button.
My current strategies:
Plan A:
------------------------------------------------------------------------
1) Make the cmd button black and do not give it an accelerator key.
2) Issue two levels of confirmation (Do you want to delete... Do you REALLY want
|
by: alex.hatzisavas |
last post by:
Dear all,
I'm trying to do a selective deletion from an 'Archive' table based on
dates.
Here is the setup:
Table 'Archive' has a date field ( ).
Another table ('Cutoffs') defines the Low and High Cut-off dates
(fields: , respectively).
|
by: biganthony via AccessMonster.com |
last post by:
Hi,
I have the following code to select a folder and then delete it. I keep
getting a Path/File error on the line that deletes the actual folder. The
line before that line deletes the files in the folder but I get the error
message when the procedure attempts to delete the folder selected in the
BrowseforFolderbyPath function.
How can I get it to delete the folder that the user has selected in the
Browse for Folder dialog?
|
by: situ |
last post by:
Greeting,
I'm using Db2 9.5 for windows.
would anybody please suggest me on how to "automate log shipping "?
Regards,
situ
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
