15.10 - Defining a Workload From DBQL Statements - Teradata Index Wizard

Teradata Index Wizard User Guide

prodname
Teradata Index Wizard
vrm_release
15.10
category
User Guide
featnum
B035-2506-035K

1 Click Workload > Create > From DBQL Statements.

The Define Workload from DBQL Statements dialog box appears.

2 In the QCD Name box, enter the QCD for the workload or click the QCD Name arrow for a list of available QCDs.

3 In the Workload Name box, enter the workload name for the new workload you want to create.

4 Under Select DBQL option, click DBQL (selected by default) to create the workload by browsing queries from DBQL or click External Database to create the workload by browsing workload queries from an external database.

5 Click Views to retrieve the statements from views in the database, or click Tables to retrieve the statements from tables in the database.

6 Click Next. The Select Criteria dialog box appears.

Note: If the QCD name you previously entered does not exist, a message appears asking if you want to create the QCD. Click Yes to create the QCD, or click No to select an existing QCD.

7 Fill in the options under Select Criteria as described in the following table.

 

Group/Option

Option

Description

Select Date

 

Start Date

Enter a start date in the format YYYY-MM-DD to use in searching for queries on or after the date.

If no start date is specified all statements from the DBQL are loaded.

End Date

Enter an end date in the format YYYY-MM-DD to use in searching for queries on or before the date.

If a start date is specified but no end date is specified, all statements from the DBQL beginning at the start date are loaded.

Select Time

 

Start Time

Enter a start time in the format HH-MM-SS to use in searching for queries on or after the start time.

If no start time is specified, the default start time of 00:00:00 is used.

End Time

Enter an end time in the format HH-MM-SS to use in searching for queries on or before the end time.

If no start time is specified, the default end time of 13:59:59 is used.

Step Count

 

Specifies the minimum number of steps for the queries retrieved from the DBQL

Result Rows

 

Specifies the minimum number of rows returned for the queries retrieved from the DBQL

Note: This option is not available if connected to a V2R5 system.

Select Users and Accounts

 

Click to create the workload from queries submitted by a set of users or accounts from the Select Users and Accounts dialog box

Browse a list of users and accounts, and select a user(s) or account(s) to include the search. To make a selection, highlight the name, and click Add. The user/account name is displayed in the right hand side of the dialog box. Do this for each user name and account to include. Click OK to save additions and changes.

Note: By default, all users and accounts are selected.

Select QueryBand

 

 

 

 

 

Name

Enter the name of a Query Band Name-Value pair

Value

Enter the value of a Query Band Name-Value pair

Filter

Enter wild card characters, such as asterisk (*), or question mark (?) to load with query band names and the corresponding values.

List Names

Click to load the names and the corresponding values of query band in the Name-Value list

Add

Click to add the selected Query Band Name-value pair to the Name-Value list

Rem

Click to remove the selected Query Band Name-value pair from the Name-Value list

8 Click Next. The Workload Definition via DBQL dialog box appears showing all the queries retrieved from the DBQL.

To remove a query, select it from the list under ResRows and click Remove.

9 [Optional] Click Additional Criteria to view and edit the SQL statements in the Statement Text Dialog box.

10 Click Back to return to the previous dialog box. Click Finish to create the workload with the selected queries.

11 After the workload is created and stored in the QCD, a Workload Summary dialog box appears, showing the workload. Click OK to complete the workload. definition.