By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,017 Members | 979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,017 IT Pros & Developers. It's quick & easy.

How to manually switch active logs

P: 3
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.
Feb 20 '07 #1
Share this Question
Share on Google+
1 Reply


P: 3
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
Feb 20 '07 #2

Post your reply

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