Adding a monitoring profile line in ISPF
Add a monitoring profile line to a new or existing monitoring profile to define an SQL workload that you want to monitor.
Before you begin
Procedure
To add a monitor profile line:
-
On the Create Monitoring Profile
panel or the Update Monitoring Profile
panel, issue the I line command to insert a
new profile line, and press Enter.
The Insert Profile Line panel displays the options for the profile line.
Figure 1. Insert Profile Line panel --------------------- Insert 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) 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 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) -
Specify the following information on this panel:
- In the INCLUDE/EXCLUDE field, Specify whether this profile
line is to include (I) or exclude (E)
matching SQL activity from Db2 Query Monitor
processing.
The INCLUDE/EXCLUDE value does not affect summaries unless the Disable Summary Reporting parameter is set to Y. Therefore, if you do not include a Db2 subsystem for monitoring, you might still see activity for that subsystem when viewing activity summaries [option 1 from the IBM DB2 Query Monitor for z/OS panel (the main menu)].
- Identify the SQL activity to which the profile line applies by specifying values in
the following fields:
- DB2 Subsystem
- Plan Name
- Program Name
- AUTHID
- JOBNAME
- Connection ID
- CORRID
- Workstation User
- Workstation Trans
- Workstation Name
- Workload Name
Note: You can use wildcard specifications in these fields to identify the workload. - Identify what you want Db2 Query Monitor to do
with SQL activity that matches the specified workload criteria by specifying values in
the following fields:
- Disable Summary Reporting
- Gather Host Variables
- Exception CPU
- Exception Elapsed
- Exception Getpages
- Exception SQL Calls
- Exception Limit
- Generate SQLCODE Exceptions
- Include Exception SQLCODEs
- Exclude Exception SQLCODES
- Alert CPU
- Alert Elapsed
- Alert Getpages
- Alert SQLCALLS
- Generate SQLCODE Alerts
- Include Alert SQLCODEs
- Exclude Alert SQLCODEs
- Indicate whether you want to override OPTKEYS in the Override OPTKEYS field. If you specify Y, specify which OPTKEYS you want to override in the OPTKEYS(n) fields.
- Specify what you want Db2 Query Monitor to do
with positive SQL codes by specifying values in the following fields:
- Collect Exception Positive SQLCODEs
- Collect Alert Positive SQLCODEs
- Ignore SQLCODE 100 for Read Activity
- Indicate whether to exclude SQLCODEs from processing by using the following fields:
- Exclude Alert SQLCODES
- Excludes the specified SQLCODEs from alert processing
- Exclude Exception SQLCODES
- Excludes the specified SQLCODEs from exception processing
- Exclude Summary SQLCODES
- Excludes the specified SQLCODEs from summary processing
Otherwise, if you do not explicitly specify SQLCODES to exclude from Db2 Query Monitor processing, every negative SQLCODE is treated as an exception.
- Indicate whether to explicitly include some SQLCODEs by using the following fields:
- Include Alert SQLCODES
- Includes only the specified SQLCODEs in alert processing
- Include Exception SQLCODES
- Includes only the specified SQLCODEs in exception processing
- Include Summary SQLCODES
- Includes only the specified SQLCODEs in summary processing
- Indicates whether to generate an alert on the collection side when the number of GETPAGES exceeds the threshold set for the object by specifying a Y or N in the Include Getpages Objects field.
- In the INCLUDE/EXCLUDE field, Specify whether this profile
line is to include (I) or exclude (E)
matching SQL activity from Db2 Query Monitor
processing.
-
After you enter all of your options on the Insert Profile Line
panel, press Enter.
If you specified Y in any of the following fields, the indicated panel is displayed:
Table 1. Field for which you specified Y Panel that is displayed Include Exception SQLCODES Exception SQLCODE Inclusion List panel Include Alert SQLCODES Alert SQLCODE Inclusion List panel Include Summary SQLCODES Summary SQLCODE Inclusion List panel Include Getpages Objects Alert GETPAGES Inclusion List panel Exclude Exception SQLCODES Exception SQLCODE Exclusion List panel Exclude Alert SQLCODES Alert SQLCODE Exclusion List panel Exclude Summary SQLCODES Summary SQLCODE Exclusion List panel Otherwise, the Create Monitoring Profile panel or Update Monitoring Profile panel is displayed.
-
If an SQLCODE Inclusion List
panel or SQLCODE Exclusion List
panel is displayed, type the SQLCODEs
that you want to include or exclude from Db2 Query Monitor processing in the blank fields.
Figure 2. Exception SQLCODE Exclusion List panel --- Exception SQLCODE Exclusion List --- YYYY/MM/DD HH:MM:SS Option ===> Scroll ===> PAGE Profile Name: PROF1 C:I-Insert,R-Repeat,D-Delete,C-Copy,M-Move,B-Before,A-After ------------------------------------------------------------------------ ______ ______ ______ ______ ______ ______ ______ ______ ______ ***************************** Bottom of Data **********************************Tip: When typing a negative SQLCODE, you must use "-" prior to the SQLCODE to indicate that it is negative. When typing a positive SQLCODE, you must use "+" prior to the SQLCODE to indicate that it is positive.You can also use the following line commands to add, delete, repeat, and move entire rows. For help with any of these line commands, see the online help (PF1).
When you are finished specifying SQLCODEs, exit (PF3) the panel to save your specifications. If another SQLCODE Inclusion List panelor SQLCODE Exclusion List panel is displayed, repeat this step.
-
If the Alert GETPAGES Inclusion
List panel is displayed,
enter or update the Db2 objects (tables or
into indexes) to include in QM alert processing.
Figure 3. Alert GETPAGES Inclusion List panelAlert GETPAGE Inclusion List panel Row 1 of 1 --- Alert GETPAGES Inclusion List --- YYYY/MM/DD HH:MM:SS Option ===> Scroll ===> CSR Profile Name: USERA C:I-Insert, D-Delete, R-Repeat, U-Update ------------------------------------------------------------------------ CMD THRESHOLD OWNER NAME OBJECT NAME --- -------------- ---------- ----------- __ ______________ ___________________ ___________________________________Use the I (insert) and U (update) line commands to add and update objects. If you want to add an object that is very similar to an existing object, use the R (repeat) line command to duplicate that line and then edit it.
All three of these line commands display the Object Entry panel, where you can specify or update the threshold value and object name:
Figure 4. Object Entry panel -------------------------- Action: INSERT ------------------------- ----- Enter INCLUDED Threshold, Object Owner, and Object Name ---- Option ===> ____________________________ Threshold _______________ DB2 Object Owner ________________________________________________________________ ________________________________________________________________ DB2 Object Name ________________________________________________________________ ________________________________________________________________For detailed information about the fields on this panel fields, see the online help (PF1). Press Enter to save your changes on the Object Entry panel.
When you are done specifying objects on the Alert GETPAGES Inclusion List panel, exit (PF3) the panel to save your changes.