Thread: DB2 Backup COMPRLIB Windows
11-09-05, 10:52 #1Registered User
- 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 v220.127.116.112", "s050811", "WR21362", and FixPak
11-09-05, 11:13 #2Registered User
- 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 DBA & Advanced DBA Certified
DB2 Dprop Certified