Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-239

Need a online backup feature that does not block update operations when online backup is in progress.

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.1.1.0
    • 10.2.1.6
    • Store
    • None

    Description

      Currently Derby allows users to perfoms online backups using SYSCS_UTIL.SYSCS_BACKUP_DATABASE() procedure, but while the backup is in progress, update operations are temporarily blocked, but read operations can still proceed.

      Blocking update operations can be real issue specifically in client server environments, because user requests will be blocked for a long time if a
      backup is in the progress on the server.

      Attachments

        1. obtest_customer.jar
          2 kB
          Suresh Thalamati
        2. onlinebackup_1.diff
          42 kB
          Suresh Thalamati
        3. onlinebackup_2.diff
          0.5 kB
          Suresh Thalamati
        4. onlinebackup_3.diff
          35 kB
          Suresh Thalamati
        5. onlinebackup_4.diff
          62 kB
          Suresh Thalamati
        6. onlinebackup_5.diff
          6 kB
          Suresh Thalamati
        7. onlinebackup_6.diff
          33 kB
          Suresh Thalamati
        8. onlinebackup_7.diff
          73 kB
          Suresh Thalamati
        9. onlinebackup_8.diff
          51 kB
          Suresh Thalamati
        10. onlinebackup.html
          28 kB
          Suresh Thalamati
        11. onlinebackup1.html
          33 kB
          Suresh Thalamati
        12. onlinebackup2.html
          35 kB
          Suresh Thalamati

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-523 Non logged operation that starts before the log archive mode is enabled can not be recovered during rollforward recovery.

          • Major - Major loss of function.
          • Closed

          Activity

            People

              tsuresh Suresh Thalamati
              tsuresh Suresh Thalamati
              Votes:
              4 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: