15.10 - Defining Existing Workload DBQL Inputs - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

prodname
Teradata Workload Analyzer
vrm_release
15.10
category
User Guide
featnum
B035-2514-035K

1 Do one of the following:

  • Click in the Workload Analyzer toolbar.
  • Select Analysis > Existing Workload Analysis.
  • Press Ctrl+E.
  • The Define DBQL Inputs dialog box appears.

    2 Fill in the fields as described in the following table:

     

    Option

    Description

    Log Option

    Select the appropriate log from these options:

  • DBQL (this is the default)
  • External DBQL
  • Click the ... button to load the database choices into the selection box, then select the database.

    External DBQL contains DBQL data that has been copied to a database other than DBC. Its table schema can be identical to DBQL, but for improved performance Teradata recommends that DBQL data be copied to a history database defined according to Professional Services guidelines. See Database Administration (B035‑1093).

    Date Range

    In the appropriate boxes, enter the starting date (From) and ending date (To) of the range of the data collected. The displayed date format depends on the regional settings of the PC. To select a date from a calendar pop-up window, click the drop-down arrow. The default end date is one day prior to the current system date; the default start date is one week (7 days) prior to the default end date.

    Time

    Select this option to specify a time window of less than 24 hours.

    In the appropriate boxes, enter the starting and ending times of the range in HH:MM:SS format, using a 24-hour clock. The default start time is 00:00:00 (12:00 A.M.) and the default end time is 23:59:59 (11:59:59 P.M.).

    To select a time that spans midnight, select a start time greater than the end time.

    Note: Teradata WA includes all of the specified end time in its analysis. For example, an end time of 23:59:59 means analyze DBQL data up to and including 23:59:59.99.

    Filter within Range

    Select this option to filter the returned data by days of the week and times of day. When selected, the Every Day and 24 Hours checkboxes become enabled and selected.

    Every Day

    When the Filter within Range check box is selected as described in the previous row of this table, the Every Day check box becomes enabled and selected. If left in that condition, returned data will be captured in the database every day of the week.

    Clear the Every Day check box to select specific days of the week to exclude from data capture.

    When the Every Day check box is cleared, all options in the Day of Week pane are enabled and selected. Clear one or more of the check boxes for options Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, and Saturday to exclude data capture on those days of the week.

    24 Hours

    When the Filter within Range check box is selected as described earlier in this table, the 24 Hours check box becomes enabled and selected. If left in that condition, returned data will be captured in the database 24 hours per day for each day selected for capture as specified by the Every Day option.

    Clear the 24 Hours check box to specify a time window of less than 24 hours during which data will be captured.

    In the appropriate boxes under Time of Day, enter the start time (From) and end time (To) in HH:MM:SS format, using a 24-hour clock. The default start time is 00:00:00 (12:00 A.M.) and the default end time is 23:59:59 (11:59:59 P.M.).

    To select a time spanning midnight, select a start time greater than the end time from the Time of Day box.

    Note: Teradata WA includes all of the specified end time in its analysis. For example, an end time of 23:59:59 means analyze DBQL data up to and including 23:59:59.99.

    Rule set

  • Rule Set - If the rule set is not already entered, click the ... button to load the rule set choices into the selection box, then select a rule set.
  • OpEnv - Select the operating environment for the rule set.
  • Always - the system default operating environment.

    Select All - selects all available operating environments (OpEnvs) for the rule set.

  • SysCon - Select the system condition for the rule set.
  • Normal - the default system condition, which displays the health of the database.

    Select All - selects all available system conditions (SysCons) for the rule set.

    3 After specifying the options, click OK. Teradata WA queries the DBQL.

    Note: The query process may take several minutes.

    The Candidate Workload Report window appears.