Use Query Band | Teradata Data Mover - Using Query Band - Teradata Data Mover

Teradata® Data Mover User Guide - 20.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Data Mover
Release Number
20.01
Published
November 2023
Language
English (United States)
Last Update
2023-12-05
dita:mapPath
hlv1700545853003.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
don1467241476387
Product Category
Analytical Ecosystem
Use query band to tag sessions or transactions in the database. In Data Mover, you can enable or disable the default query band feature using the daemon configuration parameter job.default.queryband.enabled. If the default query band feature is enabled, Data Mover uses the default daemon-level query band job.default.queryband property value such as the following example:

ApplicationName=DM;Version=16.20;

You can update the default query band property value with the enabled or disabled command job.default.queryband.enabled. This property value is used in the command parameters list_cofiguration and save_configuration.

You can provide a query band value at the job level using the query_band xml tag or the REST queryBand value when running create, move, or edit job. If the default query band feature is disabled, you must provide the query band value at job level to use query band; otherwise, query band not used.

  1. Use the appropriate query band level steps to set the query band property values:
    Query Band Level Steps
    Job Level At the job level, query band has a higher priority than the default query band at daemon level.
    1. Create a job definition with a list of objects to move, appending the <query_band></query_band> element before the final closing tag </dmCreate>.
    2. Enter the query band information as a set of semicolon-separated name value pairs between the query band elements as in the following example:

      <query_band>Job=payroll;Userid=aa1000000;Jobsession=1122;</query_band>

    3. Add or modify the <query_band> value using the create, move, or edit job commands.
    Daemon Level At the daemon level, query band settings are applicable to all jobs. Use the list_configuration or save_configuration commands to update property values.
    1. To enable the default query band feature, set the job.default.queryband.enabled property as true.
    2. Set the default query band property, job.default.queryband, with the appropriate values.