71 lines
4.9 KiB
HTML
71 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="Using iSeries Navigator with detailed monitors" />
|
||
|
|
<meta name="abstract" content="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." />
|
||
|
|
<meta name="description" content="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." />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="queryopt.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajqstartdetailmon.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajqmonanalyze.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajqmoncompare.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajqmonstatements.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajqimportmon1.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="rzajqnavmon" />
|
||
|
|
<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>Using iSeries Navigator
|
||
|
|
with detailed monitors</title>
|
||
|
|
</head>
|
||
|
|
<body id="rzajqnavmon"><a name="rzajqnavmon"><!-- --></a>
|
||
|
|
<img src="./delta.gif" alt="Start of change" /><!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Using iSeries Navigator
|
||
|
|
with detailed monitors</h1>
|
||
|
|
<div><p>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.</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">Monitor</span></span>. This
|
||
|
|
monitor save detailed data in real time to a hard disk and does not need to
|
||
|
|
be paused or ended in order to analyze the results. You can also choose to
|
||
|
|
run a Visual Explain based on the data gather by the monitor. Since this monitor
|
||
|
|
does save data in real time, it may have a performance impact on your system.</p>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="rzajqstartdetailmon.htm">Starting a detailed monitor</a></strong><br />
|
||
|
|
You can start a detailed monitor from the iSeries Navigator interface.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzajqmonanalyze.htm">Analyze detailed monitor data</a></strong><br />
|
||
|
|
SQL Performance monitors provides several predefined reports that you can use to analyze your monitor data.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzajqmoncompare.htm">Comparing monitor data</a></strong><br />
|
||
|
|
You can use iSeries Navigator to compare data sets in two different
|
||
|
|
monitors. </li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzajqmonstatements.htm">Viewing statements in a monitor</a></strong><br />
|
||
|
|
You can view SQL statements that are included in a detailed monitor.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzajqimportmon1.htm">Importing a monitor</a></strong><br />
|
||
|
|
You can import monitor data that has been collected using <span class="cmdname">Start
|
||
|
|
Database Monitor (STRDBMON)</span> command or some other interface
|
||
|
|
by using iSeries Navigator.</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="queryopt.htm" title="Query optimization is an iterative process. You can gather performance information about your queries and control the processing of your queries.">Optimizing query performance using query optimization tools</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<img src="./deltaend.gif" alt="End of change" /></body>
|
||
|
|
</html>
|