We're in the process of planning a move from 11.50 on HP-UX to 14.10 on Linux, and I have a question about the Integrated Backup Encryption feature in 14.10. Can the archives/backups be compressed?
I'm asking because the compression usually only works well on unencrypted data. Once encrypted, the data usually does not have enough repeating character strings to give good compression results. From a recent test with an 11.50 instance, I can do a level 1 archive of a dev instance that takes 530 MB. If I compress that archive, I can get it down under 100 MB, a reduction of a bit over 82%. But if I PGP encrypt the archive before attempting to compress (and I disable the compress option in PGP), the encryption adds a small amount of overhead, increasing the file size by just a few MB, but that encrypted archive then does not compress at all. In fact, compressing the encrypted file adds yet another MB or two.
So, does the Integrated Backup Encryption allow the archives and/or backups to be compressed? What configuration options need to be tweaked to make that happen? Are the BACKUP_FILTER / RESTORE_FILTER parameters still used in 14.10 when using the backup encryption? For those who have implemented Integrated Backup Encryption along with compression (assuming it's feasible), what kind of compression ratios are you seeing?
Thanks in advance.
------------------------------
Mark Collins
------------------------------
#Informix