Use Diagnostic frequency (-diagFrequency) to specify the duration or interval (in number of seconds) after which the subsequent diagnostic events of the same type should be reported. This parameter limits the reporting frequency.

Operating system and syntax UNIX / Windows -diagFrequency n
Use with Maximum value Minimum value Single-user default Multi-user default
Database Server – 0 – 0
n
An integer greater than 0, specifying the number of seconds to limit the reporting frequency. The default value is set to 0, which indicates that the limited reporting functionality is disabled, and the diagnostic data is collected each time a diagnostic event occurs.
The -diagFrequency startup parameter limits the reporting frequency for the following diagnostic events:
  • Lock table overflow
  • BI stall
  • System error
The delay-time value of the -diagFrequency parameter applies to subsequent diagnostic event occurrences of the same type. There is no distinct -diagFrequency value for any of the three diagnostic events, and the same value applies to all. However, the -diagFrequency value applies individually to each diagnostic event. For example, lock table overflow and BI stall events may occur at the same frequency, but any subsequent occurrences of these events will occur at the -diagFrequency value when reporting diagnostic information about the same event.
Note: When explicitly reporting diagnostic data through PROMON, the -diagFrequency parameter value does not limit the frequency at which the data can be requested.
To change the -diagFrequency parameter while the database is running, you can use the following options: