Thread: Newbie question on backups
11-14-06, 16:30 #1Registered User
- Join Date
- Nov 2006
Unanswered: Newbie question on backups
For UDB, the automatic backups when set to 1 per day it doesn't appear to run them once per day as the GUI states. Also, does anyone know how many copies are kept. I've read that they are "pruned", but it doesn't state how many are kept of each kind. I'll have a mix of daily and weekly image copies in the same database. If someone can point me to some reading on backups I'd appreciate it.
We are using Veritas to backup the file system nightly. I'm also guessing that since the daily and weekly backups are taken off to tape by Veritas that I can use anyone of those (if restored from tape) as a possible recovery point. I'm also using cyclical logging and not using any kind of roll forward options.
Thanks in advance.
11-15-06, 01:10 #2Registered User
- Join Date
- May 2003
Forget about automatic backups. A poorly implemented solution.
Instead use a cron job (or the DB2 scheduler if using Windows) to take regular backups, and write a script to prune them. Don't forget the compress option to save space.M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390