Nonstop Database, HiRDB Version 9 System Operation Guide
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.
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).
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.