DB2 10.5 for Linux, UNIX, and Windows

logarchcompr2 - Secondary archived log file compression configuration parameter

This parameter specifies whether the log files written to the secondary archive destination for logs are compressed.

Configuration type

Database

Applies to

Database servers with local and remote clients
Clients
Database servers with local clients
Partitioned database servers with local and remote clients

Parameter type

Configurable online

Default [range]

OFF [ON]

OFF

Specifies that log files written to the secondary archive destination for logs are not compressed.

ON

Specifies that log files written to the secondary archive destination for logs are compressed. If set dynamically, log files already archived are not compressed.

Note:

If you set the logarchmeth2 configuration parameter to a value other than DISK, TSM, or VENDOR, log archive compression has no effect regardless of the logarchcompr2 configuration parameter setting.