179 lines
6.1 KiB
HTML
179 lines
6.1 KiB
HTML
|
|
||
|
|
<!doctype html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
|
||
|
|
<html>
|
||
|
|
<head><META http-equiv="Content-Type" content="text/html; charset=utf-8">
|
||
|
|
<title>Analyze Database Files (ANZDBF)</title>
|
||
|
|
</head>
|
||
|
|
<body bgcolor="white">
|
||
|
|
<a name="ANZDBF.Top_Of_Page"></a>
|
||
|
|
<h2>Analyze Database Files (ANZDBF)</h2>
|
||
|
|
<table width="100%">
|
||
|
|
<tr>
|
||
|
|
<td valign="top" align="left"><b>Where allowed to run: </b>All environments (*ALL)<br>
|
||
|
|
<b>Threadsafe: </b>No
|
||
|
|
</td>
|
||
|
|
<td valign="top" align="right">
|
||
|
|
<a href="#ANZDBF.PARAMETERS.TABLE">Parameters</a><br>
|
||
|
|
<a href="#ANZDBF.COMMAND.EXAMPLES">Examples</a><br>
|
||
|
|
<a href="#ANZDBF.ERROR.MESSAGES">Error messages</a></td>
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
|
||
|
|
<div> <a name="ANZDBF"></a>
|
||
|
|
<p>The Analyze Database Files (ANZDBF) command produces two reports that show the physical and logical files in a set of libraries and the relationships between the files. It saves the information in a database file for further analysis by the Analyze Database File Keys (ANZDBFKEY) command. Both reports (physical to logical file relationships and logical to physical file relationships) are written to the printer file QPPTANZD. Two printer files with the same name are produced. The data is saved in member QAPTAZDR of the database file QPFRDATA/QAPTAZDR.
|
||
|
|
</p>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#ANZDBF.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
<hr size="2" width="100%">
|
||
|
|
|
||
|
|
<div>
|
||
|
|
<h3><a name="ANZDBF.PARAMETERS.TABLE">Parameters</a></h3>
|
||
|
|
<table border="1" cellpadding="4" cellspacing="0">
|
||
|
|
<!-- col1="10" col2="15" col3="30" col4="10" -->
|
||
|
|
<tr>
|
||
|
|
<th bgcolor="aqua" valign="bottom" align="left">Keyword</th>
|
||
|
|
<th bgcolor="aqua" valign="bottom" align="left">Description</th>
|
||
|
|
<th bgcolor="aqua" valign="bottom" align="left">Choices</th>
|
||
|
|
<th bgcolor="aqua" valign="bottom" align="left">Notes</th>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td valign="top"><a href="#ANZDBF.LIBL"><b>LIBL</b></a></td>
|
||
|
|
<td valign="top">Application libraries</td>
|
||
|
|
<td valign="top">Values (up to 10 repetitions): <i>Name</i></td>
|
||
|
|
<td valign="top">Required, Positional 1</td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td valign="top"><a href="#ANZDBF.JOB"><b>JOB</b></a></td>
|
||
|
|
<td valign="top">Job name</td>
|
||
|
|
<td valign="top"><i>Name</i>, <b><u>ANZDBF</u></b></td>
|
||
|
|
<td valign="top">Optional</td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td valign="top" rowspan="3"><a href="#ANZDBF.JOBD"><b>JOBD</b></a></td>
|
||
|
|
<td valign="top">Job description</td>
|
||
|
|
<td valign="top">Single values: *NONE<br>Other values: <i>Qualified object name</i></td>
|
||
|
|
<td valign="top" rowspan="3">Optional</td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td valign="top">Qualifier 1: Job description</td>
|
||
|
|
<td valign="top"><i>Name</i>, <b><u>QPFRJOBD</u></b></td>
|
||
|
|
</tr><tr>
|
||
|
|
<td valign="top">Qualifier 2: Library</td>
|
||
|
|
<td valign="top"><i>Name</i>, <b><u>*LIBL</u></b>, *CURLIB</td>
|
||
|
|
</tr></table>
|
||
|
|
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#ANZDBF.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
</div>
|
||
|
|
<div> <a name="ANZDBF.LIBL"></a>
|
||
|
|
<h3>Application libraries (LIBL)</h3>
|
||
|
|
<p>Specifies the libraries that contain the database files on which to report.
|
||
|
|
</p>
|
||
|
|
<p>This is a required parameter.
|
||
|
|
</p>
|
||
|
|
<p>You can enter multiple values for this parameter.
|
||
|
|
</p>
|
||
|
|
<dl>
|
||
|
|
<dt><b><i>library-name</i></b></dt>
|
||
|
|
<dd>Specify up to 10 library names that are to be included in the Analyze Database File report.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#ANZDBF.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
<div> <a name="ANZDBF.JOB"></a>
|
||
|
|
<h3>Job name (JOB)</h3>
|
||
|
|
<p>Specifies the job name to be used if submitting the job for batch processing.
|
||
|
|
</p>
|
||
|
|
<p>Any value for this parameter is ignored if *NONE is specified for the <b>Job description</b> prompt (JOBD parameter).
|
||
|
|
</p>
|
||
|
|
<p>
|
||
|
|
<b>Note: </b>If *NONE is specified for the <b>Job description</b> prompt (JOBD parameter), job processing is performed interactively.
|
||
|
|
</p>
|
||
|
|
<p>The possible <b>job name</b> values are:
|
||
|
|
</p>
|
||
|
|
<dl>
|
||
|
|
<dt><b><u>ANZDBF</u></b></dt>
|
||
|
|
<dd>The command name is used for the job name.
|
||
|
|
</dd>
|
||
|
|
<dt><b><i>job-name</i></b></dt>
|
||
|
|
<dd>Specify the name to be used for any and all batch jobs.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#ANZDBF.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
<div> <a name="ANZDBF.JOBD"></a>
|
||
|
|
<h3>Batch job description (JOBD)</h3>
|
||
|
|
<p>Specifies the job description used to submit the job for batch processing.
|
||
|
|
</p>
|
||
|
|
<p>The possible job description values are:
|
||
|
|
</p>
|
||
|
|
<dl>
|
||
|
|
<dt><b><u>QPFRJOBD</u></b></dt>
|
||
|
|
<dd>The IBM-supplied job description, QPFRJOBD, is used.
|
||
|
|
</dd>
|
||
|
|
<dt><b><i>job-description-name</i></b></dt>
|
||
|
|
<dd>Specify the name of an alternate job description.
|
||
|
|
</dd>
|
||
|
|
<dt><b>*NONE</b></dt>
|
||
|
|
<dd>A batch job is not submitted; processing continues interactively while the user waits. The user's workstation is not available for other use during this time, which could be significant for long jobs.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
<p>The possible library values are:
|
||
|
|
</p>
|
||
|
|
<dl>
|
||
|
|
<dt><b><u>*LIBL</u></b></dt>
|
||
|
|
<dd>All libraries in the job's library list are searched until the first match is found.
|
||
|
|
</dd>
|
||
|
|
<dt><b>*CURLIB</b></dt>
|
||
|
|
<dd>The current library for the job is used to locate the job description. If no current library entry exists in the library list, QGPL is used.
|
||
|
|
</dd>
|
||
|
|
<dt><b><i>library-name</i></b></dt>
|
||
|
|
<dd>Specify the library in which the job description is located.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#ANZDBF.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
<hr size="2" width="100%">
|
||
|
|
<div><h3><a name="ANZDBF.COMMAND.EXAMPLES">Examples</a> </h3>
|
||
|
|
<p>
|
||
|
|
<pre>
|
||
|
|
ANZDBF LIBL(APDTA ARDTA)
|
||
|
|
</pre>
|
||
|
|
</p>
|
||
|
|
<p>This command produces reports showing the relationships for all files in the Accounts Payable (APDTA) and Accounts Receivable (ARDTA) data libraries.
|
||
|
|
</p>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#ANZDBF.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
<hr size="2" width="100%">
|
||
|
|
<div><h3><a name="ANZDBF.ERROR.MESSAGES">Error messages</a> </h3>
|
||
|
|
<p><b><u>*ESCAPE Messages</u></b>
|
||
|
|
</p>
|
||
|
|
<dl>
|
||
|
|
<dt><b>CPF9801</b></dt>
|
||
|
|
<dd>Object &2 in library &3 not found.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF9802</b></dt>
|
||
|
|
<dd>Not authorized to object &2 in &3.
|
||
|
|
</dd>
|
||
|
|
<dt><b>PFR9802</b></dt>
|
||
|
|
<dd>Unexpected message monitored.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#ANZDBF.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
</body>
|
||
|
|
</html>
|