DB2 Explain SQL

The DB2 Explain SQL context menu action displays detailed SQL query information for the requested report line. DB2 Explain SQL is only available for 'F' - DB2 Measurement reports. When selected, a new window will display two tabs; SQL Information and SQL Text.

Note: This action is only available if the z/OS connection has been established and the remote repository is active.



DB2 Explain SQL context menu

The SQL Information tab provides a detailed overview of the SQL statement.



SQL Information tab

The SQL Text tab displays the SQL text statement that can be used as input to DB2 or Visual Explain products. The contents can be copied (Ctrl+A to select all then right mouse-button click and select 'copy' or Ctrl+C) then pasted to an editor or other tool.



SQL Text tab