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 > Using ARCHIVE LOG command

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-10-03, 17:46
smk35 smk35 is offline
Registered User
 
Join Date: Oct 2003
Posts: 2
Using ARCHIVE LOG command

In an attempt to close the active recovery log so it can be copied to tape, I issued the "archive log for db dbname" command. But the log
file is still listed as the First Active Log File. However I did notice that
the log S0000250.LOG has been truncated from its original size and the next log LOG251.LOG was being written to. I issued the command again and S0000251.LOG was truncated and S0000252.LOG is now
being written to:

db2iadm1 204808192 Oct 10 11:12 S0000253.LOG
db2iadm1 12288 Oct 10 10:26 S0000251.LOG
db2iadm1 102404096 Oct 9 12:21 S0000250.LOG

First active log file = S0000250.LOG

I have LOGRETAIN=RECOVERY. My question is this: How do I get
S0000250.LOG so that it is not the first active log any more (without
having to stopdb2 or deactivating the database)? This is on a test machine with virtually no activity. 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