Starting a monitor

To start a monitor

1. On the SM view, type S (Select) in the CMD field next to the service that you want to start and press Enter.Depending on the type of monitor that you select, a monitor-specific dialog is displayed. The following figure shows an example of the Start Workload Monitor dialog.

   Success

   Tip

   To learn about a monitor service, type H in the CMD field next to the service and press Enter. A description of the service, its parameters, and the syntax of its warning message are displayed.

   To learn about a field on the Start Monitors view, position the cursor on the field and press F1 for online Help.

   
   

                            Start Workload Monitor
   COMMAND ===>                                              SCROLL ===> CSR
                                                                     MORE: +
                          #SQLM - DATA MANIPULATIVE SQL                         
   Monitor Attributes:                                                        
   PARM     DB2XVALS     (Identifier)       START 00:09:00 (hh:mm:ss)         
   INTERVAL 00:01:00     (hh:mm:ss)         STOP           (hh:mm:ss/mins)    
   WVAL                  (Warning value)    WIF            (Intvls to 1st msg)
   WMSG                  (Log warnings to)  WIN            (Message Intervals)
   WLIM     10           (Warnings limit)   RST   HOT      (HOT,PUR,QIS)      
                                            QIS   YES      (YES/NO)           
   TITLE   DATA MANIPULATIVE SQL
   PLOTMAX                              (Maximum PLOT X-Axis value)           
   RANGES                               (1-4 Range Distr. Upper Limits)       
   LOG     NO                           (NO,ATSTOP,ATPD,ATINTVL,ATWARN)       
                                                                            
   Specify Workload Inclusion Criteria:                                               
     ICHECK    NO                      (Check Elapsed versus Interval time)    
     CONNTYPE                          (TSO, IMS, CICS, BATCH, etc.)     
     DB2PLAN   DSNREXX                                                 
     DB2AUTH   MVSKLK++                                                      
     DB2CONN                                                                 
     DB2CORR                                                                 
     DB2LOC                                                               
     DB2PKG                                                               
     DB2RTN                                                              
    The following parameters are enabled for only MVDB2 versions V12.1 and later
    Specify Workload Exclusion Criteria:                                        
     XCONNTYP  TSO                      Specify CONNTYPE or XCONNTYP, not both     
     XDB2PLAN  MVSKPLAN
     XDB2AUTH  MVSKAUTH
     XDB2CONN  MVSKCONN
     XDB2CORR  MVSKCORR
     XDB2LOC   MVSKLOC
     XDB2PKG   MVSKPKG
     XDB2RTN   MVSKRTN
   
    ENTER to accept the selection criteria
    HELP to view related help

2. Specify the following monitor attributes:

   Field	Description	Default
   PARM	requestName | parameter Unique name for the request or a parameter for the monitor For more information about the monitor that you want to start, see Alphabetical-reference-of-monitors	Blanks
   START	hh:mm:ss When to start the monitor service	Next full minute
   INTERVAL	hh:mm:ss Time interval between successive service invocations	00:01:00
   STOP	hh:mm:ss | mins When to stop the monitor service	24 hours
   WVAL	nn Warning threshold for the monitor request	0, no warnings
   WIF	nn Number of intervals before the first warning message	1
   WMSG	xxx Where the warning messages are to be sent	LOG
   WIN	n Number of intervals between warning messages	1
   WLIM	nn Maximum number of warning messages that the monitor can generate Possible values are 1 through 999 or -1. Warning Specifying -1 enables the monitor to produce an unlimited number of warning messages for a monitor at regular intervals. The default interval is 60 seconds.	10
   RST	HOT | PUR | QIS Restart option to be used when a service is quiesced because of an inactive target region	HOT
   QIS	YES | NO Action to be taken when a target is not active	YES
   TITLE	serviceName Display title for the monitor service (see Monitor-request-title) Warning Notes Special characters are not valid. Only blanks are valid as separators.	Name of the service
   PLOTMAX	Maximum value to be shown on the X-axis boundary for a PLOT of this monitor request	Not applicable
   RANGES	From one to four upper-range limit values for the PLOT range distribution	No range
   LOG	Logging option specification for the monitor service	No logging

3. Specify workload inclusion and exclusion criteria:

   Inclusion keyword	Exclusion keyword	Description	Option (if used)	Description
   ICHECK	N/A	YES | NO Qualifies workload monitor data collection
   CONNTYPE	XCONNTYP	TSO | IMS | CICS | BATCH | CAF | IMSMPP | IMSBMP | IMSTBMP | IMSCTL | DLI | DDF | DRDA | RRSAF | UTIL | blank Qualifies a summary or detail workload trace by connection type. Blank collects data for all connection types. Warning Note You can specify CONNTYPE or XCONNTYP. If you specify both CONNTYPE and XCONNTYP, XCONNTYP is ignored.
   DB2PLAN	XDB2PLAN	planName Qualifies a workload trace by a one- to eight-character Db2 plan name.	Summary Trace	The maximum number of operands is the total field length (60 characters). You can use the + character as a name qualifier.1
   			Detail Trace	You can specify up to eight plans to be traced. If more than one DB2AUTH or DB2LOC operand is specified, only one plan name can be specified. Warning Note You cannot use the + and * characters as generic operand characters for detail trace unless a nongeneric DB2LOC or DB2AUTH is specified, or a single + character is specified for DB2AUTH.
   DB2AUTH	XDB2AUTH	authorizationID Qualifies a workload trace by Db2 authorization ID.	Summary Trace	The maximum number of operands is the total field length (60 characters). You can use the + character as a name qualifier.1
   			Detail Trace	The maximum number of operands is eight. If more than one DB2PLAN or DB2LOC operand is specified, only one authorization ID can be specified. Warning Note You cannot use the + and * characters as generic operand characters for detail trace unless a nongeneric DB2PLAN or DB2LOC is specified. Generic operands reduce data collection.
   DB2CONN	XDB2CONN	connectionName Qualifies a summary or detail workload trace request by a one- to eight-character connection name. Warning Generic operands reduce data collection. The maximum number of operands is the total field length (60 characters). You can use the + character as a name qualifier.1
   DB2CORR	XDB2CORR	correlationID Qualifies a summary or detail workload trace request by a 1- to 60-character correlation ID. Warning Note This parameter reduces data collection. The maximum number of operands is the total field length (60 characters). You can use the + character as a name qualifier.1 Warning Note To qualify the trace by IMS PSBNAME or CICS TRANCODE, which begin in column 5 of the correlation ID, enter the operand as ++++nnnnnnnn, where nnnnnnnn is the PSB or tran code. An additional parameter such as plan, authid, or location is recommended to qualify the data collection and the data retention.
   DB2LOC	XDB2LOC	locationName Qualifies a workload trace by a 1- to 16-character remote location name. Only distributed DBAT threads with this requester location are selected. Optionally, you can specify the full local location name or a single + to trace all distributed threads. Specify an IP address in quotation marks.	Summary Trace	The maximum number of operands is the total field length (60 characters). You can use the + character as a name qualifier.1
   			Detail Trace	The maximum number of operands is eight. If more than one DB2PLAN or DB2AUTH operand is specified, only one location can be specified. Warning Note You cannot use the + and * characters as generic operand characters for detail trace unless a nongeneric DB2PLAN or DB2AUTH is specified, or a single + character is specified for DB2AUTH. Generic operands will reduce data collection by limiting data to remote location threads by including LOCATION(*) on the Start Trace request.
   DB2PKG	XDB2PKG	packageName Qualifies a summary or detail workload trace request by a 1- to 128-character Db2 package name (only when accounting class 7 or 8 is active). The maximum number of operands is the total field length (128 characters). You can use the + character as a name qualifier.1
   DB2RTN	XDB2RTN	routineName Specify the 1- to 64-character Db2 activity name of a stored procedure, trigger, or user-defined function (available only when accounting class 7/8/10 is active). A record is selected if the specified qualifier matches any routine name found in the accounting package sections. With RRSAF/ DDF rollup data, only rollup package data is available and the name might not be available for matching. The maximum number of operands is the total field length (128 characters). You can use the + character as a name qualifier.1

   ¹ For more information about using wildcard characters in requests, see Wildcard-characters-in-requests in the Using.

   For additional information about a field, press F1 for online Help.

4. Press Enter.The service monitor request is started.