0

Currently I am backing up my Derby Database using the SYSCS_UTIL.SYSCS_BACKUP_DATABASE procedure. However due to a too big size sometimes this fails and I am wondering if there exist the possibility to backup only data that is newer than x days, where x is a settable values.

Would appreciate greatly any hints towards achieving this goal, if that is possible.

akuzma
  • 1,592
  • 6
  • 22
  • 49
steve
  • 594
  • 4
  • 10
  • 23
  • 1
    I don't think Derby supports this. So you'd have to write some sort of procedure to implement this, which would probably not be a good idea as it would be error prone. You could solve the problem with more hardware though. Can you buy a second disk and write your backups to that device? – BillRobertson42 Aug 06 '13 at 13:27
  • What is the failure message? – Kuzgun Aug 06 '13 at 13:33
  • Sometimes it fails due to java.lang.OutOfMemoryError – steve Aug 06 '13 at 13:54
  • Give it more memory! Your JVM should have a flag that lets you specify a larger amount of memory for your program. See for example http://stackoverflow.com/questions/3030263/increasing-the-jvm-maximum-heap-size-for-memory-intensive-applications – Bryan Pendleton Aug 09 '13 at 21:04

0 Answers0