SQL Performance Analysis: Available Reports

This panel lists currently available SQL PA reports. use this list to select a report, which provides access to panels that display detailed information about the selected report, or to perform maintenance actions on the listed reports.


________________ ZSQPL    VTM     O2       V540.#P DA41 11/06/13 16:00:04   2 
>  Help PF1        Back PF3         Up PF7         Down PF8         Zoom PF11  
>                                                                              
>                         SQL PA Analysis: Available Reports                   
>                                                                              
>  PF11 (zoom) to Review Report Detail                                         
>                                                                              
>  Actions: D-Delete   C-Cancel   B-Scope to Public   V-Scope to Private       
>                                                                              
===============================================================================
 SQPL                                                                          
>  Rept # Status   Plan     Package  SQL St# Date       Time     Creator  Pub  
>  ------ -------- -------- -------- ------- ---------- -------- -------- ---  
: _000006 FAILED   DSNESPRR DSNESM68 0000259 2011-09-16 17.45.05 OMINSTAL Y    
: _000017 SUCCESS  **NONE** **NONE** 0000000 2012-04-13 15.19.24 OMINSTAL Y    
: _000020 RUNNING  DSNESPCS DSNESM68 0541779 2013-11-06 16.02.48 OMUSER#P N    
===============================================================================

Navigation

You can scroll through the list using F7 (Up) and F8 (Down), or select a particular list item and press F11 (Zoom) for additional information.

For additional options
  • select one of the options from the menu.
  • use the PF keys.

Actions

You can refresh the list of current SQL PA reports by pressing Enter.

Use F11 (Zoom) to obtain access to the different report types (Enhanced Explain, Query Limits, Trace).

You can apply the following maintenance actions on a single SQL PA report by typing the corresponding letter left to one of the listed reports. Some actions are permitted only if you are the creator of the report.
D-Delete
Creator only: Deletes a particular SQL PA report. Applicable if the report status is READY, FAILED, or CANCELED.
C-Cancel
Creator only: Cancels an active SQL PA invocation. Applicable if the report status is RUNNING. (The status changes to CANCEL. Keep hitting the Enter key until the status changes to CANCELED.)
B-Scope to Public
Creator only: Marks the report as public so that other users can see the report output. Applicable if the report status is READY, FAILED, or CANCELED.
P-Scope to Private
Creator only: Marks the report as private so that other users cannot see the report output. Applicable if the report status is READY, FAILED, or CANCELED.

Fields

Rept #
The unique report number (identical to the Performance Warehouse log identifier).
Status
The current status of the report.
SUCCESS
The report has completed successfully.
RUNNING
The report is currently running.
FAILED
The job for this reported has failed, based on the completion code from SQL PA.
CANCEL
There is a pending Cancel request for this SQL PA invocation.
CANCELED
The report request was canceled.
Plan
The plan from which the SQL was taken.
Package
The package from which the SQL was taken.
SQL St#
The SQL statement number.
Date
The date when the report was run.
Time
The time when the report was run.
Creator
The creator of the report. The ID of the creator is dependent on a couple of factors:
  • If the signon security interface has been enabled, the creator ID is the identification used by the user to sign on.
  • If the security interface has not been enabled, but signon profiles are used, the creator ID is of the form OMUSERxx, where xx is the 2-character OMEGAMON® profile name.
  • If neither the signon exit nor signon profiles are used, a default ID of OMINSTAL is used.

Users can only see reports that they have created or reports that other users have marked as public.

Pub
Indicator whether the report is currently public (Y) or private (N). Public reports are viewable by any user. Private reports are only viewable by the report's creator. Only the creator of the report can switch the status between Public and Private.