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

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.10
Release Date
June 2021
Content Type
User Guide
Publication ID
B035-4101-061K
Language
English (United States)
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>