The DB2 Explain SQL 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 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 |