Stores Explain Snapshot information in the Explain tables. This DB2 precompile/bind option is not supported by DRDA.
Syntax:
EXPLSNAP={NO | YES | ALL}
NOEXPLSNAP
Parameters:
| NO |
An Explain Snapshot will not be captured. |
| YES |
An Explain Snapshot for each eligible static SQL statement will be placed in the Explain tables. |
| ALL |
An Explain Snapshot for each eligible static SQL statement will be placed in the Explain tables. In addition, Explain Snapshot information will be gathered for eligible dynamic SQL statements at run time, even if the CURRENT EXPLAIN SNAPSHOT register is set to NO. For more information about special registers, see the IBM DB2 SQL Reference. |
