Nonstop Database, HiRDB Version 9 System Operation Guide

[Contents][Index][Back][Next]

28.1.2 Settings for collecting performance trace information

To collect performance trace information, specify Y for the pd_prf_trace operand, or omit this operand.

Specifying N for the pd_prf_trace operand disables the performance trace facility, and therefore no performance trace information is collected. Since that would make it difficult to investigate the causes of errors that occur, do not specify N.

Organization of this subsection
(1) Performance trace facility collection level

(1) Performance trace facility collection level

By selecting as the collection level either the minimum level (default value), the standard level, the detailed level, the maintenance level, or the suppressed level, you can adjust the amount of performance trace information the performance trace facility outputs to the performance trace information file. You specify the performance trace collection level in the pd_prf_level operand of the system definition. To change the collection level while HiRDB is active, use the pdprflevel command.

The table below lists the collection levels that correspond to the collection level names. For details about these collection levels, see the information on the pd_prf_level operand in the manual HiRDB Version 9 System Definition.

Collection level name Collection level
Minimum level (default setting) 00000004
Standard level 00000004, 00000010
Detailed level 00000004, 00000010, 00000040
Maintenance level 00000004, 00000010, 00000040, 00000100
Suppressed level Performance trace information is not collected.

For details about the performance trace information collection points that correspond to the collection levels, see Table 28-2 Main collection points for performance trace information (during execution of SQL code) and Table 28-3 Main collection points for performance trace information (during utility execution).