Adding Initial Workload Periods for PSA Migration - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
17.00
Published
September 2019
Language
English (United States)
Restricted Access
TTU-17.00-EAP
Last Update
2019-06-07
dita:mapPath
vjd1544831946946.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2514
Product Category
Teradata Tools and Utilities
Before PSA migration, system periods must be set up to associate with the workloads. Defining multiple system periods allows the system to handle workloads differently depending on the time of day, day of the month, and so on. In addition, allocation groups and resource partitions that are defined in Priority Scheduler Administrator or Teradata Dynamic Workload Manager can be associated with the workload periods.
There are three options for defining system periods:
  • Import system periods from any rule set by clicking Import From Ruleset
  • Import system periods from a .pds file by clicking Import From File
  • Create a new system period by clicking Add Period
  1. Open the Define Periods (Operating Environments)dialog box in one of the following ways:
    • Click on the Workload Analyzer toolbar.
    • Click Tools > Define System Periods.
    The following table describes the options of the Define Periods (Operating Environments) dialog box.
    Option Description
    Import From Ruleset Imports system periods from an existing rule set.
    Import From File Imports system periods from a file.
    Save To File Saves system periods to a .pds file.
    Periods Displays available system periods.
    Description Displays descriptions of available system periods.
    Add Period Adds a new system period to the Periods list.
    Delete Period Deletes the selected system period from the Periods list.
    Everyday Defines this period for every day usage. This is the default setting.
    Day of Week Defines this period for usage on specific days of every week. If using this option, click the check box for each day of the week to be included.
    Month/Day Defines this period for usage on specific months of the year and days of the month. Click the Months button to display the Select Months dialog box; under Select Months, click the check box for each month to be included and click OK. Then click the Days button to display the Select Days dialog box; under Select Days, click the check box for each day to be included and click OK. Notice that the Months box under the Date/Time tab shows the numerals for the months or days selected. If there is a range of days or months, these may be separated by a comma or a hyphen as appropriate.
    24 Hours Defines this period for usage 24 hours at a time. To define the period for less than 24 hours at a time, de-select this check box.

    The default is “selected”.

    From Defines the period starting time, where HH can be any hour from 0 (12:00 A.M.) to 23 (11:00 P.M.) and MM can be any number of minutes from 0 to 59. The default start time is 0:00.
    To Defines the period ending time in HH:MM format, where HH can be any hour from 0 (12:00 A.M.) to 23 (11:00 P.M.) and MM can be any number of minutes from 0 to 59. The default end time is 23:59.
    Wrap Around Midnight to Next Day Defines a range in time that spans midnight for system periods to be in effect.
    When the numeric value of the time specified in the From text box is greater than the numeric value of the time specified in the To text box, two conceptual time segments are available:
    • Start at midnight until the time specified in the To text box.
    • Start from the time specified in the From text box to midnight.
    Accept Accepts the changes made to the Time box.
  2. To import the periods from a rule set:
    1. Click Import From Rule Set.

      The Select Rule Set dialog box appears.

      Active Rule Set displays the currently active rule set.

    2. Click on a row in the Existing Rule Sets list to select a different rule set, or click Use Active Rule Set to continue using the active rule set.
    3. Click OK to save the selection.
  3. To import the periods from a file:
    1. Click Import From File. The standard Open file dialog appears.
    2. Select the appropriate .pds file then click OK.
  4. To create a new system period:
    1. Click Add Period. The Add Period dialog box appears.
    2. In Period Name, type a name for the new period.
    3. In the Description, type a brief description of the period.
    4. Click OK. The new period name displays in the Periods list.
    5. Clear the Everyday check box and define the days and months that this workload period should be in effect.
    6. Clear the 24 Hours check box to define the hours that this workload period should be in effect.
    7. Click the Date/Time tab and define the days and times that this workload period should be in effect.
    8. After completing these changes, click Accept.
    9. Click Save to File. The new system period is saved to a .pds file.