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; NX842]
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.
NX842
Specifies that log files written to the secondary archive destination for logs are compressed using the NX842 hardware compression method. If set dynamically, log files already archived are not compressed. This feature is only available on AIX.
ZLIB
Specifies that log files written to the primary archive destination for logs are compressed using the ZLIB compression method. 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, VENDOR, or DB2REMOTE, or VENDOR, log archive compression has no effect regardless of the logarchcompr2 configuration parameter setting.