Using QueryGrid Manager to Report Job Status - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
kmo1482331935137.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
QueryGrid Manager is a component of QueryGrid 2.0 that manages all QueryGrid systems. Data Mover uses the QueryGrid Manager REST service to report T2T or T2H progress. Configure the following properties in the configuration.xml file to view the T2T or T2H 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 user name 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>