TPDC Manual (G06.24+)

Using the SPAM Performance Data Charts and
Reports
Tandem Performance Data Collector (TPDC) Manual—526357-001
5-36
SQL/MP Program Overview (SQLPROG)
SQL/MP Program Overview (SQLPROG)
This 76-column chart provides an overview of SQL/MP programs. It is sorted by
descending elapsed busy time (summed over all SQL/MP statements executed by all
processes run from each program file name) so the program objects that spent the
longest time waiting for SQL/MP statement executions are at the top of the list. This
chart includes:
•
Program file name
•
Program’s overall selectivity (total records used divided by total records accessed,
expressed as a percentage
•
Flags for nonzero sorts, recompiles, lock waits, timeouts, and escalations
•
Program’s individual share of total elapsed busy time
•
A chart of the preceding share
•
Cumulative share of total elapsed busy time
This chart uses the GLOBINFO, SQLTOTAL, and PROGSQL 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 Program Overview for System \DEMO (Release C30)
----------------------------
[Total = 1,939 msec/Sec]
Ovrall Wait <-Shr% = %-age of Total--> Cum.
Program File Name Sel'y% SRLTE Shr% 0 5 10 15 20 25 Shr%
------------------------ ------ ----- ==== +----+----+----+----+----+ ----
$DATA8 .DMEXE .PKHC 99.9% L 45.8 |************************> 45.8
$DATA8 .DMEXE .PKIC 100.0% 43.7 |************************> 89.5
$DATA8 .DMEXE .FSND 67.9% L 2.3 |** | 91.8
$SYSTEM .SYSTEM .SQLCI2 99.9% 2.0 |** | 93.8
$DATA8 .DMEXE .TPAFXB 94.9% 1.7 |** | 95.5
$DATA8 .DMEXE .MPKG 89.1% 1.4 |* | 96.9
$DATA8 .DMEXE .DBSRV 75.7% 1.3 |* | 98.2
$DATA8 .DMEXE .MLNT 100.0% L .5 |* | 98.8
+----+----+----+----+----+
0 5 10 15 20 25