117 lines
7.9 KiB
HTML
117 lines
7.9 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="concept" />
|
||
|
|
<meta name="DC.Title" content="Display the relationships between files on the system" />
|
||
|
|
<meta name="abstract" content="Use the Display Database Relations (DSPDBR) command to display the relationships between files on the system. This information can be displayed, printed, or written to a database output file (OUTFILE)." />
|
||
|
|
<meta name="description" content="Use the Display Database Relations (DSPDBR) command to display the relationships between files on the system. This information can be displayed, printed, or written to a database output file (OUTFILE)." />
|
||
|
|
<meta name="DC.subject" content="displaying, relationships between files on the system, database file, relationships between, Display Database Relations (DSPDBR) command, DSPDBR (Display Database Relations) command, command, CL, DSPDBR (Display Database Relations), Display Database Relations (DSPDBR), database relations" />
|
||
|
|
<meta name="keywords" content="displaying, relationships between files on the system, database file, relationships between, Display Database Relations (DSPDBR) command, DSPDBR (Display Database Relations) command, command, CL, DSPDBR (Display Database Relations), Display Database Relations (DSPDBR), database relations" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafofilexr.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/dspdbr.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../rbam6/rbam6clmain.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="rbafoddbrl" />
|
||
|
|
<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> Display the relationships between files on the system</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbafoddbrl"><a name="rbafoddbrl"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1"> Display the relationships between files on the system</h1>
|
||
|
|
<div><p>Use the Display Database Relations (DSPDBR) command to display
|
||
|
|
the relationships between files on the system. This information can be displayed,
|
||
|
|
printed, or written to a database output file (OUTFILE).</p>
|
||
|
|
<div class="p">You can use the DSPDBR command to display the following information about
|
||
|
|
the organization of your database: <ul><li>A list of database files (physical and logical) that use a specific record
|
||
|
|
format.</li>
|
||
|
|
<li>A list of database files (physical and logical) that depend on the specified
|
||
|
|
file for data sharing.</li>
|
||
|
|
<li>A list of members (physical and logical) that depend on the specified
|
||
|
|
member for sharing data or sharing an access path.</li>
|
||
|
|
<li>A list of physical files that are dependent files in a referential constraint
|
||
|
|
relationship with this file.</li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
<div class="p">For example, to display a list of all database files associated with physical
|
||
|
|
file ORDHDRP, with the record format ORDHDR, type the following DSPDBR command: <pre>DSPDBR FILE(DSTPRODLB/ORDHDRP) RCDFMT(ORDHDR)</pre>
|
||
|
|
<div class="note"><span class="notetitle">Note:</span> See the DSPDBR command description in the Control language (CL) topic
|
||
|
|
for details of this display.</div>
|
||
|
|
</div>
|
||
|
|
<p>This display presents header information when a record format name is specified
|
||
|
|
on the RCDFMT parameter, and presents information about which files are using
|
||
|
|
the specified record format.</p>
|
||
|
|
<p>If a member name is specified on the MBR parameter of the DSPDBR command,
|
||
|
|
the dependent members are shown.</p>
|
||
|
|
<p>If the DSPDBR command is specified with the default MBR(*NONE) parameter
|
||
|
|
value, the dependent data files are shown. To display the shared access paths,
|
||
|
|
you must specify a member name.</p>
|
||
|
|
<p>The DSPDBR command output identifies the type of sharing involved. If the
|
||
|
|
results of the command are displayed, the name of the type of sharing is displayed.
|
||
|
|
If the results of the command are written to a database file, the code for
|
||
|
|
the type of sharing (shown below) is placed in the <em>WHTYPE</em> field in
|
||
|
|
the records of the output file.</p>
|
||
|
|
|
||
|
|
<table cellpadding="4" cellspacing="0" border="1" class="tableborder"><tr><td>
|
||
|
|
<table cellpadding="4" cellspacing="0" summary="" width="100%" border="0"><thead align="left"><tr><th valign="bottom" width="23.376623376623375%" id="d0e75">Type</th>
|
||
|
|
<th align="center" valign="bottom" width="38.44155844155844%" id="d0e77">Code</th>
|
||
|
|
<th align="left" valign="bottom" width="38.18181818181819%" id="d0e79">Description</th>
|
||
|
|
</tr>
|
||
|
|
</thead>
|
||
|
|
<tbody><tr><td valign="top" width="23.376623376623375%" headers="d0e75 ">Constraint</td>
|
||
|
|
<td align="center" valign="top" width="38.44155844155844%" headers="d0e77 ">C</td>
|
||
|
|
<td align="left" valign="top" width="38.18181818181819%" headers="d0e79 ">The physical file is dependent on the data
|
||
|
|
in another physical file with which it is associated via a constraint.</td>
|
||
|
|
</tr>
|
||
|
|
<tr><td valign="top" width="23.376623376623375%" headers="d0e75 ">Data</td>
|
||
|
|
<td align="center" valign="top" width="38.44155844155844%" headers="d0e77 ">D</td>
|
||
|
|
<td align="left" valign="top" width="38.18181818181819%" headers="d0e79 ">The file or member is dependent on the data
|
||
|
|
in a member of another file.</td>
|
||
|
|
</tr>
|
||
|
|
<tr><td valign="top" width="23.376623376623375%" headers="d0e75 ">Access path sharing</td>
|
||
|
|
<td align="center" valign="top" width="38.44155844155844%" headers="d0e77 ">I</td>
|
||
|
|
<td align="left" valign="top" width="38.18181818181819%" headers="d0e79 ">The file member is sharing an access path.</td>
|
||
|
|
</tr>
|
||
|
|
<tr><td valign="top" width="23.376623376623375%" headers="d0e75 ">Access path owner</td>
|
||
|
|
<td align="center" valign="top" width="38.44155844155844%" headers="d0e77 ">O</td>
|
||
|
|
<td align="left" valign="top" width="38.18181818181819%" headers="d0e79 ">If an access path is shared, one of the file
|
||
|
|
members is considered the owner. The owner of the access path is charged with
|
||
|
|
the storage used for the access path. If the member displayed is designated
|
||
|
|
the owner, one or more file members are designated with an I for access path
|
||
|
|
sharing.</td>
|
||
|
|
</tr>
|
||
|
|
<tr><td valign="top" width="23.376623376623375%" headers="d0e75 ">SQL View</td>
|
||
|
|
<td align="center" valign="top" width="38.44155844155844%" headers="d0e77 ">V</td>
|
||
|
|
<td align="left" valign="top" width="38.18181818181819%" headers="d0e79 ">The SQL view or member is dependent on another
|
||
|
|
SQL view.</td>
|
||
|
|
</tr>
|
||
|
|
</tbody>
|
||
|
|
</table>
|
||
|
|
</td></tr></table>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafofilexr.htm" title="You can display the file attributes for database files and device files using the display table description operation in iSeries Navigator.">Display information about database files</a></div>
|
||
|
|
</div>
|
||
|
|
<div class="relconcepts"><strong>Related concepts</strong><br />
|
||
|
|
<div><a href="../rbam6/rbam6clmain.htm">Control language (CL)</a></div>
|
||
|
|
</div>
|
||
|
|
<div class="relref"><strong>Related reference</strong><br />
|
||
|
|
<div><a href="../cl/dspdbr.htm">Display Database Relations (DSPDBR) command</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|