To execute the access path display utility, use the following procedure:

Client

1. Set the client environment variables. For details about the client environment variables see the HiRDB Version 9UAP Development Guide.
2. Execute the UAP containing the SQL for which access path information is to be obtained. There is no need to complete the UAP's processing; the access path information file is created when the statements from CONNECT through DISCONNECT have executed.

Server

1. Execute the access path display utility at the server machine that contains the single server or front-end server accessed by the UAP.

Execution

$PDDIR/bin/pdvwopt $PDDIR/spool/pdsqldump/USER1_pdsql-00001_1-1-02_p