If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > deleting old logs

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-24-06, 17:53
zkajfez zkajfez is offline
Registered User
 
Join Date: Jan 2002
Posts: 161
deleting old logs

My DB is 8.2 and my desired setup is:
a) active logs are in active log directory
b) archive logs are in some other directory

after online backup with option "include logs" i want to delete logs from archive log directory

How to setup b) and deleting logs?
TIA,Zvonimir
Reply With Quote
  #2 (permalink)  
Old 08-25-06, 08:33
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
To set up archiving the logs, set th DB config parameter LOGARCHMETH1. See the online help or the manuals on how to set this. As for deleting them, DB2 provides no method to do this. You have to do it either manually or through some cron type process. Just make sure that you only delete archived logs that are no longer needed. This means that you have to be 100% sure that should a failure occur, and you have to restore the DB from the backup image, that these logs are not needed for rollforward recovery.

HTH

Andy
Reply With Quote
  #3 (permalink)  
Old 08-25-06, 11:59
zkajfez zkajfez is offline
Registered User
 
Join Date: Jan 2002
Posts: 161
i set logarchmeth1="disk=D:\ARCHIVE" but it still archive logs in directory with primary logs.I even restarted instnace
What i am doing wrong?
Reply With Quote
  #4 (permalink)  
Old 08-25-06, 12:05
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
You should be running this to set it properly:

UPDATE DB CFG for MyDB using logarchmeth1 DISK:\ARCHIVE

HTH

Andy
Reply With Quote
  #5 (permalink)  
Old 08-25-06, 12:07
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
Stupid smiley face icons. That smiley face is a colon followed directly by D

Andy
Reply With Quote
  #6 (permalink)  
Old 08-25-06, 12:20
zkajfez zkajfez is offline
Registered User
 
Join Date: Jan 2002
Posts: 161
Thanks,Andy.
Everything is perfect
Thanks
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On