DB2 measurement statistics
A grid of values is shown for the overall DB2® measurement and then a separate grid for each DB2 subsystem. If only one subsystem was observed then only one grid appears.
| Under Heading | This is Displayed |
|---|---|
| DB2 Subsystem Name | The name of the DB2 subsystem. |
| DB2 Version | The version of DB2 for the subsystem. |
| SQL Calls Sampled | The number of unique SQL requests in which samples were taken. |
| SQL observations | The number of samples in which SQL activity was observed. |
| SQL Calls Executed | The number of SQL requests executed determined on the basis of lower and upper REQCT values for each of the DB2 threads. |
| Avg SQL call rate | This is the average number of SQL calls per second for the measurement interval. This is based on the SQL calls counted value if it was measured (DB2+ option active). Otherwise it is based on the SQL calls executed value. |
| SQL Calls Counted | The number of SQL requests counted by the DB2+ measurement feature. This value is available only if the DB2+ measurement option was selected for the measurement. This is an exact SQL request count for the measurement interval. |
| SQL throughput | A theoretical SQL request throughput rate based on the number of SQL requests for the portion of the measurement interval SQL processing was occurring. (Time other non-SQL application activity was taking place is excluded.) This is based on the SQL calls counted value if it was measured (DB2+ option active). Otherwise it is based on the SQL calls executed value. |
| SQL service time | The total service time for SQL processing. This value is available only if the DB2+ measurement option was selected for the measurement. |
| SQL CPU time | The total CPU time in the measured region for SQL processing. This value is available only if the DB2+ measurement option was selected for the measurement. |
| SQL max time | The maximum service time for a single SQL call. This value is available only if the DB2+ measurement option was selected for the measurement. |
| SQL max CPU | The maximum CPU time for a single SQL call. This value is available only if the DB2+ measurement option was selected for the measurement. |
| SQL min time | The minimum service time for a single SQL call. This value is available only if the DB2+ measurement option was selected for the measurement. |
| SQL min CPU | The minimum CPU time for a single SQL call. This value is available only if the DB2+ measurement option was selected for the measurement. |