QUALIFIER statement and parameter

The QUALIFIER statement uses qualifier values to filter the data to be included in reports that are produced by subsequent REPORT statements in the same job stream.

If default qualifiers are specified in the report, the QUALIFIER statement overrides those default qualifiers. If the qualifiers are locked in any of the requested reports, a message is printed in the Report Disposition Summary, and the default qualifiers are used for those reports.

When used as a parameter of the REPORT statement, the included or excluded qualifiers relate only to the reports that are specified in that REPORT 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 following tables 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 report requests. You can specify either INCLUDE or EXCLUDE for each qualifier type, but you cannot specify both of them. INCLUDE is the default selection.

Value	Description of value
INCLUDE	Includes in the reports only records with the qualifier values that are specified in this statement Valid abbreviation: I
EXCLUDE The EXCLUDE keyword cannot be specified with DB2	Excludes from the reports records containing the qualifier values that are specified in this statement Valid abbreviation: E

The type values define the type of qualifiers to be included or excluded. At least one qualifier type must be specified. Multiple values must be separated by commas (,). Wildcards are permitted (Show in following point - Using Wildcards ).

Note

For a list of appropriate qualifiers for each report, see Valid qualifiers for Data Collector reporting.

type parameter

Value	Description of value
AUTHID	Authorization ID Valid abbreviations: AUTH, A
COLLECTION	Collection ID Valid abbreviation: COLL
CONNECTION	Connection ID Valid abbreviations: CONN, N
CONTYP	Connection type (DRDA, CICS, DB2_CALL, DB2_UTILITY, DLI, IMS_ATT_BMP, IMS_ATT_MPP, IMS_CTL, IMS_TRAN_BMP, RRSAF_ATTACH, RMT_PRIV_PRO, TSO) Valid abbreviation: CONT
CORRID	Correlation ID Valid abbreviations: CORR, C
DB2 ¹	DB2 SSID Valid abbreviation: U
ENDUNAME	End user name Valid abbreviation: EUN
ENDWSNAME	End workstation name Valid abbreviations: ENDWSN, EWN, EUW
ENDTNAME	End transaction name Valid abbreviation: ETN
LLOCATION	Local location Valid abbreviations: LLOC, KL
OPERATOR	Original operator ID Valid abbreviations: OPID, OPER, O
PACKAGE	Package or DBRM name Valid abbreviations: PROGRAM, PROG, G, DBRM
PLAN	Plan name Valid abbreviations: P
RLOCATION	Requesting location Valid abbreviations: RLOC, KR
ROLE	Role name Valid abbreviation: no abbreviation

^{1 The EXCLUDE keyword cannot be specified with DB2.}

Although you are not prevented from specifying any qualifier with any report, not all qualifiers are valid for all reports. Be careful to choose qualifiers that are appropriate to the data that you are collecting.

The following table lists the reports that have been designed specifically for Data Collector reporting and indicates which qualifiers are valid with each report.

Valid qualifiers for Data Collector reporting

Report	Description	Valid Qualifiers
BACCPKSR	Thread accounting package summary	Authorization ID Collection ID Connection Type Package Name Plan Name Role
BACCTDR	Accounting detail trace long	Authorization ID Connection Type DB2 End Transaction End User Name End Workstation Local Location Package Name Plan Name Role
BACCTLT	Accounting detail trace long	Authorization ID Connection ID Connection Type Correlation ID DB2 End Transaction End User Name End Workstation Local Location Operator ID Package Name Plan Name Remote Location Role
BACCTSR	Accounting summary short	Authorization ID Connection Type DB2 End Transaction End User Name End Workstation Local Location Package Name Plan Name Role
BACCTST	Accounting detail trace short	Authorization ID Connection ID Connection Type Correlation ID DB2 End Transaction End User Name End Workstation Local Location Operator ID Package Name Plan Name Remote Location Role
BAUDTAUT	DB2 authorization failures	Authorization ID Correlation ID DB2 Package Name Plan Name
BDB2UTIL	DB2 utility events	DB2
BDEADLCK	DB2 deadlock report	DB2 SSID AUTH CORRID CONNECTION PLAN ENDUNAME ENDWSNAME ENDTNAME
BIOSUM	I/O active summary report	SSID LLOC
BIOSUMAR	I/O summary detail archive log report	SSID LLOC
BIOSUMBP	I/O summary detail buffer pool report	SSID LLOC AUTH PLAN
BIOSUMBS	I/O summary detail BSDS report	SSID LLOC
BIOSUMED	I/O summary detail BSDS report	SSID LLOC AUTH PLAN
BIOSUMLG	I/O summary detail active log report	SSID LLOC
BIOSUMXI	I/O summary detail cross invalidation activity report	SSID LLOC AUTH PLAN
BLKSUMDT	Lock summary detail report	SSID LLOC AUTH PLAN
BLKSUMLO	Lock summary lockout report	SSID LLOC AUTH PLAN
BLKSUMSU	Lock summary suspensions report	SSID LLOC AUTH PLAN
BLKTRCDT	Lock trace event detail report	DB2 SSID LLOC AUTH CORRID CONNECTION CONTYP ENDUNAME ENDWSNAME ENDTNAME
BLKTRCLO	Lock trace lockout report	DB2 SSID LLOC AUTH CORRID CONNECTION CONTYP ENDUNAME ENDWSNAME ENDTNAME
BLKTRCSU	Lock trace suspensions report	DB2 SSID LLOC AUTH CORRID CONNECTION CONTYP ENDUNAME ENDWSNAME ENDTNAME
BRIDFAIL (PTF BQU2045 applied)	RID failures report	DB2 Local Location Remote Location
BRIDLIST	RID list failures report	DB2 Local Location Remote Location
BSQLIX	SQL create thread index report	DB2 SSID LLOC AUTH CORRID CONNECTION CONTYP ENDUNAME ENDWSNAME ENDTNAME
BSQLLT	SQL long trace report	DB2 SSID LLOC AUTH CORRID CONNECTION CONTYP ENDUNAME ENDWSNAME ENDTNAME
BSQSUMP	Summary SQL report by PGM/PKG	SSID LLOC AUTH PLAN PACKAGE
BSQSUMPW	Summary SQL report by PGM/PKG with workloads	SSID LLOC AUTH PLAN PACKAGE
BSQTRCCC	SQL compatibility exception trace by event report	DB2 SSID LLOC AUTH CORRID CONNECTION CONTYP ENDUNAME ENDWSNAME ENDTNAME PACKAGE
BSQTRCP	Thread SQL trace summary report by PGM/PKG	DB2 SSID LLOC AUTH CORRID CONNECTION CONTYP ENDUNAME ENDWSNAME ENDTNAME PACKAGE
BSQTRCPW	Thread SQL trace summary report by PGM/PKG with workloads	DB2 SSID LLOC AUTH CORRID CONNECTION CONTYP ENDUNAME ENDWSNAME ENDTNAME PACKAGE
BSQTRCS	Thread SQL trace summary report by PGM/PKG and statement number	DB2 SSID LLOC AUTH CORRID CONNECTION CONTYP ENDUNAME ENDWSNAME ENDTNAME PACKAGE
BSQTRCSW	Thread SQL trace summary report by PGM/PKG and statement number with workloads	DB2 SSID LLOC AUTH CORRID CONNECTION CONTYP ENDUNAME ENDWSNAME ENDTNAME PACKAGE
BSQTRCT	SQL summary trace report by occurrence	DB2 SSID LLOC AUTH CORRID CONNECTION CONTYP ENDUNAME ENDWSNAME ENDTNAME
BSQTRCTW	SQL summary trace report by occurrence with workloads	DB2 SSID LLOC AUTH CORRID CONNECTION CONTYP ENDUNAME ENDWSNAME ENDTNAME
BSTATDI	DB2 statistics IFCID tracing detail	DB2 Local Location
BSTATDR	DB2 statistics detail	DB2
BSTATLT	DB2 statistics trace long	DB2 Local Location
BSTATSTX	Virtual storage status	DB2
BSTATSUM	Virtual storage status summary	DB2 Local Location Remote Location
BTHACDTL	Accounting thread detail—long report (BTHACDTL)	Authorization ID Connection ID Correlation ID DB2 Local Location Operator ID Package Name Plan Name Remote Location
BTHAUDIT	Audit event history	Authorization ID Correlation ID DB2 Package Name Plan Name
BTHDADTL	Thread detail by AUTHID	Authorization ID DB2 End Transaction End User Name End Workstation Local Location Package Name Plan Name
BTHDASUM	Thread summary by interval	Authorization ID DB2 End Transaction End User Name End Workstation Local Location Package Name Plan Name
BTIMEOUT	DB2 timeout report	DB2 SSID AUTH CORRID CONNECTION PLAN ENDUNAME ENDWSNAME ENDTNAME
THSQLDYN	Dynamic SQL Miniplan by period	Authorization ID Collection ID Connection ID Correlation ID DB2 End Transaction End User Name End Workstation Local Location Operator ID Package Name Plan Name
THSQLDYS	Dynamic SQL Miniplan summary	Authorization ID Collection ID Connection ID Correlation ID DB2 End Transaction End User Name End Workstation Local Location Operator ID Package Name Plan Name

Example

In the following example that uses QUALIFIER, this statement sets a global qualifier specification (for all reports) that includes data that is generated from all TSO connections on behalf of the authorization ID TSR. This QUALIFIER statement applies to all subsequent REPORT statements in the same job stream unless they include a QUALIFIER parameter.

QUALIFIER(CONN(TSO*) AUTH(TSR))

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.

Note

If you use a lone asterisk (*) to include all values of an identifier, the effect is the same as making no specification for that identifier. All values of that identifier are included. If you use a lone asterisk to exclude all values of an identifier, no records are reported.

An asterisk, when used at the end of a character string matches all identifiers beginning with that character string.

Example

Specifying **HNW4PP for an authid finds no matches.

An asterisk, where components of a qualifier are separated by a period (.), can be used within each component.

Example

Specifying DBASE01.*.PSET for Lock Resource matches all values for DBASE01 with a lock type of PSET, regardless of page set.

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.

Example

Specifying PLAN!A for Plan Name matches all plans with PLAN in the first four character positions and A in the sixth character position (for example, PLAN1A, PLAN2A, PLAN3A).

QUALIFIER statement and parameter

Using Wildcards

MainView for DB2 6.1

On this page