By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,948 Members | 1,535 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,948 IT Pros & Developers. It's quick & easy.

BACKING UP DB2 DATABASE TO TAPE

P: n/a
Guys may yu assist me am stuck. Am using v8.1 db2 database on Suse
Linux running on an IBM pSeries server. I am aware of the backup
utility in db2. I would like to back up the my db2 database to a tape
device. What is the command to effect this in linux? How is a tape
device represented in the suse linux file system? If using the tape
device involves mounting it, how is this done? The tape is an IBM
VXAtape X23 Data Cartridge. Please help ... please please.

Dec 9 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Have you looked at the command reference manual? The BACKUP DATABASE
command parameter "TO" allows specification of tape device(s) for the
output.

You'll need to talk to your systems programmer to get the name of the
tape device. The traditional location for a tape device is somewhere in
the /dev directory but newer versions of the kernel have moved it
because it's a "mountable" device that may or may not be available (ie.
a tape is actually mounted) at any moment in time. You'll also need to
have its permissions set to allow write access for the userid performing
the backup. (It's more likely that the systems programmer will, with
some prodding, add the userid to a group that has write access to the
device. You'll probably need to get a manager or two involved in
obtaining this authorization.)

Be sure to check out the "BUFFER" parameter. You'll need to discuss it
with your systems programmer to get an appropriate value for it.

Try backing up a tiny database first. I'd recommend the SAMPLE database
that comes with UDB. After you've backed it up, try restoring it to
SAMPLE2 to verify that the tape is readable. If all goes well, make sure
that you attempt a restore of the full database backup so you know what
to expect should it become a necessity. If your backup ever extends to
more than one tape, make sure that the multiple tape restore also works.

A dvd writer drive could also be an interesting alternative to using
tape. One obvious advantage is the elimination of mechanical tape failures.
Philip Sherman
Akaketwa wrote:
Guys may yu assist me am stuck. Am using v8.1 db2 database on Suse
Linux running on an IBM pSeries server. I am aware of the backup
utility in db2. I would like to back up the my db2 database to a tape
device. What is the command to effect this in linux? How is a tape
device represented in the suse linux file system? If using the tape
device involves mounting it, how is this done? The tape is an IBM
VXAtape X23 Data Cartridge. Please help ... please please.
Dec 11 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.