Hello

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
"10".

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)