Sync Point Manager Log File Path (spm_log_path)

Configuration Type
Database manager

Applies to

Parameter Type
Configurable

Default
sqllib/spmlog [any valid path or device]

This parameter specifies the directory where the Sync Point Manager (SPM) logs are written. 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.

For more information on the Sync Point Manager, refer to the Installing and Configuring DB2 Clients.