Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2007
    Posts
    6

    Question Unanswered: How to manually switch active logs

    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

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    db2 archive log is a command that can be executed
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Feb 2007
    Posts
    6
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •