DB2 Plan detail line
This is the first-level detail line. Each line shows information about a DB2® Plan under which SQL request measurement data was recorded.
| Under Heading | This is Displayed |
|---|---|
| Seqno | A sequence number assigned, by Application Performance Analyzer, to the DB2 plan. |
| Plan/Pgm | The DB2 Plan name. |
| Nbr of Calls | The number of SQL calls counted for this DB2 Plan. |
| CPU Time: Total | The total CPU time for all SQL calls counted for this statement. Large numbers will be expressed in minutes with an M suffix. |
| CPU Time: Mean | The mean CPU time per SQL call. Large numbers will be expressed in minutes with an M suffix. |
| CPU time: Pct | The percent of total CPU time this plan used. |
| Svc Time: Total | The total service time for all SQL calls for this statement. Large numbers will be expressed in minutes with an M suffix. |
| Svc Time: Mean | The mean service time per SQL call. Large numbers will be expressed in minutes with an M suffix. |
| SVC time: Pct | The percent of total service time this plan used. |