The pdclttrc command acquires an SQL trace for a client executing SQL statements. The SQL trace information is output to the client.
You can determine the server name and process ID subject to acquisition of the SQL trace from the client's IP address and UAP identification information in the pdls -d prc command's execution results.
HiRDB administrator
pdclttrc [-s server-name] [-p process-ID] [-e] [-l PDUAPREPLVL-value] |
Specifies the name of the server to which the client subject to acquisition of the SQL trace is connected. Specify the name of the single server or a front-end server.
When this option is omitted, the command acquires an SQL trace for all processes connected to all HiRDB servers (single or front-end servers).
For a single server, specifying an invalid server name does not result in an error.
Specifies the process ID of the server to which the client subject to acquisition of the SQL trace is connected.
For a HiRDB parallel server configuration, this option must be specified together with the -s option. For a HiRDB single server configuration, the -s option is optional.
When this option is omitted, the command acquires an SQL trace for all processes connected to the single server or front-end server.
Stops acquisition of SQL traces.
To output UAP statistical report information in addition to SQL trace information, specifies the UAP statistical report information that is to be output (value of the PDUAPREPLVL client environment definition). For details about the specification values and information output destination, see the HiRDB Version 9 UAP Development Guide.
When the inter-process memory communication facility is used, this option is ignored, if specified. The command displays the messages during process-to-process memory communication.
When this option is specified together with the -e option, this option is ignored.
Specifies in bytes the maximum length of the search data and ? parameter information that is to be output to the SQL trace.
This option provides the same function as when INOUT is specified in the PDPRMTRC client environment definition.
When this option is specified together with the -e option, this option is ignored.
Specifies the number of operation codes to be output to the SQL trace file. SQL trace acquisition stops when information has been output for the specified number of operation codes.
When this option is omitted, the command outputs SQL trace information until a pdclttrc command with the -e option specified is executed or until DISCONNECT is executed.
When this option is specified together with the -e option, this option is ignored.
Specifies in bytes the size of the SQL trace file.
When 0 is specified, the maximum file size is assumed.
When this option is specified together with the -e option, this option is ignored.
PDCLTPATH | PDREPPATH | Output destination of SQL trace file |
---|---|---|
Omitted | Omitted | Current directory |
Specified | Omitted | Directory specified in PDCLTPATH |
Omitted | Specified | Directory specified in PDREPPATH |
Specified | Specified |