Results 1 to 2 of 2

Thread: Active DB2 LOGS

  1. #1
    Join Date
    May 2002
    Posts
    43

    Unanswered: Active DB2 LOGS

    Is there a query I can run to list all active DB2LOGS? My log filesystem is filling up fast and I wanted to prune the logs. I usually prune the logs after the weekend offling backup, but it does not look like it can wait.......

    Afraid of removing a log and then a rollback occuring......

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by Koz
    Is there a query I can run to list all active DB2LOGS? My log filesystem is filling up fast and I wanted to prune the logs. I usually prune the logs after the weekend offling backup, but it does not look like it can wait.......

    Afraid of removing a log and then a rollback occuring......
    db2 GET DB CFG FOR <BLAH>

    ...
    First active log file = S0000142.LOG
    ...

    I've always found it strange that it's in the db cfg, but I'm sure there are reasons.
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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