Exception filter keyword descriptions

ABORT

Y selects threads that terminated abnormally (the termination reason in QWACRINV is greater than 16).

CPU

CPU transaction time, which can be in hours, minutes, and seconds as hh:mm:ss or in seconds as ss (maximum of three decimals).

CPUDB2

CPU time of transaction while within DB2, which can be in hours, minutes, and seconds as hh:mm:ss or in seconds as ss (maximum of three decimals).

ELAP

Elapsed time of thread, which can be in hours, minutes, and seconds as hh:mm:ss or in seconds as ss (maximum of three decimals).

ELAPDB2

Elapsed time of thread while within DB2 which can be in hours, minutes, and seconds as hh:mm:ss or in seconds as ss (maximum of three decimals).

The following keywords must be numeric. They can be specified in kilobytes; for example, 100K.

CLAIMDR

This value is the number of claim / drain failures (QTXACLUN + QTXADRUN).

GETPAGE

This value is the number of GETPAGE requests. (This value must be specified in kilobytes if it is greater than 999999.)

GETRIO

This value is the ratio of the number of GETPAGE requests issued per READ I/O.

A < prefix should be used to define this value. The IBM DB2 Administration Guide, Volume III, suggests that a ratio below 1.5 can initiate poor read efficiency.

HPFAILS

This value is the number of hiperpool read or write failures (QBACHRF + QBACHWF).

INCRBIND

This value is the number of incremental BINDs issued.

LOCKESCL

This value is the number of lock escalations.

LOCKSUSP

This value is the number of lock suspensions.

LOCKTBL

This value is the number of LOCK TABLE requests.

MAXLOCK

This value is the maximum number of locks held.

PFREADS

This value is the number of prefetch read I/Os (QBACSIO).

PFREQS

This value is the number of prefetch requests (QBACSEQ).

PGUPD

This value is the number of page update requests.

PRLLFALB

This value is the number of parallel groups that fall back to sequential processing (QXDEGCUR + QXDEGESA + QXDEGBUF + QXDEGENC).

PRLLGRP

This value is the number of parallel groups executed (QXTOTGRP).

PRLLRED

This value is the number of parallel groups executed at a reduced degree (QXREDGRP).

PWAITIO

This value is the percentage of elapsed time for I/O waits (QWACAWTI/QWACASC).

PWAITLK

This value is the percentage of elapsed time for locks (QWACAWTL/QWACASC).

PWAITOT

This value is the percentage of elapsed time for other waits [(QWACAWTE+QWACALOG)/QWACASC].

PWAITPF

This value is the percentage of elapsed time for waiting for prefetch to be completed (QWACAWTR/QWACASC).

READIO

This value is the number of READ I/Os issued.

RIDFAIL

This value is the number of RID pool failures (QXNSMIAP and/or QXMRMIAP).

RLF

Y selects threads that were governed by RLF.

SQLCTL

This value is the number of SQL control statements, such as GRANT or REVOKE.

SQLDDL

This value is the number of SQL Data Definition Language statements.

SQLDYN

This value is the number of SQL PREPARE statements.

SQLFETCH

This value is the number of SQL FETCH statements.

SQLSEL

This value is the number of SQL SELECT statements.

SQLTOT

This value is the total number of SQL statements.

SQLUID

This value is the number of SQL UPDATE, INSERT, and DELETE statements.

TIMEOUT

This value is the number of timeouts (QTXATIM) and deadlocks (QTXADEA).

UIDCOM

This value is the ratio of the number of SQL UPDATE, INSERT, and DELETE statements issued per COMMIT.