QUALIFIER statement and parameter
The QUALIFIER statement uses qualifier values to filter the data loaded into the tables.
When used as a parameter of the TABLE statement, the included or excluded qualifiers relate only to the tables that are specified in that TABLE statement. The QUALIFIER parameter overrides default qualifiers and any previously specified QUALIFIER statement.
Valid abbreviations for QUALIFIER are QUAL and Q. The following figure shows the syntax of the QUALIFIER statement and parameter.
The INCLUDE and EXCLUDE table and the QUALIFIER statement values table provide details and permissible values of the keywords for the QUALIFIER statement and parameter.
The INCLUDE and EXCLUDE keywords filter the records that are selected to satisfy loaded table requests. You can specify either INCLUDE or EXCLUDE for each qualifier type, but you cannot specify both of them. INCLUDE is the default selection.
INCLUDE and EXCLUDE
Value | Description of value |
|---|---|
INCLUDE | Includes in the tables only records with the qualifier values that are specified in this statement Valid abbreviation: I |
EXCLUDE | Excludes from the tables records containing the qualifier values that are specified in this statement The EXCLUDE keyword cannot be specified with Db2. Valid abbreviation: E |
The type values define the type of qualifiers to be included or excluded. At least one qualifier type must be specified.
At least one value is required for each specified qualifier type. Multiple values must be separated by commas (,). Wildcards are permitted. For more information about wildcards, see Using Wildcards.
QUALIFIER statement values
Value | Description of value |
|---|---|
APPGROUP | Application group Valid abbreviations: APGRP, AG |
BP | Buffer pool ID Valid abbreviation: B |
CALLTYPE | Type of SQL statement that was executed Valid values: STATIC or DYNAMIC No abbreviation |
CONNECTION 1 | Connection ID Connection type (APPL-DIR, CICS, DB2 CALL, DB2 UTILITY, DLIBATCH, IMS ATT BMP, IMS ATT MPP, IMS CTL, IMS TRAN BMP, RRSAF ATTACH, SYST-DIR, TSO) Valid abbreviations: CONN, N |
CORRELATION | Correlation ID Valid abbreviation: CORR |
DB2 | Db2 SSID The EXCLUDE keyword cannot be specified with Db2. Valid abbreviation: U |
DBNAME | Database name Valid abbreviation: DBN |
DSGROUP | Data sharing group 8 characters or less; wildcards not supported Valid abbreviation: DSG |
DSGROUP | End user (client) workstation name 18 characters or less, wildcards supported |
ENDTNAME | End user (client) transaction name 32 characters or less, wildcards supported |
ENDWNAME | End user (client) user id 16 characters or less, wildcards supported |
LOGICALDB2 | Logical Db2 name The logical Db2 name is the name of a data sharing group, or the name of a Db2 subsystem that is not part of a data sharing group. Valid abbreviation: LDB2 |
OPERATOR | Original operator ID Valid abbreviations: OPER, OPID, O |
PAGESET | Page set name Valid abbreviation: PGS |
PLAN | Plan name Valid abbreviation: P |
PROGRAM1 | Database request module or package name Valid abbreviation: PROG |
STMTTYPE | Statement type, corresponding to statement types reported in Apptune(such as FETCH, OPEN, CLOSE), with underscores instead of blanks (for example, CALL_STATEMENT) 22 characters or less, wildcards not supported No abbreviation |
TBCREATOR | Table creator Valid abbreviation: TBC |
TBNAME | Table name The length of this field can be up to 128 characters. To continue the field on the next line, add a hyphen (-) to the last character of the line, and continue the name field on column 1 of the next line. Valid abbreviation: TBN |
TEXTHASH | Text hash or key, as reported in Apptune reports SQMBSTMT or SQMBTEXT You can use a text key from one of these reports as a qualifier to select data for the corresponding statements in SQMBSTMT, SQMCACTX. 20 hexadecimal characters, wildcards not supported Valid abbreviations: TXTH or TH |
1 If you are producing a report with SAP data:
- Specify CONN(connectionID) in your QUALIFIER statement or parameter to report work process numbers.
- Specify CORR(correlationID) to report work process IDs.
- Specify G(DBRM/package) to report servers.
Using Wildcards
Only an asterisk (*) and exclamation mark (!) are valid wildcards.
An asterisk, when used alone, matches all values for the identifier. All characters following an asterisk are ignored.
An asterisk, when used alone, matches all values for the identifier. All characters following an asterisk are ignored except the PROGRAM type. For the PROGRAM type, you can place an asterisk anywhere in the mask to specify any number of characters.
An asterisk, when used at the end of a character string matches all identifiers beginning with that character string.
An asterisk, where components of a qualifier are separated by a period (.), can be used within each component.
The exclamation point is used to replace a single character at any position in a string. You cannot use this wildcard in the text hash or data sharing group qualifier.
Related topic