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

99 lines
6.6 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="reference" />
<meta name="DC.Title" content="Find job logs from TCP/IP server prestart jobs" />
<meta name="abstract" content="When the connection ends that is serviced by one of the QRWTSRVR prestart jobs associated with the distributed data management (DDM) TCP/IP server, the prestart job is recycled for use by another connection. When this happens, the job log associated with the ended connection is cleared." />
<meta name="description" content="When the connection ends that is serviced by one of the QRWTSRVR prestart jobs associated with the distributed data management (DDM) TCP/IP server, the prestart job is recycled for use by another connection. When this happens, the job log associated with the ended connection is cleared." />
<meta name="DC.subject" content="finding job logs from TCP/IP server prestart jobs, TCP/IP, finding server job logs, finding job logs, forcing job logs to be saved" />
<meta name="keywords" content="finding job logs from TCP/IP server prestart jobs, TCP/IP, finding server job logs, finding job logs, forcing job logs to be saved" />
<meta name="DC.Relation" scheme="URI" content="rbal1gdrf.htm" />
<meta name="DC.Relation" scheme="URI" content="rbal1qrwoptions.htm" />
<meta name="DC.Relation" scheme="URI" content="../cl/strsrvjob.htm" />
<meta name="DC.Relation" scheme="URI" content="../cl/dsplog.htm" />
<meta name="DC.Relation" scheme="URI" content="../cl/strdbg.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="rbal1findjl" />
<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>Find job logs from TCP/IP server prestart jobs</title>
</head>
<body id="rbal1findjl"><a name="rbal1findjl"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">Find job logs from TCP/IP server prestart jobs</h1>
<div><p>When the connection ends that is serviced by one of the QRWTSRVR
prestart jobs associated with the distributed data management (DDM) TCP/IP
server, the prestart job is recycled for use by another connection. When this
happens, the job log associated with the ended connection is cleared.</p>
<div class="section"><p>However, in certain cases the job log is spooled to a printer
file before it is cleared. The job log is not printed to a spooled file if
the client user ID and password were not successfully validated. If validation
was successful, these are the conditions under which the job log is printed
to a spooled file:</p>
</div>
<div class="section"> <ul><li>If the operating system is at V5R1 or later and the server job's message
logging text level is *SECLVL or *MSG.</li>
<li>If the server request handler routing program detects that a serious error
occurred in processing the request that ended the connection.</li>
<li>If the prestart job was being serviced (by use of the <span class="cmdname">Start Service
Job (STRSRVJOB)</span> command).</li>
<li>If the QRWOPTIONS data area on the client or server specified a job log
output condition that was satisfied by the server job.</li>
</ul>
</div>
<div class="section"><p>You might want to get job log information for several reasons.
It is obviously useful for diagnosing errors. It can also be useful for analyzing
performance problems. For example, if you want to get SQL optimizer data that
is generated when running under debug, you can either manually start a service
job and run the <span class="cmdname">Start Debug (STRDBG)</span> command, or you can
set one or more applicable options in the QRWOPTIONS data area to cause the
job log to be retained.</p>
</div>
<div class="section"><p>The logs of jobs in which failures occur during the connection
phase will not be saved by the process described above. Jobs that are saved
by that process will not be stored under the prestart job ID. To find them,
run the following command: </p>
<pre>WRKJOB userid/QPRTJOB</pre>
<p>where <em>userid</em> is
the user ID used on the CONNECT to the application server (AS). You can find
that user ID if you do not know it with the <span class="cmdname">Display Log (DSPLOG)</span> command
on the AS.</p>
</div>
<div class="section"><p>You can filter out unwanted messages by use of parameters like
this: </p>
<pre>DSPLOG PERIOD(('11:00')) MSGID(CPI3E34) </pre>
</div>
<div class="section"><p>Look for the following message. Note, however, that if the QRWOPTIONS
data area has been used to suppress this message (CPI3E34), it will not appear
in the history log. </p>
<pre>DDM job xxxx servicing user yyy on ddd at ttt.</pre>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbal1gdrf.htm" title="This topic collection describes the kinds of data that you can print to help you diagnose a problem in a distributed relational database on iSeries servers.">Get data to report a failure</a></div>
</div>
<div class="relconcepts"><strong>Related concepts</strong><br />
<div><a href="rbal1qrwoptions.htm" title="When DDM or DRDA TCP/IP server jobs are initiated, they look for a data area in which the user can specify diagnostic and other options. The name is QRWOPTIONS, and it must reside in the QGPL library to take effect. It consists of a string of 48 characters.">QRWOPTIONS data area</a></div>
</div>
<div class="relinfo"><strong>Related information</strong><br />
<div><a href="../cl/strsrvjob.htm">Start Service Job (STRSRVJOB) command</a></div>
<div><a href="../cl/dsplog.htm">Display Log (DSPLOG) command</a></div>
<div><a href="../cl/strdbg.htm">Start Debug (STRDBG) command</a></div>
</div>
</div>
</body>
</html>