Nonstop Database, HiRDB Version 9 Command Reference

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

14.2.3 Notes on option specifications

  1. A specific type of statistical information can be extracted by combining the -k option with other options. The table below shows the relationships between the -k option and the other options.

    Table 14-3 Relationships between the -k option and other options

    -k option (value) Other options
    -t start time and/or end time -u UAP name(s) -x host name(s) -s server name(s)
    sys (system activity statistical information) Y -- Y --
    svr (system activity statistical information by server) Y -- Y Y
    uap (UAP statistical information) Y Y Y --
    sql (SQL statistical information) Y Y Y --
    buf (global buffer pool statistical information) Y -- Y Y
    fil (statistical information on HiRDB files for database manipulation) Y -- Y Y
    dfw (deferred write processing statistical information) Y -- Y Y
    idx (index statistical information) Y -- -- Y
    sop (SQL static optimization information) Y Y Y --
    dop (SQL dynamic optimization information) Y Y Y --
    pcd (SQL object execution information) Y Y Y --
    obj (SQL object transfer statistical information) Y Y Y --
    sqh (SQL statement statistical information) Y Y Y Y
    cnc (CONNECT/DISCONNECT statistical information) Y Y Y Y
    dio (statistical information about database I/O operations) Y -- Y Y
    all (all the above) Y Y Y Y
    Y: Can be specified (when specified, the corresponding information can be extracted).
    --: Ignored if specified (the corresponding information cannot be extracted).
  2. When -k idx is specified, the -o option is ignored, if specified.
  3. If the -d option is specified when -k idx or -k all is specified, the target information can be extracted.
  4. If sop, dop, or pcd is specified in the -k option, the -o option must also be specified.
  5. The following table shows the files that can be input and the statistical information that can be analyzed when the -i or -d option is specified:
    Option File that can be input Statistical information that can be analyzed
    -i Unload log file Information about splitting index statistical information
    Statistical information about CONNECT/DISCONNECT
    Unload statistics log file All statistical information other than the above
    -d System log file Information about splitting index statistical information
    Statistical information about CONNECT/DISCONNECT
  6. When -k uap is specified, the statistical information acquisition units depend on the UAP execution environment. The following table shows the relationship between client environment definition (PDSTJTRNOUT) during UAP execution and statistical information acquisition units:
    Contents of PDSTJTRNOUT Type of UAP
    OLTP environment Other environment
    YES By transaction By transaction
    NO By UAP execution By UAP execution
    Omitted By transaction By UAP execution

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.