Start/notes.ini Parameters/COLLECT_DB_LOCK_WAITS

COLLECT_DB_LOCK_WAITS

Parameter: COLLECT_DB_LOCK_WAITS
Short description: Enables the collection of LockWaits and AvgWait values for the Show DBS command. Set only temporarily.

Profile

Parameter
COLLECT_DB_LOCK_WAITS
Category
Logging / Debug (diagnostics, only temporary)
Available since
At least 9.0.1 (HCL documentation)
GUI equivalent
notes.ini only (no GUI)
Possible values
1 = enabled · not set / 0 = off (default)
Default
Not set (= off)

Description

According to the HCL product documentation:
To display LockWaits and AvgWait values, you must temporarily add the setting COLLECT_DB_LOCK_WAITS=1 to the server's NOTES.INI file. Because this setting consumes server resources, remove it after you view Show DBS statistics.
With COLLECT_DB_LOCK_WAITS=1, the administrator instructs the Domino server to collect the values
  • LockWaits — number of times a user had to wait for a read/write lock on a database
  • AvgWait — average wait time (in milliseconds)
so that they are shown in the output of the Show DBS server command. By default, Show DBS reports only Refs, Mod, FDs, #Waiters, and MaxWaiters; LockWaits/AvgWait are added only via this switch.
HCL explicitly emphasizes that the setting consumes server resources and should therefore only be set temporarily for diagnostics, and removed again after evaluation.

Example configuration

COLLECT_DB_LOCK_WAITS=1
Remove again after evaluation, or set to 0.

Notes & pitfalls

  • Diagnostics only — leave disabled in normal production operation.
  • Works in combination with the Show DBS server command (console).
  • LockWaits / AvgWait values are useful for identifying hot-spot databases (e.g. mail.box, log.nsf).
  • After the analysis, deliberately revert so that server load decreases again.

Sources (HCL Product Documentation)