DB2 backup question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kaming - 05 Dec 2005 03:04 GMT

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

Reply to this Message

Mark A - 05 Dec 2005 03:43 GMT

> Dear all,
>
[quoted text clipped - 16 lines]
>
> 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.

Reply to this Message