2.10 - Using APIs to Monitor Queries Between Teradata and a Foreign Server - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

prodname
Teradata QueryGrid
vrm_release
2.10
created_date
September 2019
category
Administration
Configuration
Installation
User Guide
featnum
B035-5991-099K

To monitor the data transfer between Teradata and a foreign server per a user request, you can use the following APIs:

  • PM/API MONITOR SESSION
    If you are using the MONITOR SESSION request, set the mon_ver_id to 11, where mon_ver_id is the monitor software version ID field for the current release.
  • Open API MonitorMySessions
  • Open API MonitorSession
The APIs return the following values.
Field Name/Column Name Description
ReqTblOpBytesIn Total number of bytes transferred into Teradata Database from a foreign server for the current request through one or more table operators.
The request may involve one or multiple table operator executions. The ReqTblOpBytesIn output parameter shows bytes transferred across all invocations within the request.
ReqTblOpBytesOut Total number of bytes transferred out of Teradata Database and into a foreign server for the current request through one or more table operators.
The request may involve one or multiple table operator executions. The ReqTblOpBytesOut output parameter shows bytes transferred across all invocations within the request.