Argument

access-path-information-file ~<pathname>
If you specify 1 or a greater value in the PDVWOPTMODE client environment definition variable, the utility stores the access path information in the access path information file.
This argument specifies the access path information file that is to be subject to the execution of the access path display utility. For details about the PDVWOPTMODE client environment variable, see the HiRDB Version 9 UAP Development Guide.
The access path information file is created under the SQL information directory ($PDDIR/spool/pdsqldump) at the unit that contains the single server or front-end server accessed by the UAP.
Information is collected for each pair of CONNECT and DISCONNECT statements. HiRDB assigns the following name to each access path information file:

authorization-identifier_UAP-source-file-name_identification-number_server-type

authorization-identifier: Authorization identifier specified in the CONNECT statement.

UAP-source-file-name: Specifies the name of the UAP source file.; If the name is longer than 30 bytes, only the first 30 bytes are effective.; If the SQL was executed by the interactive SQL execution utility (pdsql), pdsql-process-ID, pdsql.exel-process-ID, or pdsqlwl-process-ID is used as the UAP source file name.

identification-number: Number used to identify the set of statements from CONNECT through DISCONNECT.

server-type: s for a HiRDB single server configuration; p for a HiRDB parallel server configuration.

Examples of access path information file names:: USER1_sample.ec_1-1-01_s; USER2_pdsql-00001_1-1-01_p