db2 UDB backup using COMPRESS option
in [DB2]
|
From: zgh1970 on 7 Sep 2007 12:05 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,
From: Sanjuro on 10 Sep 2007 11:02 On Sep 7, 11:05 am, zgh1970 <george.zh...(a)lombard.ca> wrote: > 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
From: zgh1970 on 10 Sep 2007 11:43 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...(a)gmail.com> wrote: > On Sep 7, 11:05 am, zgh1970 <george.zh...(a)lombard.ca> wrote: > > > > > > > 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 -
From: rahul on 10 Sep 2007 11:48 On Sep 10, 4:43 pm, zgh1970 <george.zh...(a)lombard.ca> wrote: > 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...(a)gmail.com> wrote: > > > > > On Sep 7, 11:05 am, zgh1970 <george.zh...(a)lombard.ca> wrote: > > > > 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
From: zgh1970 on 14 Sep 2007 11:53
On Sep 10, 11:48 am, rahul <rahul...(a)gmail.com> wrote: > On Sep 10, 4:43 pm, zgh1970 <george.zh...(a)lombard.ca> wrote: > > > > > > > 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...(a)gmail.com> wrote: > > > > On Sep 7, 11:05 am, zgh1970 <george.zh...(a)lombard.ca> wrote: > > > > > 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, |