2.2.23 Operands related to performance trace information

101) pd_prf_trace = Y | N
Specifies whether performance trace information is to be collected. For details about the performance trace facility, see Performance Trace Facility in the HiRDB Version 9 System Operation Guide.
Y:
Collect performance trace information.
N:
Do not collect performance trace information. If performance trace information is not collected, the pdprfd process is not started.
Specification guidelines
Normally, this operand does not need to be specified. We recommend that you do not specify N because, in the event of an error, this setting makes it difficult to determine the cause of the error.
Notes
If N is specified in this operand, the setting cannot be changed to collect performance trace information while HiRDB is running. To collect performance traces, terminate HiRDB, enable the collection of performance traces, and then restart HiRDB.
102) pd_prf_level = 00000007 | 0000001f | 0000007f | 000001ff | 00000000
Specifies the performance trace information collection level in hexadecimal notation. For details about the information that can be collected according to the performance trace collection level, see Details about performance trace information and collection points in the HiRDB Version 9 System Operation Guide.
The following table describes the collection level determined by the value of the pd_prf_level operand and the information that is collected.

Table 2-3 Collection level determined by the value of the pd_prf_level operand and the information that is collected

Value of the pd_prf_level operandCollection levelPositioningInformation that is collected
00000007​
(Minimum level)
00000004​Provides the minimum amount of informationTraces of CONNECT operation, utility execution, and specific events
0000001​f
(Default level)
00000004​,
00000010​
Allows the boundaries with HiRDB (entry and exit) to be identifiedTraces mostly before and after communication with HiRDB in addition to the traces obtained at the minimum level
0000007​f
(Detail level)
00000004​,
00000010​,
00000040​
Provides the information required for tracing SQL processingTraces that can be used to check the flow of HiRDB's internal processing in addition to the traces obtained at the default level
000001ff
(Maintenance level)
00000004​,
00000010​,
00000040​,
00000100​
Provides the maintenance information that is useful in the event of an errorTraces that includes iteration processing such as internal locking in addition to the traces obtained at the detail level
00000000​
(Suppression level)
Not collectedSuppresses the collection of trace dataNot collected
Specification guidelines
  • We recommend that you specify 0000001f (default level) so that when you investigate performance-related errors, you can quickly identify the cause of the problem. If a decrease in online performance is acceptable, such as during environment configuration, consider specifying 0000007f (detail level).
  • Normally there is no need to specify 000001ff (maintenance level). Specify this level only if you are requested to do so by the support service.
  • We recommend that you do not specify 00000000 (suppression level) because, in the event of an error, this setting makes it difficult to determine its cause.
Notes
  • If the number of performance trace collection points is increased or the collection level is changed to acquire more detailed performance traces, online performance might decrease.
  • Do not specify a value other than 00000007, 0000001f, 0000007f, 000001ff, or 00000000. If any other value is specified, it becomes more difficult to verify performance and investigate errors.
Relationship to other operands
This operand is related to the following operands:
  • pd_prf_file_count
  • pd_prf_file_size
Remarks
By using the pdprflevel command, you can change the collection level even while HiRDB is running.
103) pd_prf_file_count = number-of-performance-trace-information-file-generations
~<unsigned integer> ((3-256))<<15>>
Specifies the number of performance trace information file generations that will be retained.
Specification guidelines
  • Normally, this operand does not need to be specified.
  • Consider specifying this operand if you want to retain the information in the performance trace information file for a long time. Estimate the number of performance trace information file generations and the file size from the following total capacity of the performance trace information files:
    Total capacity of the performance trace files = pd_prf_file_count operand value[Figure] pd_prf_file_size operand value
    Example
    This example specifies the total capacity of the performance trace information files required for retaining one hour worth of performance trace information.
    pd_prf_level operand valueTotal capacity of performance trace information files
    Number of SQL statements executed per second is about 200Number of SQL statements executed per second is about 500
    00000007​750 MB (default value#)750 MB (default value#)
    0000001​f750 MB (default value#)2 GB
    0000007​f2 GB5 GB
    #: This is default value of the pd_prf_file_count operand[Figure] default value of the pd_prf_file_size operand.
  • To approximate the total capacity of the performance trace information files required per unit, use the following guidelines:
    Total capacity of the performance trace information files = MAX(768,000, a[Figure] b[Figure] c[Figure] d) (kilobytes)
    a: Number of front-end and back-end servers per unit
    For a HiRDB single server configuration or if there is only a system manager or a dictionary server, the value is 1.
    b: Number of SQL statements executed per second on each server
    You can obtain the average value per editing time by dividing TOTAL, the total SQL statement execution count in the SQL-related statistical information, by the editing time EDIT TIME (seconds).
    c: Average amount of performance trace collected per SQL statement (kilobytes)
    Assume one of the following values based on the value of the pd_prf_level operand:
    [Figure]00000007: 0.5 kilobytes
    [Figure]0000001f: 0.5 kilobytes
    [Figure]0000007f: 1 kilobyte
    Note that the above value varies according to conditions, such as the type of SQL statement, amount of data, system configuration, whether facilities are applied, and tuning status.
    d: Length of time for which the performance trace information is to be retained (seconds)
  • The length of time for which the performance trace information can be retained per file might change drastically depending on numerous factors, such as the type of transaction and the HiRDB configuration. To obtain accurate values, measure the time for which performance trace information is retained per file when the most typical transactions and utilities are executed. You can determine the time value by using the timestamp or the pdprfed command's editing results. Calculate the required number of file generations based on the measured time.
Notes
  • The value of this operand affects the amount of disk space required under the HiRDB directory. The following amount of disk space is required to store the performance trace information files:
    pd_prf_file_count operand value[Figure] pd_prf_file_size operand value
  • This operand affects the capacity of the error information files that are collected by using commands, such as pdinfoget and pdgeter.
  • If you change the value of this operand to a smaller value, the performance trace information files corresponding to the eliminated portion of the value will no longer be used, but they are not deleted automatically. If you need to delete any unneeded performance trace information file, delete them after HiRDB has terminated.
Relationship to other operands
This operand is related to the pd_prf_file_size operand.
104) pd_prf_file_size = size-of-a-performance-trace-information-file
~<unsigned integer> ((1024-1048576))<<51200>> (kilobytes)
Specifies the size of each performance trace information file.
Specification guidelines
Normally, this operand does not need to be specified. Consider specifying this operand if you want to retain the information in the performance trace information files for a longer than normal time.
Notes
  • This operand value affects the amount of disk space required under the HiRDB directory. The following amount of disk space is required to store the performance trace information files:
    pd_prf_file_count operand value[Figure] pd_prf_file_size operand value
  • This operand affects the capacity of the error information files that are collected by using commands, such as pdinfoget and pdgeter.
  • If you increase this operand value, the time required by the pdprfed command to edit and output performance traces increases.
  • If this operand value is too large, sending the files to the support service for purposes such as an investigation of performance issues might be difficult, even if the files are compressed. Specify the appropriate file size taking into account file transmission.
  • The performance trace information is output to the performance trace information file every 10 seconds. If many traces are output at one time, the performance trace information file might become smaller in size by a maximum of 10 megabytes.
Relationship to other operands
This operand is related to the pd_prf_file_count operand.