Ask the Expert

Advice on how to backup more efficiently

We are doing our DB2 backup on tapes using GDG datasets. There is lot of work involved with it because tablespaces are getting bigger and they can't fit on the same tape, so we need to separate them to different tapes. How can we backup our data more efficiently?

    Requires Free Membership to View

Although you do not specify what release of DB2 you are using, here is some advice. DB2 V7 provides for more parallelism in the COPY and RECOVERY functions when using tapes. With V6 it's more difficult.

You can manually break up the copy jobs into multiple jobs and manage to get "parallel" that way but the jobs would all have different copy times. For a large application trying to get a single "quiesce" point for recovery, you would have to run a single quiesce job after all the copy jobs are complete. Recover would have to be "to quiesce", not "to copy."

An upside to this is the copies could all be SHRLEVEL CHANGE -- the only outage would be for the quiesce. The downside is in a busy shop you may not be able to get the application-wide quiesce.

And of course, there's always the option of looking at an ISV product to simplify your copying. For example, BMC Software has been providing parallel processing, wildcarding, automatic GDG build for new objects, application group wide quiesce and other functional improvements to the copy and recover process for years.

Check out the following links for information on our COPY PLUS and RECOVER PLUS offerings:



Thanks to Rick Weaver, Product Manager for BMC Software's Mainframe Database Recovery products for his assistance in putting this response together.)

Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our .VO7aaqqaAFk.0@/search390>discussion forums.

This was first published in February 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: