IBM Books

Command Reference

db2expln - DB2 SQL Explain Tool

Describes the access plan selection for static SQL statements in packages that are stored in the DB2 common server system catalogs. Given a database name, package name, package creator, and section number, the tool interprets and describes the information in these catalogs. This tool is located in the misc subdirectory of the instance sqllib directory.

For a complete description of this command, see the Administration Guide.

See Also

db2exfmt - Explain Table Format Tool.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]