Creating monitoring profile lines
A monitoring profile consists of one or more monitoring profile lines. Each monitoring profile line applies to one workload and consists of the following elements.
- Line type (Include or Exclude)
- Miscellaneous flags
- Workload definition
- Exception thresholds
- Exception limit
- SQLCODEs excluded from exceptions
- Alert thresholds
- SQLCODEs excluded from alerts
- SQLCODEs excluded from summary collection
- OPTKEYS overrides
A sample of the Update Profile Line Panel is shown below.
--------------------- Update Profile Line for USERA ---------------------
Option ===> ________________________________________________ Scroll ===> CSR
More: +
Workload Filter
INCLUDE/EXCLUDE I (I=Include, E=Exclude)
Disable Summary Reporting N (Y/N) Gather Host Variables Y (Y/N)
DB2 Subsystem *___ Plan Name *_______
Program Name *_______
AUTHID *_______ JOBNAME *_______
Connection ID *_______ CORRID *___________
CORRNAME *___________
Workstation User *_______________
Workstation Trans *_______________________________
Workstation Name *_________________
Workload Name ________________________________
Exceptions
Exception Limit 0_____________
(zero means do not process this profile line for exceptions)
Threshold Exceptions N (Y/N)
Threshold Exceptions N (Y/N)
Exception CPU 00 : 00 : 00 . 000000
Exception Elapsed 00 : 00 : 00 . 000000
Exception Getpages 0_____________
Exception SQL Calls 0_____________
Anomaly-based Exceptions
CPU Anomalies N (Y/N) Toleration Level 6.0__________
Elapsed Anomalies N (Y/N) Toleration Level 6.0__________
Getpage Anomalies N (Y/N) Toleration Level 6.0__________
Generate SQLCODE Exceptions Y (Y/N)
Include Exception SQLCODEs N (Y/N)
Exclude Exception SQLCODEs N (Y/N)
Collect Exception Positive SQLCODEs N (Y/N)
Alerts
Threshold Alerts N (Y/N)
Alert CPU 00 : 00 : 00 . 000000
Alert Elapsed 00 : 00 : 00 . 000000
Alert Elapsed 00 : 00 : 00 . 000000
Alert Getpages 0_____________
Alert SQL Calls 0_____________
Anomaly-based Alerts
CPU Anomalies N (Y/N) Toleration Level 6.0__________
Elapsed Anomalies N (Y/N) Toleration Level 6.0__________
Getpage Anomalies N (Y/N) Toleration Level 6.0__________
Generate SQLCODE Alerts N (Y/N)
Include Alert SQLCODEs N (Y/N)
Exclude Alert SQLCODEs N (Y/N)
Collect Alert Positive SQLCODEs N (Y/N)
Include Getpage Objects N (Y/N)
Discard Above (sigmas)
CPU Discard Level 12.0__________
Elapsed Discard Level 12.0__________
Getpage Discard Level 12.0__________
Summaries
Include Summary SQLCODEs N (Y/N)
Exclude Summary SQLCODEs N (Y/N)
Collect Summary Positive SQLCODEs N (Y/N)
Ignore positive SQLCODE 100 for Read Activity Y (Y/N)
Optional Keys
Override OPTKEYS N (Y/N)
OPTKEYS(TEXT) N (Y/N)
OPTKEYS(AUTHIDS) N (Y/N)
OPTKEYS(CORRID) N (Y/N)
OPTKEYS(CORRNAME) N (Y/N)
OPTKEYS(CORRNUM) N (Y/N)
OPTKEYS(WSUSER) N (Y/N)
OPTKEYS(WSTRAN) N (Y/N)
OPTKEYS(WSNAME) N (Y/N)
OPTKEYS(CALLS) N (Y/N)
OPTKEYS(PTEXT) N (Y/N)
OPTKEYS(SCHEMA) N (Y/N)
OPTKEYS(CONNTYPE) N (Y/N)
OPTKEYS(CONNNAME) N (Y/N)
OPTKEYS(SP) N (Y/N)
OPTKEYS(JOBNAME) N (Y/N)
OPTKEYS(PARALLEL) N (Y/N)
Misc Collection
Collect Object Data Y (Y/N)
Override SQL Collection N (Y/N)
Collect Static SQL Y (Y/N)
Collect Dynamic SQL Y (Y/N)
The steps that follow enable you to create an individual monitoring profile line.