TPDC Manual (G06.24+)

Using the SPAM Performance Data Charts and
Reports
Tandem Performance Data Collector (TPDC) Manual—526357-001
5-37
SQL/MP Statement Overview (SQLSTAT)
SQL/MP Statement Overview (SQLSTAT)
This 74-column chart identifies the longest-running SQL/MP statements. These are not
individual executions of a statement, but sums of executions of the same logical
statement by all running copies of programs that contain the statement.
All executions of a statement by the same program-file-name, run-unit, statement-
index combination are summed before this table is produced.
This chart is ordered by descending elapsed busy time (summed over all executions of
the statement by all processes run from the program file name).
This chart includes:
•
Program file name
•
Run unit name
•
Statement index (SLT)
•
Statement’s selectivity (total records used divided by total records accessed,
expressed as a percentage)
•
Statement’s share of the system’s total elapsed busy time
This chart uses the GLOBINFO, SQLTOTAL, and SQLSUM entities
Parameters used are:
•
LID—specifies the Measure Load ID
•
SECTION—specifies the report section number
The chart is sorted in descending elapsed busy time.
NonStop SQL Statement Overview for System \DEMO (C30)
------------------------------
Wait
Program File Name Run Unit Name SLT Sel'y% Shr%
-------------------------- ------------------------------- --- ------ ====
$DATA8 .DMEXE .PKHC __SQLRTDU_0075141491527496447H 3 99.9% 45.8
$DATA8 .DMEXE .PKIC __SQLRTDU_0075141491553895318D 2 100.0% 43.7
$DATA8 .DMEXE .TPAFXB __SQLRTDU_0075140605608153852B 1 100.0% 1.3
----
----
90.7