This feature supports a new immediate keyword option to the onmode -q explain session-id command to read and send as output to a specified file the optimizer plan for a currently executing query. This command is valid only on the connection coserver.
The keyword immediate is valid in onmode commands in the following syntactic contexts, where session-id is the identifier of a session that is currently executing a query, and filename is a valid file specification (which can include a pathname):
This prints the query plan to the sqexplain.out file in the current working directory ($CWD).
This prints the query plan to the filename file in the $CWD/pathname directory (or in $CWD, if filename includes no pathname).
This appends the query plan to the existing filename file in the $CWD/pathname directory (or in $CWD, if filename includes no pathname).
Other options of the onmode -q explain session-id command are not changed in their behavior by this feature.
For more information about this feature, see Displaying the Optimizer Plan of an Executing Query.
For more information about command-line options of the onmode utility, see Appendix A. Syntax Summaries of Selected Utilities.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]