Report Job Status using QueryGrid Manager (QGM) | Teradata Data Mover - Using QueryGrid Manager to Report Job Status - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-06-16
dita:mapPath
fcu1619423186706.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
QueryGrid Manager is a component of Teradata QueryGrid™ 2.0 that manages all QueryGrid systems. Data Mover uses the QueryGrid Manager REST service to report T2T progress. Configure the following properties in the configuration.xml file to view job status:
  1. Enter either the queryGridManagerPassword or the queryGridManagerEncryptedPassword to access the QueryGrid Manager REST service.
  2. Enter the queryGridManagerUser user.
    The default user is Support. The username must be the same in QueryGrid Manager and Data Mover.
  3. Set queryGrid.wait.final.status to true to wait until job status is returned from QueryGrid.
    Data Mover pulls the job status from QueryGrid Manager, but cannot always report the final status due to a delay from the QueryGrid REST service. When the final status is not available and queryGrid.wait.final.status is set to false, Data Mover displays the status as N/A. When queryGrid.wait.final.status is set to true, Data Mover continues to request the status until the final status is returned or a timeout occurs. This impacts job completion time.
    <property>
        <key>queryGridManagerEncryptedPassword</key>
    <value>618f01fd9a1f0081ccb5ee4bc71d345fbf8b5ccb095f6bc0c89e390416622ee1</value>
        <description>Purpose: Set Querygrid Manager user encrypted password, cannot provided together with queryGridManagerPassword</description>
    </property>
    <property>
        <key>queryGridManagerPassword</key>
        <value></value>
        <description>Purpose: Set Querygrid Manager user password, cannot provided together with queryGridManagerEncryptedPassword</description>
    </property>
    <property>
        <key>queryGridManagerUser</key>
        <value>support</value>
        <description>Purpose: Set Querygrid Manager user, default value is support.</description> 
    </property>
    <property>
        <key>querygrid.wait.final.status</key>
        <value>true</value>
        <description>Purpose: Set if need to wait for Querygrid Manager to return final task status. There will be performance impact when set to true.</description>
    </property>