SQL Call execution detail line
This is the first-level detail line. Each line shows information about one SQL call.
| Under Heading | This is Displayed |
|---|---|
| Thread | A sequence number identifying the DB2® thread. Application Performance Analyzer assigns a unique sequence number to each DB2 thread that was observed. |
| REQCT | The REQCT value for the SQL call. |
| Program | The name of the DBRM in which the SQL call was defined. |
| Stmt# | The precompiler statement number of the SQL statement. |
| SQL Function | The SQL function performed by the reported statement: SELECT, INSERT, UPDATE, etc. |
| Samps | The number of samples recorded for the interval described by this report line. This can be zero if the identified SQL call was measured by the DB2+ feature but not sampled. |
| Call Time | When the DB2+ feature is not active this is the time at which the first sample in the sequence of samples reported by this line occurred. When the DB2+ feature is active each report line shows the time at which the identified SQL call started. The time is shown in minutes, seconds and hundredths of seconds. |
| Interval | When the DB2+ feature is not active, this is the duration of the interval, in seconds, during which samples were recorded for the indicated SQL call. This can provide a good indication of the service time for the SQL call. When the DB2+ feature is active, this is measured directly by the DB2+ feature. |
| CPU Time | The CPU time, in seconds, for the reported SQL call as measured by the DB2+ feature. If an SQL call was not measured by the DB2+ feature but was sampled, the CPU time will be reported as Not Available (N/A). This might occur at the beginning of a measurement before the DB2+ feature completes initialization, depending on the sampling rate and system activity. |