Connecting Tech Pros Worldwide Help | Site Map

How to manually switch active logs

Newbie
 
Join Date: Sep 2006
Posts: 3
#1: Feb 20 '07
Hi all,
How can i manually switching my active log to next active log.Suppose my First active log file is on S0033915.LOG & i want to move it to S00339116.LOG. because i need backup of this log S0033915.LOG.
Newbie
 
Join Date: Sep 2006
Posts: 3
#2: Feb 20 '07

re: How to manually switch active logs


Quote:

Originally Posted by sansaniwal

Hi all,
How can i manually switching my active log to next active log.Suppose my First active log file is on S0033915.LOG & i want to move it to S00339116.LOG. because i need backup of this log S0033915.LOG.

************************

Hi all,
db2 archive log command is manully used for switching active logs
Also for running this command there should not be any existing connection.so first run
db2 terminate
then
db2 archive log for database sample
db2 get db cfg for sample |findstr -i "log"
db2 archive log for database sample
db2 get db cfg for sample |findstr -i "log"
So every time active log increases.

Thanks & Regards,
Sansaniwal
Reply