Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007
    Posts
    1

    Cool Unanswered: safe to delete db2 transaction logs?

    I'm still learning db2, so this question may sound simple.

    If I run a database backup with the command
    BACKUP DATABASE DBNAME ONLINE TO "C:\DB2_Backup" WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 COMPRESS INCLUDE LOGS, is it safe to delete the transaction logs (the S0000xxx.log files) assuming I don't want to roll back any transactions from the time of the backup?

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    yup, if thats a good image then u can safely delete logs before of that
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

Posting Permissions

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