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.