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



Was this page helpful? Yes No Submitting... Thank you

Comments