DB2 10.5 for Linux, UNIX, and Windows

spm_log_path - Sync point manager log file path configuration parameter

This parameter specifies the directory where the sync point manager (SPM) logs are written.

Configuration type

Database manager

Applies to

Database server with local and remote clients
Database server with local clients
Partitioned database server with local and remote clients

Parameter type

Configurable

Default [range]

NULL [any valid path or device]

If this parameter is null, by default, the logs are written to the sqllib/spmlog directory, which, in a high-volume transaction environment, can cause an I/O bottleneck. Use this parameter to have the SPM log files placed on a faster disk than the current sqllib/spmlog directory. This allows for better concurrency among the SPM agents.

Note: If SPM is enabled then the default directory will be created if it does not yet exist. To enable SPM, the configuration parameter spm_name must be set.