DB2Explain IBM data server driver configuration keyword
Determines whether Explain snapshot, Explain table information, or both information are generated by the server.
- Equivalent CLI keyword
- DB2Explain
- Equivalent IBM® data server provider for .NET connection string keyword
- DB2Explain
- IBM data server driver configuration file (db2dsdriver.cfg) syntax
<parameter name="DB2Explain" value="Off | Snapshot | Table | SnapshotAndTable"/>- Default setting:
- Default string value is Off.
- Usage notes:
- The DB2Explain setting contains information about the access method by which the database processes your SQL statement. This information is useful for analyzing and improving the performance of your queries.