Creating Rule Sets from Priority Definition Sets - Teradata Database - Teradata Viewpoint

Workload Pre-Migration User Guide

Teradata Database
Teradata Viewpoint
January 2016
English (United States)
Last Update
Product Category
Analytical Ecosystem

The following procedure outlines the main steps of creating rule sets from PD sets when the process is initiated from the Pre-Migration Tool.

  1. From the Pre-Migration Tool menu bar, click Migration > Migrate PSF Setting.
  2. In the Teradata Workload Analyzer menu bar, click Analysis > Convert PDSets to Workloads. The Select PDSet(s) dialog box appears.
  3. Under Available PDSet(s), click the listing for the PD set to be converted, and verify the following items.
    • The entire row is selected rather than just the cell containing the PD set name. Shading indicates the scope of selection.
    • An OpEnv is selected.
      Operating environment corresponds to performance period. Teradata Workload Analyzer selects operating environments that most closely match the performance periods associated with PD sets. If the default selection is not accurate, select the correct option from the list or click Define Periods to create the required operating environment.
    • Only one PD set is associated with the Default period.
  4. [Optional] Specify the scope for retrieval of active performance groups.
    1. Click DBQL Inputs....
    2. In the Data Collection Interval dialog box, change the values for the Date Range, the Time Window, or both.
    3. Click OK.
  5. Click Proceed. The Existing PSA Setting tab appears.

  6. Review the information for each unique combination of resource partition and operating environment.
    Option Description
    To display information for a different resource partition Select the applicable option from the RP_Name list.
    To display information for a different performance period for the current resource partition Select the applicable option from the OpEnv list.
    To deactivate a performance group Clear the check mark in the Active check box. The check box label changes to Inactive.
    To display allocation group weight information Click the AG Weights button. After reviewing the information in the Existing Priority Scheduler Weights dialog box, click Close.
  7. Under Convert by, click Performance Group.
    Because it provides for programmatic association of performance periods with operating environments, conversion by performance group is recommended over conversion by account.
  8. Click Convert to begin the conversion process. The Migrated TASM Settings tab appears.

  9. If the enforcement priority assigned to an allocation group is inaccurate, select the preferred option from the Enforcement Priority list.
  10. Click Simplified Structure. This option maps the PD set such that the Default resource partition is not used for requests even if the original PD set did so. Instead, a new resource partition is created for the work from the Default resource partition, reserving the Default resource partition for system work. A Tactical partition is created for short-running, high-priority tactical queries, and the remaining work is mapped to the Standard partition.
  11. Click Continue. The system creates a rule set based on the PD set, with candidate workloads being created based on the allocation groups in the PD set.
    The conversion process usually creates one workload for each account found. However, if a query milestone is associated with an allocation group, two workloads result. Such workloads are named to reflect the account name appended with different numerals. For ease of identification, you can rename these as well as any other workloads in the Standard partition, each of which is also named based on the account associated with the corresponding allocation group. To do so, right-click the workload listing, select Rename, type the preferred Name and, optionally, Description in the displayed dialog box, and click OK.
  12. Under Parameters, click View CPU Distribution, and review the information for each operating environment.
  13. [Optional] If you have secured TASM licensing for use in SLES 11 and intend to assign workloads to the SLG tier, review and adjust as necessary service level goals for those workloads.
    1. In the Teradata Workload Analyzer menu bar, click Rule Set > Calculate All WD SLGs. A progress bar appears, followed by a display of SLG Recommendations.
    2. In the rule set tree, expand the workload branch for which you want to access service level goal settings, and click SLG Graph.

    3. Change the various display parameters as necessary to review the required information.
    4. Set options and values to define the required service level goals for the workload.
    5. Click Apply.
  14. When you are ready to save the rule set, click Rule Set > Save to Database.