Configuring a Workload

When you include an object in multiple workloads in the same job, the object settings might not match, which creates a conflict at run time. For more information, see Workload Settings Conflict Resolution.

Note:
Teradata Hybrid Cloud Manager does not migrate the following items:
  • User-defined types
  • User-defined functions/external stored procedures
  • Foreign server definitions
  • Tables with circular referential integrity
  1. On the Overview page in the Getting Started section, click Add a Workload.
  2. Under Workload Settings, enter the required information and click SAVE.
  3. Add a database or individual objects to the workload.
    Adding a user database copies the objects in the database but not does not apply access rights unless you select the user as one of the user workloads.
    Screen Action
    Databases
    1. Click .
    2. Select one or more databases and click Add n Selected.
    Adding a database to the workload automatically includes all of its associated objects at run time. However, on the Workloads Overview screen, the Objects number does not reflect the total number of objects in each included database. Included objects do not appear on the Objects screen.
    Objects
    1. Click .
    2. Select one or more objects and click Add n Selected.
    The total number of objects included on the Objects screen updates the total number of objects on the Workloads Overview screen.
  4. [Optional] On the Objects screen, select one or more objects to modify the object settings.
    Included objects automatically inherit the default settings that you define when configuring a job.
    Option Description
    Foreign View

    [Tables only]

    Uses QueryGrid to create a view on the target system that points back to the original table on the source system.

    Common use cases: (1) a large source table not heavily used by the workload, or (2) a frequently-updated source table for which the workload requires access to the most recent data.

    Copy Statistics

    [Tables, hash indexes, and join indexes only]

    Copies statistics from the source to the target system. This option is not available if the object is copied as a foreign view.
    Skip Does not copy an object if it already exists on the target system.
    Exclude Excludes objects from the workload.

    Common use case: if you select an entire database (which includes all its associated objects) but want to exclude temporary or unused objects.

    Include Includes an object that was previously excluded.
  5. On the Users screen, select individual users to copy to the target system.
    Copying users to the target system applies the same permissions they have on the source system.

results matching ""

    No results matching ""