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.