SQL Request detail line
This is the second-level detail line. It quantifies an individual SQL statement.
| Under Heading | This is Displayed |
|---|---|
| Seqno | A sequence number assigned to uniquely identify the SQL statement. Either “S” or “D” precedes the sequence number, indicating whether the SQL statement is static or dynamic. |
| DB2® Call | The DBRM name, precompiler statement number and SQL function. When the statement number is zero, it indicates that the SQL statement was not produced by the DB2 precompiler or the SQL preprocessor, but was generated by some other means. For example, JDBC SQL statements have statement numbers that are zero. |
| Nbr of SQL Calls | The number of SQL calls counted for this SQL statement. Large numbers will be expressed in thousands or millions with a K or M suffix. |
| CPU Time: Total | The total task CPU time for all SQL calls counted for this SQL statement. Large numbers will be expressed in thousands or millions with a K or M suffix. |
| CPU Time: Mean | The mean task CPU time for all SQL calls counted for this SQL statement. Large numbers will be expressed in thousands or millions with a K or M suffix. |
| CPU Time:Pct | The percent of total CPU time this SQL statement used. |
| SVC Time: Total | The total service time (elapsed time) for all SQL calls counted for this SQL statement. Large numbers will be expressed in thousands or millions with a K or M suffix. |
| SVC Time: Mean | The mean service time for all SQL calls counted for this SQL statement. Large numbers will be expressed in thousands or millions with a K or M suffix. |
| SVC Time:Pct | The percent of total service time this SQL statement used. |