Defining a Workload From DBQL Statements
To define a workload from DBQL statements
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.