DB2 Archived Log Compression

26 September,2017 by Jack Vamvas

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 files

Some other ideas to explore include compressed tables . Compressed tables will pass compressed record images to the transaction logs , which makes the log files smaller.

Note: Often managing DB2 LUW transaction logs can lead to space issue , generating alerts for full disk. It can be tempting to compress active logs, BE CAREFUL . If you’re lucky it may only negatively impact backups – but it’s always possible your database may become unusable. If someone accidentally compresses an active log file – and your ONLINE backup is failing , take an OFFLINE as soon as possible.

Notes on DB2 LUW archive log and BACKUP command

Troubleshooting DB2 Return Codes, failed to archive log and SQLUV_INIT_FAILED

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on DB2 Archived Log Compression

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright