80 lines
4.9 KiB
HTML
80 lines
4.9 KiB
HTML
|
<?xml version="1.0" encoding="UTF-8"?>
|
||
|
|
<!DOCTYPE html
|
||
|
|
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
||
|
|
<html lang="en-us" xml:lang="en-us">
|
||
|
|
<head>
|
||
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
||
|
|
<meta name="security" content="public" />
|
||
|
|
<meta name="Robots" content="index,follow" />
|
||
|
|
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
|
||
|
|
<meta name="DC.Type" content="reference" />
|
||
|
|
<meta name="DC.Title" content="Starting a detailed monitor" />
|
||
|
|
<meta name="abstract" content="You can start a detailed monitor from the iSeries Navigator interface." />
|
||
|
|
<meta name="description" content="You can start a detailed monitor from the iSeries Navigator interface." />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajqnavmon.htm" />
|
||
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 1998, 2006" />
|
||
|
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1998, 2006" />
|
||
|
|
<meta name="DC.Format" content="XHTML" />
|
||
|
|
<meta name="DC.Identifier" content="rzajqstartdetailmon" />
|
||
|
|
<meta name="DC.Language" content="en-us" />
|
||
|
|
<!-- All rights reserved. Licensed Materials Property of IBM -->
|
||
|
|
<!-- US Government Users Restricted Rights -->
|
||
|
|
<!-- Use, duplication or disclosure restricted by -->
|
||
|
|
<!-- GSA ADP Schedule Contract with IBM Corp. -->
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ic.css" />
|
||
|
|
<title>Starting a detailed monitor</title>
|
||
|
|
</head>
|
||
|
|
<body id="rzajqstartdetailmon"><a name="rzajqstartdetailmon"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Starting a detailed monitor</h1>
|
||
|
|
<div><p>You can start a detailed monitor from the iSeries™ Navigator interface.</p>
|
||
|
|
<div class="section"><p>You can start this monitor by right-clicking SQL Performance Monitors
|
||
|
|
under the Database portion of the iSeries Navigator tree and selecting <span class="menucascade"><span class="uicontrol">New</span> > <span class="uicontrol">SQL Performance Monitor</span></span>.
|
||
|
|
On the monitor wizard, select <strong>Detailed</strong>.</p>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>When you create a detailed monitor, you can filter the information
|
||
|
|
that you want to capture.</p>
|
||
|
|
<dl><dt class="dlterm">Minimum estimated query runtime</dt>
|
||
|
|
<dd>Select this to include queries that exceed a specified amount of time.
|
||
|
|
Select a number and then a unit of time.</dd>
|
||
|
|
<dt class="dlterm">Job name</dt>
|
||
|
|
<dd>Select this to filter by a specific job name. Specify a job name in the
|
||
|
|
field. You can specify the entire ID or use a wildcard. For example, 'QZDAS*'
|
||
|
|
will find all jobs where the name starts with 'QZDAS.'</dd>
|
||
|
|
<dt class="dlterm">Job user</dt>
|
||
|
|
<dd>Select this to filter by a job user. Specify a user ID in the field. You
|
||
|
|
can specify the entire ID or use a wildcard. For example, 'QUSER*' will find
|
||
|
|
all user IDs where the name starts with 'QUSER.'</dd>
|
||
|
|
<dt class="dlterm">Current user</dt>
|
||
|
|
<dd>Select this to filter by the current user of the job. Specify a user ID
|
||
|
|
in the field. You can specify the entire ID or use a wildcard. For example,
|
||
|
|
'QSYS*' will find all users where the name starts with 'QSYS.'</dd>
|
||
|
|
<dt class="dlterm">Internet address</dt>
|
||
|
|
<dd>Select this to filter by Internet access. The format must be xxx.xxx.xxx.xxx.
|
||
|
|
For example: 5.5.199.199.</dd>
|
||
|
|
<dt class="dlterm">Only queries that access these tables</dt>
|
||
|
|
<dd>Select this to filter by only queries that use certain tables. Click <span class="uicontrol">Browse</span> to
|
||
|
|
select tables to include. To remove a table from the list, select the table
|
||
|
|
and click <span class="uicontrol">Remove</span>. A maximum of ten table names can
|
||
|
|
be specified.</dd>
|
||
|
|
<dt class="dlterm">Activity to monitor</dt>
|
||
|
|
<dd>Select to collect monitor output for user-generated queries or for both
|
||
|
|
user-generated and system-generated queries.</dd>
|
||
|
|
</dl>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>You can choose which jobs you want to monitor or choose to monitor
|
||
|
|
all jobs. You can have multiple instances of monitors running on you system
|
||
|
|
at one time. You can create up to 10 detailed monitors to monitor all jobs.
|
||
|
|
When collecting information for all jobs, the monitor will collect on previously
|
||
|
|
started jobs or new jobs that are started after the monitor is created. You
|
||
|
|
can edit this list by selecting and removing jobs from the <strong>Selected jobs</strong> list.</p>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rzajqnavmon.htm" title="You can work with detailed monitors from the iSeries Navigator interface. The detailed SQL performance monitor is the iSeries Navigator version of the STRDBMON database monitor, found on the native interface.">Using iSeries Navigator with detailed monitors</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|