10.2.3 Operands related to foreign server interface trace information

6) pd_hb_l_path = foreign-server-interface-trace-information-file-output-destination-directory
[Figure]<pathname> <<%PDDIR%\spool\>>
Specifies the output destination directory for foreign server interface trace information. Foreign server interface trace information is output to this directory. Two output files are created under this directory. Their names are pdhlforeign-server-name-1 and pdhlforeign-server-name-2.
For details on foreign server interface trace information, see the HiRDB External Data Access Version 7 Description and User's Guide.
7) pd_hb_l_size = foreign-server-interface-trace-information-file-size
[Figure]<unsigned integer>((0, 4-4096)) <<1024>> (KB)
Specifies the size of the foreign server interface trace information file (units: KB). To not limit the size, specify 0.
If the file size exceeds the value specified for this operand, the files are swapped and trace information is output to the other file.
Specification guideline
On average, 300 bytes of information is output per trace (excluding the ? parameter information).
Notes
  • For a UAP executed by specifying the PDSQLTRACE operand of the client environment definition, foreign server interface trace information is collected for each foreign server. Because multiple transactions write data into a single file, a lock is applied during a writing operation. Therefore, collecting foreign server interface trace information lowers both transaction processing performance and concurrent executability.
  • Depending on the access status of the foreign server, the file size may exceed the value specified for this operand. Therefore, collect foreign server interface trace information onto a disk with ample free space.
8) pd_hb_l_prm = Y | N
Specifies whether to output ? parameter information in foreign server interface trace information.
Y: Outputs ? parameter information.
N: Does not output ? parameter information.
9) pd_hb_l_prm_size = maximum-data-size-of-?-parameter-information-to-be-output-to foreign-server-interface-trace-information-file
[Figure]<unsigned integer>((4-4096)) <<256>> (Bytes)
Specifies the maximum data size (units: bytes) of the ? parameter information to be output in the foreign server interface trace information file.
Condition
pd_hb_l_prm = Y must be specified.

10) pd_hb_l_mode = ALL | PARTIAL

Specifies whether to output all foreign server interface trace information.

ALL: Outputs all information.

PARTIAL: Outputs the information on only the facilities that communicate with the foreign server.