469,352 Members | 2,154 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,352 developers. It's quick & easy.

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 12936
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

Post your reply

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

Similar topics

reply views Thread by Евгений Косенко | last post: by
5 posts views Thread by James Johnson | last post: by
4 posts views Thread by Philip Nestingen | last post: by
17 posts views Thread by (PeteCresswell) | last post: by
24 posts views Thread by biganthony via AccessMonster.com | last post: by
2 posts views Thread by situ | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.