SQL Performance Analysis: ANLSQL
This panel shows the actual SQL statement that was analyzed by SQL PA for the report selected in the SQL Performance Analysis: Available Reports panel.
________________ ZSQPO04 VTM O2 V540./C DB51 11/07/13 13:14:55 2
> Help PF1 Back PF3 Up PF7 Down PF8
>
> SQL PA Analysis: ANLSQL Output
>
> A-EXPLAIN B-QLIMIT C-QTRACE D-SYSPRINT *-ANLSQL F-JOBERR
>
===============================================================================
SQPO
> Report=000061 Plan=**NONE** Package=**NONE** Date=2013-11-07 Time=13.09.10
SET CURRENT SQLID = DB2PM ; /* 13:09 11-07-2013 */
EXPLAIN ALL SET QUERYNO = 100000001 FOR
SELECT COUNT(*)
FROM SYSIBM.SYSCOLUMNS ;
=============================================================================== Navigation
You can scroll through the report using F7 (Up) and F8 (Down). F3 (Back) returns to the SQL Performance Analysis: Available Reports panel.
You can select a different report type by choosing one of the options from the menu.