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

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
Product Category
Analytical Ecosystem

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 a Teradata system 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 a Teradata system 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.