106 lines
7.2 KiB
HTML
106 lines
7.2 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="Track request information with the job log of a distributed relational database" />
|
|
<meta name="abstract" content="Every job on the iSeries server has a job log that contains information related to requests entered for a job." />
|
|
<meta name="description" content="Every job on the iSeries server has a job log that contains information related to requests entered for a job." />
|
|
<meta name="DC.subject" content="administration task, displaying job log, database administration, command, DSPJOBLOG (Display Job Log), Display Job Log (DSPJOBLOG), command, CL, Display Job Log (DSPJOBLOG), job log, displaying" />
|
|
<meta name="keywords" content="administration task, displaying job log, database administration, command, DSPJOBLOG (Display Job Log), Display Job Log (DSPJOBLOG), command, CL, Display Job Log (DSPJOBLOG), job log, displaying" />
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1rdbactv.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/dspjoblog.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/wrkactjob.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/wrkjob.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/wrkusrjob.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1drdmessage.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1pjl.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="rbal1usejl" />
|
|
<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>Track request information with the job log of a distributed relational
|
|
database</title>
|
|
</head>
|
|
<body id="rbal1usejl"><a name="rbal1usejl"><!-- --></a>
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|
<h1 class="topictitle1">Track request information with the job log of a distributed relational
|
|
database</h1>
|
|
<div><p>Every job on the <span class="keyword">iSeries™ server</span> has
|
|
a job log that contains information related to requests entered for a job.</p>
|
|
<div class="section"> <p>The information in a job log includes:</p>
|
|
<ul><li>Commands that were used by a job</li>
|
|
<li>Messages that were sent and not removed from the program message queues</li>
|
|
<li>Commands in a CL program if the program was created with LOGCLPGM(*JOB)
|
|
and the job specifies LOGCLPGM(*YES) or the CL program was created with LOGCLPGM(*YES)</li>
|
|
</ul>
|
|
<p>At the end of the job, the job log can be written to a spooled file
|
|
named QPJOBLOG and the original job log is deleted. You can control what information
|
|
is written in the job log by specifying the LOG parameter of a job description.</p>
|
|
<p>The
|
|
way to display a job log depends on the status of the job. If the job has
|
|
ended and the job log is not yet printed, find the job using the <span class="cmdname">Work
|
|
with User Jobs (WRKUSRJOB)</span> command, then select option 8 (Display
|
|
spooled file). Find the spooled file named QPJOBLOG and select option 5 (Display
|
|
job log). You can also display a job log by using the <span class="cmdname">Work with
|
|
Job (WRKJOB)</span> command and other options on the Work with Job display.</p>
|
|
<p>If
|
|
the batch or interactive job is still active, or is on a job queue and has
|
|
not yet started, use the <span class="cmdname">WRKUSRJOB</span> command to find the
|
|
job. The <span class="cmdname">Work with Active Jobs (WRKACTJOB)</span> command is
|
|
used to display the job log of active jobs and does not show jobs on job queues.
|
|
Select option 5 (Work with job) and then select option 10 (Display job log).</p>
|
|
<p>To
|
|
display the job log of your own interactive job, do one of the following things:
|
|
</p>
|
|
<ul><li>Enter the <span class="cmdname">Display Job Log (DSPJOBLOG)</span> command.</li>
|
|
<li>Enter the <span class="cmdname">Work with Job (WRKJOB)</span> command and select
|
|
option 10 (Display job log) from the Work with Job display.</li>
|
|
<li>Press F10 (Display detailed messages) from the Command Entry display to
|
|
display messages that are shown in the job log.</li>
|
|
</ul>
|
|
<p>When you use the <span class="cmdname">Display Job Log (DSPJOBLOG)</span> command,
|
|
you see the Job Log display. This display shows program names with special
|
|
symbols, as follows: </p>
|
|
<dl><dt class="dlterm"><samp class="codeph">>></samp></dt>
|
|
<dd>The running command or the next command to be run. For example, if a CL
|
|
or high-level language program was called, the call to the program is shown.</dd>
|
|
<dt class="dlterm"><samp class="codeph"> ></samp></dt>
|
|
<dd>The command has completed processing.</dd>
|
|
<dt class="dlterm"><samp class="codeph">. .</samp></dt>
|
|
<dd>The command has not yet been processed.</dd>
|
|
<dt class="dlterm"><samp class="codeph"> ?</samp></dt>
|
|
<dd>Reply message. This symbol marks both those messages needing a reply
|
|
and those that have been answered.</dd>
|
|
</dl>
|
|
</div>
|
|
</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="reltasks"><strong>Related tasks</strong><br />
|
|
<div><a href="rbal1pjl.htm" title="Every job on the iSeries server has a job log that contains information related to requests entered for that job. When a user is having a problem at an application requester (AR), the information in the job log might be helpful in diagnosing the problem.">Print a job log</a></div>
|
|
</div>
|
|
<div class="relref"><strong>Related reference</strong><br />
|
|
<div><a href="../cl/dspjoblog.htm">Display Job Log (DSPJOBLOG) command</a></div>
|
|
<div><a href="../cl/wrkactjob.htm">Work with Active Jobs (WRKACTJOB) command</a></div>
|
|
<div><a href="../cl/wrkjob.htm">Work with Job (WRKJOB) command</a></div>
|
|
<div><a href="../cl/wrkusrjob.htm">Work with User Jobs (WRKUSRJOB) command</a></div>
|
|
<div><a href="rbal1drdmessage.htm" title="If an error message occurs at either an application server (AS) or an application requester (AR), the server message is logged on the job log to indicate the reason for the failure.">Distributed relational database messages</a></div>
|
|
</div>
|
|
</div>
|
|
</body>
|
|
</html> |