To output the HiRDB SQL Tuning Advisor access path information file, you must set the client environment definitions explained below.

• PDTAAPINFPATH
  Specifies the access path information file output directory. If an error occurs during the output processing (for example, because the output directory does not exist, or because the user does not have write privilege), the access path information is not output. Even when an error occurs in the output processing, no error occurs in the executing SQL.
  
• PDTAAPINFMODE
  Specifies the file name format for the access path information files.
  
• PDTAAPINFSIZE
  Specifies the file size of the access path information files. Two access path information files are created. When the specified file size is reached in the current file, the output destination is switched to the other file.
  

• This function can be used only when the HiRDB server is version 06-00 or later.
• SQL objects with SQL code in a buffer may increase the workload of the HiRDB server due to the need to re-create the SQL objects.
• When this function is used, the inter-process memory communication facility cannot be used. Even if you specify MEMORY in the PDIPC operand of the client environment definition, the operation when DEFAULT is specified takes precedence.
• When you use the dynamic browsing function of the HiRDB SQL Tuning Advisor, the specification of PDTAAPINFPATH in the client environment definition is ignored.
• If you use this function with an HiRDB server earlier than version 07-03, the output path information for the UAP statistics report is not output, even if you have specified that access path information is to be obtained by the UAP statistics report facility (by specifying p or a in the PDUAPREPLVL client environment definition).