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

DB2 backup question

P: n/a
Dear all,

Currently, I am using offline full backup for my working DB2 v8.1 for data
protection. The backup image will be dump to disk and then compressed by
bzip2.

However, the current DB size was over 3G and this exceeded the bzip2 limit
for compression. I have try the compress option in db2 backup command,
however the compression ration seem not as good as bzip2.

Could anyone suggestion that is it possible to break down the backup image
into parts with DB2 backup command option? Or could db2 backup command using
the bzip2 library for compression (I have tried the comprlib option, but it
isn't work and doc support is not much ..)?

Thanks in advance!

Henry
Dec 5 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"kaming" <gu***@guest.com> wrote in message
news:dn***********@news.hgc.com.hk...
Dear all,

Currently, I am using offline full backup for my working DB2 v8.1 for data
protection. The backup image will be dump to disk and then compressed by
bzip2.

However, the current DB size was over 3G and this exceeded the bzip2 limit
for compression. I have try the compress option in db2 backup command,
however the compression ration seem not as good as bzip2.

Could anyone suggestion that is it possible to break down the backup image
into parts with DB2 backup command option? Or could db2 backup command
using
the bzip2 library for compression (I have tried the comprlib option, but
it
isn't work and doc support is not much ..)?

Thanks in advance!

Henry

I assume you have FP4 or higher? That was the first version that supported
compression.

If you specify multiple paths on the "TO" command in the backup, DB2 will
split the file among the paths.
Dec 5 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.