DB2 Archived Log Compression

Question: Can I compress DB2 LUW archived logs? How can I configure a DB2 database to apply compression to the archived logs automatically? Answer: It is possible to configure a DB2 LUW database to compress Archived Logs. The two primary database configurables are to use Primary log archive compression (logarchcompr1) and secondary log archive compression (logarchcompr2). By simply changing the default value of NO to YES , does not automatically mean there will be archival logging compression. LOGARCHMETH1 must be set to either DISK, TSM, or VENDOR. If these values are not used there will be no compression of archivedlog... Read more →

DB2 Archived Log Compression

Question: Can I compress DB2 LUW archived logs? How can I configure a DB2 database to apply compression to the archived logs automatically? Answer: It is possible to configure a DB2 LUW database to compress Archived Logs. The two primary database configurables are to use Primary log archive compression (logarchcompr1) and secondary log archive compression (logarchcompr2). By simply changing the default value of NO to YES , does not automatically mean there will be archival logging compression. LOGARCHMETH1 must be set to either DISK, TSM, or VENDOR. If these values are not used there will be no compression of archivedlog... Read more →