Additional considerations for EXPLAIN

The EXPLAIN primary command constructs and runs an SQL EXPLAIN statement. For the explain statement to run successfully, a plan table (called PLAN_TABLE) must exist with an owner name matching your current SQL authorization ID. Db2® places the results of the EXPLAIN statement in the plan table.

FM/Db2 also places relevant data in a statement table (called DSN_STATEMNT_TABLE) and a function table (called DSN_FUNCTION_TABLE) if they exist.

You can access the statement and function table rows related to a plan table row by using line commands.

Related tasks

• Explaining SQL
• Managing tables used by SQL explain

Related references

• COL primary command
• PLAN primary command
• HINT primary command