Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

in db2 9.5 LUW i have one db instance to which i just added a second database. we don't have TSM or multiple partitions which is what all the documentation seems to be about when i search the web for this.

can i run an online backup db for the first database and immediately start an online backup db for the second database and let them run simultaneously? or would i have to let the first finish before starting the second? thanks.

share|improve this question
add comment

1 Answer 1

up vote 2 down vote accepted

Yes, you can back up multiple databases at the same time.

Whether you want to do so or not depends on how much impact to database performance you are willing to accept and how long your backups run. You can control this somewhat by throttling your backup(s).

share|improve this answer
    
thanks. i set up a small test and was able to confirm this. –  vikrantislav Jan 19 '12 at 18:25
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.