How to manually switch active logs

sansaniwal · #1 (**permalink**) 02-20-07, 03:00

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.

Thanks & Regards,
sansaniwal

guyprzytula · #2 (**permalink**) 02-20-07, 03:15

db2 archive log is a command that can be executed

sansaniwal · #3 (**permalink**) 02-20-07, 05:45

Thanks A Lot.
yes this command is manully 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

Internet Services

Web Development

Digital Marketing

Consumer Tech