Configure Advanced Settings | Setup Portlet | Teradata Data Mover - 17.11 - Configuring Advanced Settings - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-4101-091K
Language
English (United States)
You can configure advanced settings to improve performance and restrict job option choices for Data Mover portlet users. You can configure the maximum load slots and target system restrictions for a daemon.
  1. In the Daemons column, click the name of the daemon you want to configure.
  2. In the Daemon Setup column, click Advanced.
  3. Enter the Maximum QueryGrid T2T Tasks to designate how many QueryGrid T2T tasks can be executed at the same time.
    The default value is read from the daemon. The permitted range is 0 to 1000 inclusive.
  4. [Optional] To enable QueryGrid 2.0 or later to wait for accurate byte counts and report job status, select the For QueryGrid v2.x and higher tasks, wait for accurate byte counts after copying data (will delay job finish) check box.
    This option is not enabled by default.
  5. [Optional] To allow users to specify different character sets when copying data in a job, select the Support different character set for copying check box.
  6. [Optional] To change how many Teradata PT API load or update jobs can be run against target systems at the same time from the default value, do the following under Maximum Load Slots:
    1. Enter the Default Maximum Load Slots, and click Add Load Slot Limit.
      The default value is read from the daemon. The permitted range is 1 to 99999 inclusive.
    2. Select the System from the list and enter the Maximum Slots.
      The number defaults to the system default. The permitted range is 1 to 99999 inclusive.
    3. [Optional] Click "" to designate the maximum slots available for another system.
    4. [Optional] Click "" to remove maximum slots designation from a system.
  7. [Optional] To prevent a system from being available for selection as a target system, select it from the Valid targets box under Target System Restrictions and click the "" button to move it to the Never a Target list.
    An error occurs if a Data Mover user tries to designate an excluded system as a target.
  8. Do not use Additional Users for Target System unless you are upgrading from an older version and were using this feature.
    Use ID Pools instead.
  9. [Optional] To define the source and target systems in a system pair, do the following:
    1. Under Force Direction Pairs, click Add Pair and select the systems from the Source and Target lists.
    2. To allow any statistics in the target database to be returned to the source, select the Allow Stats Back check box.
    3. [Optional] Click "" to add another system pair.
    4. [Optional] Click "" to remove a system pair.
    Users cannot switch the direction after systems are paired as source and target databases.
  10. Click Apply.