16.20 - Statistics Tab - Query Scheduler

Teradata Query Scheduler User Guide

prodname
Query Scheduler
vrm_release
16.10
16.20
created_date
May 2017
category
User Guide
featnum
B035-2512-086K

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

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.