ibm-information-center/dist/eclipse/plugins/i5OS.ic.ddp_5.4.0.1/rbal1act.htm

125 lines
7.8 KiB
HTML
Raw Permalink Normal View History

2024-04-02 14:02:31 +00:00
<?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
===&gt;
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
===&gt;
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>