How to determine your backup/recovery strategy

You may also like...

3 Responses

  1. Nish says:

    Regarding file level backup for DB2 database – Yes, FlashCopy procedure (database mirroring) requires IO suspend. But, file copy at SAN level does not need IO suspend, though this is not documented officially, it does work just fine. One thing to make sure when you do file copy is to copy all the files (db files, data files, tran and arch log files, etc). HTH.

  2. MC says:

    Re archiving of tran logs. We have numerous MSSQL dbs where we use a scheduled backup log cmd to archive logs eg half hourly, is the equivalent in DB2 to schedule the archive log cmd rather than let the log fill?

    • Ember Crooks says:

      DB2 will take care of it for you. The only way the log will fill is if there is a single connection that uses it all, too many active connections at once for your active log file sizes, the disk itself fills up, or what we call log file saturation, where a very old connection is still holding on to LSNs from long ago in the log file.

      The only scenario in which I have use the archive log command is when I had some failure of archive logging and I had fixed the issue and wanted to force db2 to attempt archiving again. It is not a frequently used command.

Leave a Reply

Your email address will not be published. Required fields are marked *