(Ep. 12) – Backup Compression: Db2 vs. GZIP

“What do you mean you don’t compress your backup here?!? Why?”

That is what I said coming into a new job a few years ago. They had an honest to God business reason NOT to compress backups. Even better, they used GZIP when they did.

In this episode I explain a scenario where compressed backups may not be necessary. Then I discuss the benefits (and drawbacks) of using GZIP if you do compress your backups.

Timestamps:
00:08 – Overview: When do you compress backups?
01:40 – Test Results (Db2 Compression vs. GZIP)
03:51 – A case for and against GZIP
05:00 – Benefit of doing compression on compression?

Useful Links:
(Blog) Backup Compression Considerations – https://tinyurl.com/zstsrf4