Backup and Logfiles

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • jabernet@gmail.com
    #1

    Backup and Logfiles

    We decided to root for a backup strategy using online incremental
    backups which include the log files (avail since DB v8.2). Now I
    wondered, if DB2 automtically deletes the archived logfiles after
    executing of online backup using that option or if we still need to
    remove them manually.

    Regards,
    Janick

    Tags: None
    • Pierre Saint-Jacques
      #2
      Re: Backup and Logfiles

      DB2 does not delete log files unless you tell it to. The last thing support
      wants is you on the phone saying: The system ate my log files.

      The option to include log files basically "copies" the log files that were
      active from the start to the end of the backup into the backup images.
      They are left in the log path. The last active log file when the backup
      terminates is closed at its current size.
      This will also cause it to archive if you are using either of DB2UEXT2 or
      V8/9 LOGARCHMETH's.
      If that is the case, the log files will be in the archive, the logpath and
      also in the image.

      If you nedd more, get back to me, Pierre.
      --
      Pierre Saint-Jacques
      SES Consultants Inc.
      514-737-4515
      <jabernet@gmail .coma écrit dans le message de news:
      1164388443.8616 81.28130@14g200 0c...legrou ps.com...
      We decided to root for a backup strategy using online incremental
      backups which include the log files (avail since DB v8.2). Now I
      wondered, if DB2 automtically deletes the archived logfiles after
      executing of online backup using that option or if we still need to
      remove them manually.
      >
      Regards,
      Janick
      >

        Comment

        • jabernet@gmail.com
          #3
          Re: Backup and Logfiles

          Pierre, thanks for your answer.

          I went for setting LOGARCHMETH1 to a dedicated path where the logfiles
          will be activated on backup. So we have an easy solution to get the
          archived logfiles on a different disk than the active ones, where they
          can easily be deleted.

          Regards,
          Janick

          Pierre Saint-Jacques schrieb:
          DB2 does not delete log files unless you tell it to. The last thing support
          wants is you on the phone saying: The system ate my log files.
          >
          The option to include log files basically "copies" the log files that were
          active from the start to the end of the backup into the backup images.
          They are left in the log path. The last active log file when the backup
          terminates is closed at its current size.
          This will also cause it to archive if you are using either of DB2UEXT2 or
          V8/9 LOGARCHMETH's.
          If that is the case, the log files will be in the archive, the logpath and
          also in the image.
          >
          If you nedd more, get back to me, Pierre.
          --
          Pierre Saint-Jacques
          SES Consultants Inc.
          514-737-4515
          <jabernet@gmail .coma écrit dans le message de news:
          1164388443.8616 81.28130@14g200 0c...legrou ps.com...
          We decided to root for a backup strategy using online incremental
          backups which include the log files (avail since DB v8.2). Now I
          wondered, if DB2 automtically deletes the archived logfiles after
          executing of online backup using that option or if we still need to
          remove them manually.

          Regards,
          Janick

            Comment

            Previous template Next
            Working...