The Statistics tab shows information about the number and type of requests and responses processed by the Teradata QS server.
Server Information Dialog Box: Statistics Tab
| Option | Description |
|---|---|
| Total Requests | The total number of requests processed by the Teradata QS server request processors. |
| Final Responses | The total number of final responses sent by the Teradata QS server. |
| Intermediate Responses | The number of intermediate responses sent by the Teradata QS server. |
| Explain Errors | The number of times the Teradata Database returned an error for an Explain of a user request. The cause is most likely that Teradata QS does not have the proper database permissions to execute that type of request. |
| Parser Errors | The number of times a statement request could not be parsed by the parser utility used by Teradata QS. |
| Update Collisions | The number of times a deadlock status was received from the database when Teradata QS updated its host_status table. |
| Types of Requests Processed | |
| Connects | The number of connect requests processed. |
| Disconnects | The number of disconnect requests processed. |
| Scheduled Requests | The number of scheduled requests messages (of all types) processed. |
| Query Requests | The number of query requests processed. If this number is non-zero, there are DBQM-enhanced ODBC drivers that are using this server for query authorization. |
| Information | The number of information messages processed. |
| Cancels | The number of (query) cancel messages processed. |
| Other | The number of miscellaneous messages processed. |
| Query Results | The number of query results messages (indicating that a query has completed) processed. |
| Stmts Checked | The number of statement requests checked for rules. Some types of requests, such as DDL, are not checked by Teradata QS. |
| Multiple Stmts | The number of statement requests containing more than one SQL statement in the request. |