125 lines
7.8 KiB
HTML
125 lines
7.8 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="task" />
|
|
<meta name="DC.Title" content="Work with active jobs in a distributed relational database" />
|
|
<meta name="abstract" content="Use the Work with Active Jobs (WRKACTJOB) command if you want to monitor the jobs running for several users or if you are looking for a job and you do not know the job name or the user ID." />
|
|
<meta name="description" content="Use the Work with Active Jobs (WRKACTJOB) command if you want to monitor the jobs running for several users or if you are looking for a job and you do not know the job name or the user ID." />
|
|
<meta name="DC.subject" content="administration task, working with active jobs, database administration, working with, active jobs, command, WRKACTJOB (Work with Active Jobs), Work with Active Jobs (WRKACTJOB), command, CL, WRKACTJOB (Work with Active Jobs), subsystem" />
|
|
<meta name="keywords" content="administration task, working with active jobs, database administration, working with, active jobs, command, WRKACTJOB (Work with Active Jobs), Work with Active Jobs (WRKACTJOB), command, CL, WRKACTJOB (Work with Active Jobs), subsystem" />
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1rdbactv.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/wrkactjob.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1improvesystem.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1appnotcomp.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="rbal1act" />
|
|
<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>Work with active jobs in a distributed relational database</title>
|
|
</head>
|
|
<body id="rbal1act"><a name="rbal1act"><!-- --></a>
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|
<h1 class="topictitle1">Work with active jobs in a distributed relational database</h1>
|
|
<div><p>Use the <span class="cmdname">Work with Active Jobs (WRKACTJOB)</span> command
|
|
if you want to monitor the jobs running for several users or if you are looking
|
|
for a job and you do not know the job name or the user ID.</p>
|
|
<div class="section"> <p>When you enter this command, the Work with Active
|
|
Jobs display appears. It shows the performance and status information for
|
|
jobs that are currently active on the server. All information is gathered
|
|
on a job basis and grouped by subsystem.</p>
|
|
<p>The display here shows the
|
|
Work with Active Jobs display on a typical day at the KC105 system: </p>
|
|
<pre class="screen">Work with Active Jobs KC105
|
|
03/29/92 16:17:45
|
|
CPU %: 41.7 Elapsed time: 04:37:55 Active jobs: 42
|
|
|
|
Type options, press Enter.
|
|
2=Change 3=Hold 4=End 5=Work with 6=Release 7=Display message
|
|
8=Work with spooled files 13=Disconnect ...
|
|
|
|
Opt Subsystem/Job User Type CPU % Function Status
|
|
__ QBATCH QSYS SBS .0 DEQW
|
|
__ QCMN QSYS SBS .0 DEQW
|
|
__ QINTER QSYS SBS .0 DEQW
|
|
__ DSP01 CLERK1 INT .0 CMD-STRSQL DSPW
|
|
__ DSP02 CLERK2 INT .0 * -CMDENT DSPW
|
|
|
|
|
|
|
|
|
|
More...
|
|
Parameters or command
|
|
===>
|
|
F3=Exit F5=Refresh F10=Restart statistics F11=Display elapsed data
|
|
F12=Cancel F23=More options F24=More keys
|
|
</pre>
|
|
<p>When you press F11 (Display elapsed data), the following display
|
|
is provided to give you detailed status information. </p>
|
|
<pre class="screen">Work with Active Jobs KC105
|
|
03/29/92 16:17:45
|
|
CPU %: 41.7 Elapsed time: 04:37:55 Active jobs: 42
|
|
|
|
Type options, press Enter.
|
|
2=Change 3=Hold 4=End 5=Work with 6=Release 7=Display message
|
|
8=Work with spooled files 13=Disconnect ...
|
|
--------Elapsed---------
|
|
Opt Subsystem/Job Type Pool Pty CPU Int Rsp AuxIO CPU %
|
|
__ QBATCH SBS 2 0 4.4 108 .0
|
|
__ QCMN SBS 2 0 20.7 668 .0
|
|
__ KC000 EVK 2 50 .1 9 .0
|
|
__ KC0001 EVK 2 50 .1 9 .0
|
|
__ MP000 EVK 2 50 .1 14 .0
|
|
__ QINTER SBS 2 0 7.3 4 .0
|
|
__ DSP01 INT 2 20 .1 0 .0
|
|
__ DSP02 INT 2 20 .1 0 .0
|
|
|
|
More...
|
|
Parameters or command
|
|
===>
|
|
F3=Exit F5=Refresh F10=Restart statistics F11=Display status
|
|
F12=Cancel F23=More options F24=More keys
|
|
</pre>
|
|
<p>The Work with Active Jobs display gives you information about
|
|
job priority and server usage as well as the user and type information you
|
|
get from the Work with User Jobs display. You also can use any of 11 options
|
|
on a job (2 through 11 and 13), including option 5, which presents you with
|
|
the Work with Job display for the selected job. Use the <span class="cmdname">Work with
|
|
Active Jobs (WRKACTJOB)</span> command if you want to monitor the jobs
|
|
running for several users or if you are looking for a job and you do not know
|
|
the job name or the user ID.</p>
|
|
<p>Another method to view information about
|
|
job priority and server usage is to use the iSeries™ Navigator. To do this, follow
|
|
these steps:</p>
|
|
</div>
|
|
<ol><li><span>Select <span class="uicontrol">Databases</span> in the iSeries Navigator
|
|
interface.</span></li>
|
|
<li><span>Select a remote database you want to view information about.</span></li>
|
|
<li><span>Right-click and select <span class="uicontrol">Properties</span>. This
|
|
opens a properties window with the information displayed. </span></li>
|
|
</ol>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbal1rdbactv.htm" title="You can rely on control language (CL) commands, all of which provide similar information, but in different ways, to give you a view of work on an iSeries server.">Monitor relational database activity</a></div>
|
|
</div>
|
|
<div class="relref"><strong>Related reference</strong><br />
|
|
<div><a href="../cl/wrkactjob.htm">Work with Active Jobs (WRKACTJOB) command</a></div>
|
|
<div><a href="rbal1improvesystem.htm" title="Achieving efficient server performance requires a proper balance among server resources. Overusing any resource adversely affects performance. This topic describes the server commands that are available to help you observe the performance of your server.">Improve distributed relational database performance through the server</a></div>
|
|
<div><a href="rbal1appnotcomp.htm" title="If the request takes longer than expected to complete, the first place to check is at the application requester (AR).">Application does not complete in the expected time</a></div>
|
|
</div>
|
|
</div>
|
|
</body>
|
|
</html> |