Viewing the last set of generated reports

You can use the LASTREPORTS command to view the last set of generated reports without re-running the EXPLAIN command.

Procedure

To view the last set of generated reports, issue the LASTREPORTS command on any of the following panels:
  • ANLPPKGE
  • ANLPDBRM
  • ANLPFILE
  • ANLPQNO
  • ANLPQMF
  • ANLPSDQ
If the last set of reports was generated by running the EXPLAIN command on the ANLPQNO panel, the plan table report is displayed. If the last set of reports was generated by running the EXPLAIN command on a panel other than the ANLPQNO panel, the query limits report is displayed.