473,320 Members | 1,900 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,320 software developers and data experts.

Automate delete archive log !

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 !!!!
Jul 8 '08 #1
5 13525
docdiesel
297 Expert 100+
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
Jul 9 '08 #2
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!
Jul 9 '08 #3
docdiesel
297 Expert 100+
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
Jul 10 '08 #4
awfcai
1
Please contract Viretas support. Viretas netbackup have two options for db2 archive log file ,one is COPY, the other is move.
Jul 17 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

0
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...
2
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...
5
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";...
4
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...
1
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...
17
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:...
4
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...
24
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...
2
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
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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...
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: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
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...
0
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

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.