User activity monitors

The monitors listed in the following table measure user activity.

Monitor	Title	View name	Description, Parameters, Warning
BINDF	Failed Automatic Binds	DBINDF	Reports the number of attempted automatic binds that failed during the sampling period Parameters: none Error Warning DS0190W (nn) hh:mm:ss FAILED AUTO BINDS(TOTAL) = v IN x intrvl (>thrshld)
BINDS	Successful Automatic Binds	DBINDS	Reports the number of automatic binds that were completed successfully during the sampling period Parameters: none Error Warning DS0180W (nn) hh:mm:ss SUCCESSFUL AUTO BINDS(TOTAL) = v IN x intrvl (>thrshld)
BNPKF	Failed Automatic Binds for Packages	DBNPKF	Reports the number of failed automatic bind requests for packages during the sampling period The reported value is the difference between the total automatic bind requests for packages minus the successful requests (QTAUTOBA). Parameters: none Error Warning DS0710W (nn) hh:mm:ss AUTO BIND PKG FAILED(TOTAL) = v IN x intrvl (>thrshld)
BNPKS	Successful Automatic Binds for Packages	DBNPKS	Reports the number of successful automatic bind requests for packages during the sampling period (QTPKABND) Parameters: none Error Warning DS0700W (nn) hh:mm:ss AUTO BIND PKG SUCCESSFUL(TOTAL) = v IN x intrvl (>thrshld)
COMP2	Phase 2 Commits	DCOMP2	Reports the number of successful phase 2 commit requests during the sampling period A two-phase commit is used by both IMS and CICS transactions. Parameters: none Error Warning DS0140W (nn) hh:mm:ss PHASE 2 COMMITS(TOTAL) = v IN x intrvl (>thrshld)
COMRO	Read-Only Commits	DCOMRO	Reports the number of read-only commit requests during the sampling period A read-only commit is a one-phase commit used by IMS and CICS in query-only processing. Parameters: none Error Warning DS0640W (nn) hh:mm:ss READ-ONLY COMMITS(TOTAL) = v IN x intrvl (>thrshld)
COMSY	Sync Commits	DCOMSY	Reports the number of synchronized commit requests during the sampling period A synchronized commit is used by TSO applications, the Call Attach Facility, and batch applications. Parameters: none Error Warning DS0150W (nn) hh:mm:ss SYNC COMMITS(TOTAL) = v IN x intrvl (>thrshld)
CONUT	Connection Percent Utilization	DCONUT	Reports the percentage of active connections of the total allowable during the specified sampling period, by one of the following types: TSO BATCH DBAT All active connections The total allowable connections are defined by the following values in the DSNZPARM data set: IDFORE–TSO foreground (Db2I) IDBACK–TSO background (batch jobs, CAF, or utilities) MAXDBAT When CONUT is started without parameters, all active connections are monitored. The percentage is reported as the sum of active connections of the total. Parameters: [TSO\|BATCH\|DBAT] Error Warning DS0060W (nn) hh:mm:ss CONNECTION % UTILIZATION(parm) = v (>thrshld)
DROWA	Direct Row Access	DDROWA	Reports the number of attempts to use Direct Row Access to locate a record during the sampling period (QXROIMAT, QXROIIDX, QXROITS) with one of the following results: USED–Db2 used Direct Row Access to locate a record. FAILIX–Db2 attempted to use Direct Row Access but reverted to using an index to locate a record. FAILTS–Db2 attempted to use Direct Row Access but reverted to using a table space scan to locate a record. FAILURES–Direct Row Access attempts failed. If the DROWA monitor is started without parameters (blank), the reported number is the sum of all Direct Row Access attempts during the sampling period. Parameters: [USED\|FAILIX\|FAILTS\| FAILURES] Error Warning DS1590W (nn) hh:mm:ss DIRECT ROW ACCESS(parm) = v IN x intrvl (>thrshld)
EOMFL	End of Memory Failures	DEOMFL	Reports the number of end-of-memory (EOM) failures during the sampling period The count is incremented when an end-of-memory request is processed for a Db2-connected address space; for example, at TSO force. Parameters: none Error Warning DS0160W (nn) hh:mm:ss EOM FAILURES(TOTAL) = v IN x intrvl (>thrshld)
EOTFL	End of Task Failures	DEOTFL	Reports the number of end-of-task (EOT) failures during the sampling period The count is incremented when an end-of-task request is processed for a Db2-connected address space; for example, an abend of IMS or CICS tasks that have a Db2 thread. Parameters: none Error Warning DS0170W (nn) hh:mm:ss EOT FAILURES(TOTAL) = v IN x intrvl (>thrshld)
LOBMX	Maximum LOB Storage	DLOBMX	Reports the maximum storage used for LOB values, in megabytes, during the sampling period (QXSTLOBV) Parameters: none Error Warning DS1670W (nn) hh:mm:ss MAX LOB STORAGE(TOTAL) = v (>thrshld)
NESTM	Maximum Nested SQL Level	DNESTM	Reports the maximum level of nested SQL cascading due to triggers, user-defined functions, and stored procedures during the sampling period (QXCASCDP) Parameters: none Error Warning DS1610W (nn) hh:mm:ss MAX NESTED SQL LEVEL(TOTAL) = v IN x intrvl (>thrshld)
PLBND	Number of Plans Bound	DPLBND	Reports the number of successfully bound plans during the sampling period (QTPLNBD) Parameters: [BIND\| REBIND] Error Warning DS0680W (nn) hh:mm:ss PLANS BOUND(TOTAL) = v IN x intrvl (>thrshld)
PKBND	Number of Packages Bound	DPKBND	Reports the number of successfully bound packages during the sampling period (QTPKGBD) Parameters: [BIND\|REBIND] Error Warning DS0690W (nn) hh:mm:ss PACKAGES BOUND(TOTAL) = v IN x intrvl (>thrshld)
PRLG	I/O Parallel Groups with Fallback to Sequential	DPRLG	Reports the number of parallel groups that executed to the planned parallel degree (QXNORGRP), which executed to a degree less than planned because of a storage shortage or contention on the buffer pool (QXREDGRP), or the total number of parallel groups executed (QXTOTGRP) Parameters: [PLANNED\|REDUCED] Error Warning DS0810W (nn) hh:mm:ss I/O PRLL-GROUPS EXECUTED(TOTAL) = v IN x intrvl (>thrshld)
PRLF	I/O Parallel Groups Executed	DPRLF	Reports the number of planned parallel groups that fall back to sequential execution during the sampling period (QXDEGCUR, QXDEGESA, QXDEGBUF, QXDEGENC) for one of the following reasons: CURSOR–fall back to sequential because of ambiguous cursor (can be used for update or delete) NOSORT–fall back to sequential because of lack of ESA Sort support NOBFR–fall back to sequential because of storage shortage or buffer pool contention NOENCLAV–fall back to sequential because z/OS/ESA enclave services were unavailable If the PRLF monitor is started without parameters (blank), the reported number is the sum of all fallbacks to sequential processing for any reason. Parameters: [PLANNED\|REDUCED] Error Warning DS0820W (nn) hh:mm:ss I/O PRLL-FALLBACK SEQ(TOTAL) = v IN x intrvl (>thrshld)
PRLSF	Sysplex Parallel Query Failures	DPRLSF	Reports the number of sysplex query failures during the sampling period (QXCOORNO, QXISORR, QXXCSKIP) for one of the following reasons: COORNO–failed because coordinator changed to NO ISORR–failed because of ISOLATION RR/RS CSKIP–skipped a Db2 because of buffer shortage Parameters: [COORNO\|ISORR\|CSKIP] Error Warning DS0830W (nn) hh:mm:ss SYSPLEX PRLL QUERY FAILS(TOTAL) = v IN x intrvl (>thrshld)
SQLAC	SQL Activity	DSQLAC	Reports the number of SQL statements that executed during the sampling period (QXSETCRL, QXCALL) DSQLAC reports the number of executed statements by the following SQL types: Data Definition Language–authorization statements Lock statements–select/fetch statements Dynamic SQL–update, insert, or delete statements Control statements–open statements Close statements–stored procedure calls If the SQLAC monitor is started without parameters (blank), the reported number is the sum of all SQL statement types that executed during the sampling period. Parameters: [DDL\|AUTH\|SEL\|LOCK\|UID\|DYN\| CTL\|OPEN\|CLOSE\|CALL] Error Warning DS0200W (nn) hh:mm:ss SQL ACTIVITY(parm) = v IN x intrvl (>thrshld)
SPROC	Stored Procedures	DSPROC	Reports the number of stored procedure calls for all users during the sampling period (QXCALL, QXCALLAB, QXCALLTO, QXCALLRJ) The reported value can be for one of the following types: CALLS–number of SQL CALL statements that were executed ABENDS–number of times a stored procedure terminated abnormally TIMEOUTS–number of times an SQL CALL statement timed out while waiting to be scheduled REJECTS–number of times an SQL CALL statement was rejected because the procedure was in the 'STOP ACTION(REJECT)' state FAILURES–total number of SQL CALL statements that failed (QXCALLAB QXCALLTO QXCALLRJ) If the SPROC monitor is started without parameters (blank), the reported number is the sum of all SQL CALL statements during the sampling period. Parameters: [CALLS\|ABENDS\|TIMEOUTS\| REJECTS\|FAILURES] Error Warning DS1400W (nn) hh:mm:ss STORED PROCEDURES(TOTAL) = v IN x intrvl (>thrshld)
THDAB	Rollback Requests	DTHDAB	Reports the number of rollback requests during the sampling period Parameters: none Error Warning DS0130W (nn) hh:mm:ss ROLLBACK REQUESTS(TOTAL) = v IN x intrvl (>thrshld)
THDAC	Active Thread Status	DTHDAC	Reports the number of active threads by one of the following types: TSO Batch IMS CICS Utility Call Attach Facility Database Access (DBAT) Distributed Allied Agent (DIST) Both DBAT and DIST Blank If the THDAC monitor is started without parameters (blank), the reported number is the sum of active threads of all sampled types. Parameters: [TSO\|BATCH\|CAF\|UTIL\|SPAS\| IMS\|CICS\|DBAT\|DIST\|DDF\| RRSAF] Error Warning DS0080W (nn) hh:mm:ss ACTIVE THREADS(parm) = v (>thrshld)
THDCR	Create Thread Requests	DTHDCR	Reports the number of successful CREATE THREAD requests during the sampling period Parameters: none Error Warning DS0110W (nn) hh:mm:ss CREATE THREAD REQUESTS(TOTAL) = v IN x intrvl (>thrshld)
THDID	In Doubt Thread Status	DTHDID	Reports the number of in-doubt threads during the sampling period Only IMS or CICS threads can be in doubt. Parameters: none Error Warning DS0100W (nn) hh:mm:ss IN DOUBT THREADS(TOTAL) = v (>thrshld)
nnTHDQD	Queued Thread Status	DTHDQD	Reports the number of queued threads by one of the following types: TSO Batch Utility Call Attach Facility IMS CICS If the THDQD monitor is started without parameters (blank), the reported number is the sum of queued threads of all sampled types. Parameters: [TSO\|BATCH\|CAF\|UTIL\|SPAS\| IMS\|CICS\|DBAT\|DIST\|DDF\| RRSAF] Error Warning DS0090W (nn) hh:mm:ss QUEUED THREADS(parm) = v (>thrshld)
THDUT	Thread Percent Utilization	DTHDUT	Reports the percentage of active threads from the total allowable during the sampling period Allowable threads are defined in member CTHREAD of the DSNZPARM data set. Parameters: none Error Warning DS0070W (nn) hh:mm:ss THREAD % UTILIZATION(TOTAL) = v (>thrshld)
THDWT	Create Thread Waited	DTHDWT	Reports the number of CREATE THREAD requests that waited for an available thread during the sampling period Parameters: none Error Warning DS0120W (nn) hh:mm:ss CREATE THREAD WAITED(TOTAL) = v IN x intrvl (>thrshld)
TRIGR	Trigger Usage	DTRIGR	Reports the number of triggered actions during the sampling period (QXSTTRG, QXROWTRG, QXTRGERR) The reported value can be for one of the following types: STMT–number of times a statement trigger was activated ROW–number of times a row trigger was activated ERROR–number of times an SQL error occurred during execution of a triggered action If the TRIGR monitor is started without parameters (blank), the reported number is the sum of all activated triggers during the sampling period. Parameters: [STMT\|ROW\|ERROR] Error Warning DS1600W (nn) hh:mm:ss TRIGGER USAGE(parm) = v IN x intrvl (>thrshld)
UDF	UDF Usage	DUDF	Reports the number of user-defined functions during the sampling period (QXCAUD, QXCAUDAB, QXCAUDTO, QXCAUDRJ) The reported value can be for one of the following types: EXECS–number of user-defined functions executed ABENDS–number of times a user-defined function terminated abnormally REJECTS–number of times a user-defined function was rejected FAILURES–number of user-defined functions that failed TIMEOUTS–number of times a user-defined function timed out while waiting to be scheduled If the UDF monitor is started without parameters (blank), the reported number is the sum of all user-defined functions during the sampling period. Parameters: [EXECS\|ABENDS\|TIMEOUTS\| REJECTS\|FAILURES] Error Warning DS1620W (nn) hh:mm:ss UDF USAGE(parm) = v IN x intrvl (>thrshld)
XMLMX	Maximum XML Storage	DXMLMX	Reports the maximum storage used for XML values, in megabytes, during the sampling period (QXSTXMLV) Parameters: none Error Warning DS1690W (nn) hh:mm:ss MAX XML STORAGE(TOTAL) = v (>thrshld)

User activity monitors

BMC AMI Ops Monitor for Db2 12.2

On this page