db2 UDB backup using COMPRESS option

zgh1970

Hi, Friends,

>From db2 v8 Fixpac 4 backup has one new option COMPRESS using the

default DB2 compression library.

I am wondering if this option will have any new restriction on RESTORE
in the following.
(Can I used that backup imsage for restore at the follwoing compatible
situations?)
:
There are operating system considerations when using the RESTORE
DATABASE command:

9 9 You can restore databases created on a DB2 Version 8 32-bit 9
Windows platform to a DB2 Version 8 64-bit Windows platform, or the
reverse. 9 You can restore databases created on a DB2 Version 8 32-bit
Linux (Intel) 9 platform to a DB2 Version 8 64-bit Linux (Intel)
platform, or the reverse. 9 You can restore databases created on DB2
Version 8 AIX, HP-UX, or the Solaris Operating Environment 9
platforms, in 32-bit or 64-bit, to DB2 Version 8 AIX, HP-UX, or
Solaris Operating Environment platforms 9 (32-bit or 64-bit).

Thanks,

Sep 7 '07 #1

Sanjuro

On Sep 7, 11:05 am, zgh1970 <george.zh...@lombard.cawrote:

Hi, Friends,>From db2 v8 Fixpac 4 backup has one new option COMPRESS using the

default DB2 compression library.

I am wondering if this option will have any new restriction on RESTORE
in the following.
(Can I used that backup imsage for restore at the follwoing compatible
situations?)
:
There are operating system considerations when using the RESTORE
DATABASE command:

9 9 You can restore databases created on a DB2 Version 8 32-bit 9
Windows platform to a DB2 Version 8 64-bit Windows platform, or the
reverse. 9 You can restore databases created on a DB2 Version 8 32-bit
Linux (Intel) 9 platform to a DB2 Version 8 64-bit Linux (Intel)
platform, or the reverse. 9 You can restore databases created on DB2
Version 8 AIX, HP-UX, or the Solaris Operating Environment 9
platforms, in 32-bit or 64-bit, to DB2 Version 8 AIX, HP-UX, or
Solaris Operating Environment platforms 9 (32-bit or 64-bit).

Thanks,

COMPRESS is a great new feature in DB2 V9. I have seen successful
compression of about 40% - 80% of backup image (it all depends on what
kind of data you have). My poorest COMPRESS performance is due to
large image BLOBs.

While performing a RESTORE from a compressed image, you don't have to
use the COMPRESS keyword again. DB2 automatically detects that you are
Restoring from compressed image. However, if you have used an external
compression library, I would assume you 'll need the same library at
the restore location. I have never tried using an external compression
library.

Thanks,
Sanjuro

Sep 10 '07 #2

zgh1970

Hi, Sanjuro,
thank you for the reply.
I want to know if there is any more retriction for RESTORE with
COMPRESS backup image to move database to another server (maybe
different fixpact, or form v8 to v9).
Thanks,

On Sep 10, 11:02 am, Sanjuro <ashru...@gmail.comwrote:

On Sep 7, 11:05 am, zgh1970 <george.zh...@lombard.cawrote:

Hi, Friends,>From db2 v8 Fixpac 4 backup has one new option COMPRESS using the

default DB2 compression library.

I am wondering if this option will have any new restriction on RESTORE
in the following.
(Can I used that backup imsage for restore at the follwoing compatible
situations?)
:
There are operating system considerations when using the RESTORE
DATABASE command:

9 9 You can restore databases created on a DB2 Version 8 32-bit 9
Windows platform to a DB2 Version 8 64-bit Windows platform, or the
reverse. 9 You can restore databases created on a DB2 Version 8 32-bit
Linux (Intel) 9 platform to a DB2 Version 8 64-bit Linux (Intel)
platform, or the reverse. 9 You can restore databases created on DB2
Version 8 AIX, HP-UX, or the Solaris Operating Environment 9
platforms, in 32-bit or 64-bit, to DB2 Version 8 AIX, HP-UX, or
Solaris Operating Environment platforms 9 (32-bit or 64-bit).

Thanks,

COMPRESS is a great new feature in DB2 V9. I have seen successful
compression of about 40% - 80% of backup image (it all depends on what
kind of data you have). My poorest COMPRESS performance is due to
large image BLOBs.

While performing a RESTORE from a compressed image, you don't have to
use the COMPRESS keyword again. DB2 automatically detects that you are
Restoring from compressed image. However, if you have used an external
compression library, I would assume you 'll need the same library at
the restore location. I have never tried using an external compression
library.

Thanks,
Sanjuro- Hide quoted text -

- Show quoted text -

Sep 10 '07 #3

rahul

On Sep 10, 4:43 pm, zgh1970 <george.zh...@lombard.cawrote:

Hi, Sanjuro,
thank you for the reply.
I want to know if there is any more retriction for RESTORE with
COMPRESS backup image to move database to another server (maybe
different fixpact, or form v8 to v9).
Thanks,

On Sep 10, 11:02 am, Sanjuro <ashru...@gmail.comwrote:

On Sep 7, 11:05 am, zgh1970 <george.zh...@lombard.cawrote:

Hi, Friends,>From db2 v8 Fixpac 4 backup has one new option COMPRESS using the

default DB2 compression library.

I am wondering if this option will have any new restriction on RESTORE
in the following.
(Can I used that backup imsage for restore at the follwoing compatible
situations?)
:
There are operating system considerations when using the RESTORE
DATABASE command:

9 9 You can restore databases created on a DB2 Version 8 32-bit 9
Windows platform to a DB2 Version 8 64-bit Windows platform, or the
reverse. 9 You can restore databases created on a DB2 Version 8 32-bit
Linux (Intel) 9 platform to a DB2 Version 8 64-bit Linux (Intel)
platform, or the reverse. 9 You can restore databases created on DB2
Version 8 AIX, HP-UX, or the Solaris Operating Environment 9
platforms, in 32-bit or 64-bit, to DB2 Version 8 AIX, HP-UX, or
Solaris Operating Environment platforms 9 (32-bit or 64-bit).

Thanks,

COMPRESS is a great new feature in DB2 V9. I have seen successful
compression of about 40% - 80% of backup image (it all depends on what
kind of data you have). My poorest COMPRESS performance is due to
large image BLOBs.

While performing a RESTORE from a compressed image, you don't have to
use the COMPRESS keyword again. DB2 automatically detects that you are
Restoring from compressed image. However, if you have used an external
compression library, I would assume you 'll need the same library at
the restore location. I have never tried using an external compression
library.

Thanks,
Sanjuro- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

yes while moving from 8.2.7 32bit to 9.1 64 bit we have to use
uncompressed images as it was giving problems while restoring
compressed images

Sep 10 '07 #4

zgh1970

On Sep 10, 11:48 am, rahul <rahul...@gmail.comwrote:

On Sep 10, 4:43 pm, zgh1970 <george.zh...@lombard.cawrote:

Hi, Sanjuro,
thank you for the reply.
I want to know if there is any more retriction for RESTORE with
COMPRESS backup image to move database to another server (maybe
different fixpact, or form v8 to v9).
Thanks,

On Sep 10, 11:02 am, Sanjuro <ashru...@gmail.comwrote:

On Sep 7, 11:05 am, zgh1970 <george.zh...@lombard.cawrote:

Hi, Friends,>From db2 v8 Fixpac 4 backup has one new option COMPRESS using the

default DB2 compression library.

I am wondering if this option will have any new restriction on RESTORE
in the following.
(Can I used that backup imsage for restore at the follwoing compatible
situations?)
:
There are operating system considerations when using the RESTORE
DATABASE command:

9 9 You can restore databases created on a DB2 Version 8 32-bit 9
Windows platform to a DB2 Version 8 64-bit Windows platform, or the
reverse. 9 You can restore databases created on a DB2 Version 8 32-bit
Linux (Intel) 9 platform to a DB2 Version 8 64-bit Linux (Intel)
platform, or the reverse. 9 You can restore databases created on DB2
Version 8 AIX, HP-UX, or the Solaris Operating Environment 9
platforms, in 32-bit or 64-bit, to DB2 Version 8 AIX, HP-UX, or
Solaris Operating Environment platforms 9 (32-bit or 64-bit).

Thanks,

COMPRESS is a great new feature in DB2 V9. I have seen successful
compression of about 40% - 80% of backup image (it all depends on what
kind of data you have). My poorest COMPRESS performance is due to
large image BLOBs.

While performing a RESTORE from a compressed image, you don't have to
use the COMPRESS keyword again. DB2 automatically detects that you are
Restoring from compressed image. However, if you have used an external
compression library, I would assume you 'll need the same library at
the restore location. I have never tried using an external compression
library.

Thanks,
Sanjuro- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

yes while moving from 8.2.7 32bit to 9.1 64 bit we have to use
uncompressed images as it was giving problems while restoring
compressed images- Hide quoted text -

- Show quoted text -

Hi,
Can I use db2 v8.2 32-bit backup image with compress to restore on db2
v8.2 64-bit and db2 v9?
Thanks,

Sep 14 '07 #5

rahul

On Sep 14, 4:53 pm, zgh1970 <george.zh...@lombard.cawrote:

On Sep 10, 11:48 am, rahul <rahul...@gmail.comwrote:

On Sep 10, 4:43 pm, zgh1970 <george.zh...@lombard.cawrote:

Hi, Sanjuro,
thank you for the reply.
I want to know if there is any more retriction for RESTORE with
COMPRESS backup image to move database to another server (maybe
different fixpact, or form v8 to v9).
Thanks,

On Sep 10, 11:02 am, Sanjuro <ashru...@gmail.comwrote:

On Sep 7, 11:05 am, zgh1970 <george.zh...@lombard.cawrote:

Hi, Friends,>From db2 v8 Fixpac 4 backup has one new option COMPRESS using the

default DB2 compression library.

I am wondering if this option will have any new restriction on RESTORE
in the following.
(Can I used that backup imsage for restore at the follwoing compatible
situations?)
:
There are operating system considerations when using the RESTORE
DATABASE command:

9 9 You can restore databases created on a DB2 Version 8 32-bit 9
Windows platform to a DB2 Version 8 64-bit Windows platform, or the
reverse. 9 You can restore databases created on a DB2 Version 8 32-bit
Linux (Intel) 9 platform to a DB2 Version 8 64-bit Linux (Intel)
platform, or the reverse. 9 You can restore databases created on DB2
Version 8 AIX, HP-UX, or the Solaris Operating Environment 9
platforms, in 32-bit or 64-bit, to DB2 Version 8 AIX, HP-UX, or
Solaris Operating Environment platforms 9 (32-bit or 64-bit).

Thanks,

COMPRESS is a great new feature in DB2 V9. I have seen successful
compression of about 40% - 80% of backup image (it all depends on what
kind of data you have). My poorest COMPRESS performance is due to
large image BLOBs.

While performing a RESTORE from a compressed image, you don't have to
use the COMPRESS keyword again. DB2 automatically detects that you are
Restoring from compressed image. However, if you have used an external
compression library, I would assume you 'll need the same library at
the restore location. I have never tried using an external compression
library.

Thanks,
Sanjuro- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

yes while moving from 8.2.7 32bit to 9.1 64 bit we have to use
uncompressed images as it was giving problems while restoring
compressed images- Hide quoted text -

- Show quoted text -

Hi,
Can I use db2 v8.2 32-bit backup image with compress to restore on db2
v8.2 64-bit and db2 v9?
Thanks,- Hide quoted text -

- Show quoted text -

technically it should work. but i dont know why it wasnt working in my
case

Sep 17 '07 #6