Detecting exception conditions

To facilitate the monitoring of particular database characteristics during analysis, the analysis function provides the THRESHOLD subcommand and its associated keywords to indicate database threshold settings. Using these keywords, you can specify that warning messages be sent to the processing log when certain database conditions are detected. Threshold tests are performed only when you specify the corresponding threshold keywords. Any threshold exception conditions that are detected are shown also on the Area Summary Report.

The threshold keywords are categorized into the general groups that are listed in below table.

Threshold Type	Threshold keywords
Free space	DOVF_FREESPACE_PERCENT
	FREESPACE_DOVF_IOVF
	FREESPACE_RAA_DOVF
	FREESPACE_RAA_IOVF
	IOVF_FREESPACE_PERCENT
	IOVF_USED_PERCENT
	RAA_FREESPACE_PERCENT
	RAP_OVERFLOW_PERCENT
I/O	RECORD_IO_AVERAGE
	RECORD_IO_MAXIMUM
	ROOT_IO_AVERAGE
	ROOT_IO_MAXIMUM
RAP usage	SYNONYM_CHAIN_LENGTH
	SYNONYM_CHAIN_MAXIMUM
	SYNONYM_CHAIN_PERCENT
Overflow characteristic	RECORD_IOVF_PERCENT
	UOW_DOVF_PERCENT
	UOW_IOVF_AVERAGE
	UOW_IOVF_MAXIMUM
	UOW_IOVF_PERCENT

Note

Record I/O thresholds and the RECORD_IOVF_PERCENT overflow threshold can be tested only if POINTER_VALIDATION=FULL has been requested. Root I/O thresholds and RAP usage thresholds can be tested if POINTER_VALIDATION=FULL or RAP_VALIDATION=XREF has been specified.

You can specify thresholds by placing the THRESHOLD subcommand within the GLOBAL command. These implicit threshold specifications are used by all analysis functions within the job step. To override the GLOBAL command, you can explicitly specify a THRESHOLD subcommand within the ANALYZE command. In the example shown in below figure, thresholds that are specified on the GLOBAL command are tested for all areas except area2 of database2. Specifying THRESHOLD without any keywords under the last ANALYZE command overrides the GLOBAL command, so no threshold checking is performed for area2.

//PFP   EXEC PGM=PFPMAIN,REGION=0M
//STEPLIB  DD DISP=SHR,DSN=BMC.PFP.LOAD
//         DD DISP=SHR,DSN=IMS.RESLIB
//         DD DISP=SHR,DSN=IMS.RESLIB
//IMSACB   DD DISP=SHR,DSN=IMSVS.ACBLIB
  GLOBAL
    REPORT
      RECORD_PROFILE_ANALYSIS=NO
  THRESHOLD
    FREESPACE_RAA_DOVF=(25,25),
    FREESPACE_RAA_IOVF=(50,50)
  ANALYZE DBD=
database1
  ANALYZE DBD=
database2,IAREA=(
area1,
area3,
area4)
  ANALYZE DBD=
database2,IAREA=
area2
   THRESHOLD
/*

Related topic

Analyzing a DEDB

Detecting exception conditions

Comments