Statistics Tab
The Statistics tab (Figure 19) shows information about the number and type of requests and responses processed by the Teradata QS server.
Figure 19: 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. |