Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005

    Unanswered: DB2 Backup COMPRLIB Windows


    I have seen several posts discussing the COMPRESS option in BACKUP command. Most of these seem to be AIX related.

    Has anybody successfully used a third party Compression Utility to improve the File Size on a Windows Platform?

    Currently doing standard backup and then pkzip of file to get 10:1 compression (avg. database)

    The default Compress option seems to do 5:1 (avg.) which is good, and it even zips as well, but the final size is larger than the option above.

    Was just wondering if anyone has successfully implemented a better compression utility that will give the 001 file straight off at 10:1 or better.

    Thank you for your time

    Windows 2003 SP1 with DB2 Workgroup Server Edition 8.2.3

    DB21085I Instance "DB2" uses "32" bits and DB2 code release "SQL08023" with
    level identifier "03040106".
    Informational tokens are "DB2 v8.1.10.812", "s050811", "WR21362", and FixPak

  2. #2
    Join Date
    Nov 2004


    we have been using compress option on solaris
    the size is about 50% but there is a cpu overhead.
    we have seen backup time 200% with compression on very large solaris machine (16 cpu and 32G real storage)
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts