Log monitors

The monitors listed in the following table measure logging activity.

Monitor	Title	View name	Description, Parameters, Warning
ARCDL	Read Accesses Delayed	DARCDL	Reports the number of read accesses delayed because of unavailable resources during the sampling period Parameters: none Warning DS1040W (nn) hh:mm:ss ARC READ ACCESS DELAYED(TOTAL) = v IN x intrvl (>thrshld)
ARCRA	Archive Log Read Allocations	DARCRA	Reports the number of read archive logs allocated during a sampling interval Read-archive logs are allocated when backout or recovery data requests cannot be satisfied from the log buffers or from the active log. Parameters: none Warning DS0450W (nn) hh:mm:ss ARCHIVE LOG READ ALLOCS(TOTAL) = v IN x intrvl (>thrshld)
ARCTC	Tape Volume Contention Read Delays	DARCTC	Reports the number of read accesses delayed because of tape mount contention during the sampling period Parameters: none Warning DS1030W (nn) hh:mm:ss ARC TAPE VOL CONTENTION(TOTAL) = v IN x intrvl (>thrshld)
ARCTM	Look-Ahead Tape Mounts	DARCTM	Reports the number of look-ahead tape mount requests that occurred during the sampling period Parameters: [FAIL\|SUCCESS] Warning DS1050W (nn) hh:mm:ss ARC LK-AHEAD TAPE MOUNT(TOTAL) = v IN x intrvl (>thrshld)
ARCWA	Archive Log Write Allocations	DARCWA	Reports the number of archive logs allocated as a result of an active log data set being archived during the sampling period Parameters: none Warning DS0440W (nn) hh:mm:ss ARCHIVE LOG WRITE ALLOCS(TOTAL) = v IN x intrvl (>thrshld)
ARCWR	Archive Log CIs Written	DARCWR	Reports the number of control intervals (CIs) that are archived during the sampling period Parameters: none Warning DS0460W (nn) hh:mm:ss ARCHIVE LOG CI WRITES(TOTAL) = v IN x intrvl (>thrshld)
BSDSA	BSDS Access Requests	DBSDSA	Reports the number of accesses to the Bootstrap Data Set (BSDS) during the sampling period Parameters: none Warning DS0510W (nn) hh:mm:ss BSDS ACCESSES(TOTAL) = v IN x intrvl (>thrshld)
CHKPT	Number of Checkpoints	DCHKPT	Reports the number of DB2 checkpoints taken during the sampling interval Parameters: none Warning DS0520W (nn) hh:mm:ss NUMBER OF CHECKPOINTS(TOTAL) = v IN x intrvl (>thrshld)
CKPFR	Checkpoint Frequency	DCKPFR	Reports the number of DB2 checkpoints taken during the sampling interval The purpose of this monitor is to report that fewer than the specified number of checkpoints have occurred in the specified time interval. Suggested values to start this monitor are as follows: An interval of 20 minutes A value of less than 1 For example: INTERVAL=20:00 WVAL=<1 In this example, the message will be issued if no checkpoints occur in a twenty-minute interval. Parameters: none Warning DS1580W (nn) hh:mm:ss CHECKPOINT FREQUENCY(TOTAL) = v IN x intrvl (<thrshld)
LOGRD	Log Reads for Backout/Recovery	DLOGRD	Reports the number of log reads for backout or recovery during the sampling period The number is the sum of log reads satisfied from active log buffers, log data sets, archive logs, or from other sources. Parameters: [BUFFER\|ACTIVE\|ARCHIVE] Warning DS0500W (nn) hh:mm:ss MAX LOB STORAGE(parm) = v IN x intrvl (>thrshld)
LOGUT	Active Log Percent Utilization	DLOGUT	Reports the percentage of log CIs in use during the sampling interval Parameters: none Warning DS0490W (nn) hh:mm:ss ACTIVE LOG % UTILIZATION(TOTAL) = v (>thrshld)
LOGWR	Log Write Requests	DLOGWR	Reports the number of log write requests during the sampling interval The reported number of log write requests can be selected as FORCE, NOWAIT, or the total of all requests. Parameters: [FORCE\|NOWAIT] Warning DS0480W (nn) hh:mm:ss LOG WRITE REQUESTS(parm) = v IN x intrvl (>thrshld)
LOGWT	Log Buffer Waits	DLOGWT	Reports the number of log request waits because log buffers were unavailable during the sampling period Parameters: none Warning DS0470W (nn) hh:mm:ss LOG BUFFER WAITS(TOTAL) = v IN x intrvl (>thrshld)

Log monitors

On this page