friedkiwi/ibm-information-center
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
master
ibm-information-center/dist/eclipse/plugins/i5OS.ic.dbp_5.4.0.1/rbafoapplck.htm

386 lines
26 KiB
HTML
Raw Permalink Normal View History

Add readme and dist folders
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="Database lock considerations" />
<meta name="abstract" content="Listed here are the commonly used database functions and the types of locks they place on database files." />
<meta name="description" content="Listed here are the commonly used database functions and the types of locks they place on database files." />
<meta name="DC.subject" content="database file, locking, considerations, summary, database, locks" />
<meta name="keywords" content="database file, locking, considerations, summary, database, locks" />
<meta name="DC.Relation" scheme="URI" content="rbafoconcc.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="rbafoapplck" />
<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>Database lock considerations</title>
</head>
<body id="rbafoapplck"><a name="rbafoapplck"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">Database lock considerations</h1>
<div><p>Listed here are the commonly used database functions and the types
of locks they place on database files.</p>
<div class="section"><p><a href="#rbafoapplck__rbafotest">Table 1</a> summarizes some of
the most commonly used database functions and the types of locks they place
on database files. The types of locks are explained on the next page. </p>
</div>
<div class="tablenoborder"><a name="rbafoapplck__rbafotest"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="rbafoapplck__rbafotest" width="100%" frame="hsides" border="0" rules="none"><caption>Table 1. Database functions
and locks</caption><thead align="left"><tr><th align="left" valign="top" width="19.94949494949495%" id="d0e41">Function</th>
<th align="left" valign="top" width="19.94949494949495%" id="d0e43">Command</th>
<th align="left" valign="top" width="19.94949494949495%" id="d0e45">File Lock</th>
<th align="left" valign="top" width="19.94949494949495%" id="d0e47">Member/Data Lock</th>
<th align="left" valign="top" width="20.2020202020202%" id="d0e49">Access Path Lock</th>
</tr>
</thead>
<tbody><tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Add Member</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">ADDPFM, ADDLFM</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*EXCLRD</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 "> </td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 ">*EXCLRD</td>
</tr>
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Change File Attributes</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">CHGPF, CHGLF</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*EXCL</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 ">*EXCLRD</td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 ">*EXCLRD</td>
</tr>
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Change Member Attributes</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">CHGPFM, CHGLFM</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*SHRRD</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 ">*EXCLRD</td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 "> </td>
</tr>
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Change Object Owner</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">CHGOBJOWN</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*EXCL</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 "> </td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 "> </td>
</tr>
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Check Object</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">CHKOBJ</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*SHRNUPD</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 "> </td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 "> </td>
</tr>
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Clear Physical File Member</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">CLRPFM</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*SHRRD</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 ">*EXCLRD<sup>3</sup></td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 "> </td>
</tr>
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Create Duplicate Object</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">CRTDUPOBJ</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*EXCL (new object) *SHRNUPD (object)</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 "> </td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 "> </td>
</tr>
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Create File</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">CRTPF, CRTLF, CRTSRCPF</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*EXCL</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 "> </td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 "> </td>
</tr>
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Delete File</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">DLTF</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*EXCL</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 "> </td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 ">*EXCLRD</td>
</tr>
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Grant/Revoke Authority</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">GRTOBJAUT, RVKOBJAUT</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*EXCL</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 "> </td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 "> </td>
</tr>
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Initialize Physical File Member</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">INZPFM</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*SHRRD</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 ">*EXCLRD</td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 "> </td>
</tr>
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Move Object</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">MOVOBJ</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*EXCL</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 "> </td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 "> </td>
</tr>
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Open File</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">OPNDBF, OPNQRYF</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*SHRRD</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 ">*SHRRD</td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 ">*EXCLRD</td>
</tr>
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Rebuild Access Path</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">EDTRBDAP, OPNDBF</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*SHRRD</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 ">*SHRRD</td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 ">*EXCLRD</td>
</tr>
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Remove Member</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">RMVM</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*EXCLRD</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 ">*EXCL</td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 ">*EXCLRD</td>
</tr>
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Rename File</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">RNMOBJ</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*EXCL</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 ">*EXCL</td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 ">*EXCL</td>
</tr>
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Rename Member</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">RNMM</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*EXCLRD</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 ">*EXCL</td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 ">*EXCL</td>
</tr>
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Reorganize Physical File Member</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">RGZPFM</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*SHRRD</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 ">*EXCL<sup>4</sup></td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 "> </td>
</tr>
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Restore File</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">RSTLIB, RSTOBJ</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*EXCL</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 "> </td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 "> </td>
</tr>
<tr><td align="left" valign="top" width="19.94949494949495%" headers="d0e41 ">Save File</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e43 ">SAVLIB, SAVOBJ, SAVCHGOBJ</td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e45 ">*SHRNUPD<sup>1</sup></td>
<td align="left" valign="top" width="19.94949494949495%" headers="d0e47 ">*SHRNUPD<sup>2</sup></td>
<td align="left" valign="top" width="20.2020202020202%" headers="d0e49 "> </td>
</tr>
<tr><td colspan="5" align="left" valign="top" headers="d0e41 d0e43 d0e45 d0e47 d0e49 "><p><sup>1</sup> For
save-while-active, the file lock is *SHRUPD initially, and then the lock is
reduced to *SHRRD. See the <a href="../books/sc415304.pdf" target="_blank">Backup and Recovery</a> <img src="wbpdf.gif" alt="Link to PDF" /> for a description of save-while-active locks for
the save commands.</p>
<p><sup>2</sup> For save-while-active, the member/data
lock is *SHRRD.</p>
<p><sup>3</sup> The clear operation does not happen if
the member is open in this process or in any other process.</p>
<p><sup>4</sup> If
ALWCANCEL(*YES) is specified, the LOCK keyword can specify a *SHRUPD or *EXCLRD
lock instead.</p>
</td>
</tr>
</tbody>
</table>
</div>
<div class="section"><p>The following table shows the valid lock combinations: </p>
</div>
<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 align="left" valign="bottom" width="16.666666666666664%" id="d0e316">Lock</th>
<th align="center" valign="bottom" width="16.666666666666664%" id="d0e318">*EXCL</th>
<th align="center" valign="bottom" width="16.666666666666664%" id="d0e320">*EXCLRD</th>
<th align="center" valign="bottom" width="16.666666666666664%" id="d0e322">*SHRUPD</th>
<th align="center" valign="bottom" width="16.666666666666664%" id="d0e324">*SHRNUPD</th>
<th align="center" valign="bottom" width="16.666666666666664%" id="d0e326">*SHRRD</th>
</tr>
</thead>
<tbody><tr><td align="left" valign="top" width="16.666666666666664%" headers="d0e316 ">*EXCL<sup>1</sup></td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e318 "> </td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e320 "> </td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e322 "> </td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e324 "> </td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e326 "> </td>
</tr>
<tr><td align="left" valign="top" width="16.666666666666664%" headers="d0e316 ">*EXCLRD<sup>2</sup></td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e318 "> </td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e320 "> </td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e322 "> </td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e324 "> </td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e326 ">X</td>
</tr>
<tr><td align="left" valign="top" width="16.666666666666664%" headers="d0e316 ">*SHRUPD<sup>3</sup></td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e318 "> </td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e320 "> </td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e322 ">X</td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e324 "> </td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e326 ">X</td>
</tr>
<tr><td align="left" valign="top" width="16.666666666666664%" headers="d0e316 ">*SHRNUPD<sup>4</sup></td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e318 "> </td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e320 "> </td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e322 "> </td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e324 ">X</td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e326 ">X</td>
</tr>
<tr><td align="left" valign="top" width="16.666666666666664%" headers="d0e316 ">*SHRRD<sup>5</sup></td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e318 "> </td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e320 ">X</td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e322 ">X</td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e324 ">X</td>
<td align="center" valign="top" width="16.666666666666664%" headers="d0e326 ">X</td>
</tr>
<tr><td colspan="6" align="left" valign="top" headers="d0e316 d0e318 d0e320 d0e322 d0e324 d0e326 "><p><sup>1</sup> Exclusive
lock (*EXCL). The object is allocated for the exclusive use of the requesting
job; no other job can use the object.</p>
<p><sup>2</sup> Exclusive lock, allow
read (*EXCLRD). The object is allocated to the job that requested it, but
other jobs can read the object.</p>
<p><sup>3</sup> Shared lock, allow read
and update (*SHRUPD). The object can be shared either for read or change with
other jobs.</p>
<p><sup>4</sup> Shared lock, read only (*SHRNUPD). The object
can be shared for read with other jobs.</p>
<p><sup>5</sup> Shared lock (*SHRRD).
The object can be shared with another job if the job does not request exclusive
use of the object.</p>
</td>
</tr>
</tbody>
</table>
</td></tr></table>
<div class="section"><p><a href="#rbafoapplck__rbafocstlck">Table 2</a> shows database locking
for constraints of a database file, depending on whether the constraint is
associated with the parent file (PAR) or the dependent file (DEP).</p>
</div>
<div class="tablenoborder"><a name="rbafoapplck__rbafocstlck"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="rbafoapplck__rbafocstlck" width="100%" frame="void" border="0" rules="none"><caption>Table 2. Database constraint
locks. The numbers in parentheses refer to the notes at the end
of the table.</caption><thead align="left"><tr><th align="left" valign="bottom" width="22.62210796915167%" id="d0e445">Type of function</th>
<th align="left" valign="bottom" width="22.87917737789203%" id="d0e447">File type</th>
<th align="left" valign="bottom" width="13.624678663239074%" id="d0e449">File<sup>5</sup> </th>
<th align="left" valign="bottom" width="13.881748071979436%" id="d0e454">Member<sup>5</sup> </th>
<th align="left" valign="bottom" width="13.624678663239074%" id="d0e459">Other file</th>
<th align="left" valign="bottom" width="13.367609254498714%" id="d0e461">Other member</th>
</tr>
</thead>
<tbody><tr><td align="left" valign="top" width="22.62210796915167%" headers="d0e445 ">ADDPFM<sup>1</sup> </td>
<td align="left" valign="top" width="22.87917737789203%" headers="d0e447 ">DEP</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e449 ">*EXCL</td>
<td align="left" valign="top" width="13.881748071979436%" headers="d0e454 ">*EXCL</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e459 ">*EXCL</td>
<td align="left" valign="top" width="13.367609254498714%" headers="d0e461 ">*EXCL</td>
</tr>
<tr><td align="left" valign="top" width="22.62210796915167%" headers="d0e445 ">ADDPFM<sup>1</sup> </td>
<td align="left" valign="top" width="22.87917737789203%" headers="d0e447 ">PAR</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e449 ">*EXCL</td>
<td align="left" valign="top" width="13.881748071979436%" headers="d0e454 ">*EXCL</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e459 ">*EXCL</td>
<td align="left" valign="top" width="13.367609254498714%" headers="d0e461 ">*EXCL</td>
</tr>
<tr><td align="left" valign="top" width="22.62210796915167%" headers="d0e445 ">ADDPFCST<sup>7</sup></td>
<td align="left" valign="top" width="22.87917737789203%" headers="d0e447 ">*REFCST</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e449 ">*EXCL</td>
<td align="left" valign="top" width="13.881748071979436%" headers="d0e454 ">*EXCL</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e459 ">*EXCL</td>
<td align="left" valign="top" width="13.367609254498714%" headers="d0e461 ">*EXCL</td>
</tr>
<tr><td align="left" valign="top" width="22.62210796915167%" headers="d0e445 ">ADDPFCST<sup>6</sup> </td>
<td align="left" valign="top" width="22.87917737789203%" headers="d0e447 ">*UNQCST *PRIKEY</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e449 ">*EXCL</td>
<td align="left" valign="top" width="13.881748071979436%" headers="d0e454 ">*EXCL</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e459 ">*EXCL</td>
<td align="left" valign="top" width="13.367609254498714%" headers="d0e461 ">*EXCL</td>
</tr>
<tr><td align="left" valign="top" width="22.62210796915167%" headers="d0e445 ">ADDPFCST</td>
<td align="left" valign="top" width="22.87917737789203%" headers="d0e447 ">*UNIQUE *PRIKEY</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e449 ">*EXCL</td>
<td align="left" valign="top" width="13.881748071979436%" headers="d0e454 ">*EXCL</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e459 ">&nbsp;</td>
<td align="left" valign="top" width="13.367609254498714%" headers="d0e461 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="22.62210796915167%" headers="d0e445 ">RMVM<sup>2</sup></td>
<td align="left" valign="top" width="22.87917737789203%" headers="d0e447 ">DEP</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e449 ">*EXCL</td>
<td align="left" valign="top" width="13.881748071979436%" headers="d0e454 ">*EXCL</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e459 ">*EXCL</td>
<td align="left" valign="top" width="13.367609254498714%" headers="d0e461 ">*EXCL</td>
</tr>
<tr><td align="left" valign="top" width="22.62210796915167%" headers="d0e445 ">RMVM<sup>2</sup></td>
<td align="left" valign="top" width="22.87917737789203%" headers="d0e447 ">PAR</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e449 ">*EXCL</td>
<td align="left" valign="top" width="13.881748071979436%" headers="d0e454 ">*EXCL</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e459 ">*EXCL</td>
<td align="left" valign="top" width="13.367609254498714%" headers="d0e461 ">*EXCL</td>
</tr>
<tr><td align="left" valign="top" width="22.62210796915167%" headers="d0e445 ">DLTF<sup>3</sup></td>
<td align="left" valign="top" width="22.87917737789203%" headers="d0e447 ">DEP</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e449 ">*EXCL</td>
<td align="left" valign="top" width="13.881748071979436%" headers="d0e454 ">*EXCL</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e459 ">*EXCL</td>
<td align="left" valign="top" width="13.367609254498714%" headers="d0e461 ">*EXCL</td>
</tr>
<tr><td align="left" valign="top" width="22.62210796915167%" headers="d0e445 ">DLTF<sup>3</sup></td>
<td align="left" valign="top" width="22.87917737789203%" headers="d0e447 ">PAR</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e449 ">*EXCL</td>
<td align="left" valign="top" width="13.881748071979436%" headers="d0e454 ">*EXCL</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e459 ">*EXCL</td>
<td align="left" valign="top" width="13.367609254498714%" headers="d0e461 ">*EXCL</td>
</tr>
<tr><td align="left" valign="top" width="22.62210796915167%" headers="d0e445 ">RMVPFCST<sup>7</sup></td>
<td align="left" valign="top" width="22.87917737789203%" headers="d0e447 ">*REFCST</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e449 ">*EXCL</td>
<td align="left" valign="top" width="13.881748071979436%" headers="d0e454 ">*EXCL</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e459 ">*EXCL<sup>4</sup></td>
<td align="left" valign="top" width="13.367609254498714%" headers="d0e461 ">*EXCL</td>
</tr>
<tr><td align="left" valign="top" width="22.62210796915167%" headers="d0e445 ">RMVPFCST<sup>6</sup></td>
<td align="left" valign="top" width="22.87917737789203%" headers="d0e447 ">*UNQCST *PRIKEY</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e449 ">*EXCL</td>
<td align="left" valign="top" width="13.881748071979436%" headers="d0e454 ">*EXCL</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e459 ">*EXCL</td>
<td align="left" valign="top" width="13.367609254498714%" headers="d0e461 ">*EXCL</td>
</tr>
<tr><td align="left" valign="top" width="22.62210796915167%" headers="d0e445 ">RMVPFCST</td>
<td align="left" valign="top" width="22.87917737789203%" headers="d0e447 ">*UNIQUE *PRIKEY</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e449 ">*EXCL</td>
<td align="left" valign="top" width="13.881748071979436%" headers="d0e454 ">*EXCL</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e459 ">&nbsp;</td>
<td align="left" valign="top" width="13.367609254498714%" headers="d0e461 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="22.62210796915167%" headers="d0e445 ">CHGPFCST</td>
<td align="left" valign="top" width="22.87917737789203%" headers="d0e447 ">&nbsp;</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e449 ">*EXCL</td>
<td align="left" valign="top" width="13.881748071979436%" headers="d0e454 ">*EXCL</td>
<td align="left" valign="top" width="13.624678663239074%" headers="d0e459 ">*SHRRD</td>
<td align="left" valign="top" width="13.367609254498714%" headers="d0e461 ">*EXCL</td>
</tr>
<tr><td colspan="6" align="left" valign="top" headers="d0e445 d0e447 d0e449 d0e454 d0e459 d0e461 "><p><sup>1</sup> If
adding a physical file member causes a referential constraint to be established.</p>
<p><sup>2</sup> If
removing a physical file member causes an established referential constraint
to become defined.</p>
<p><sup>3</sup> When deleting a dependent or parent
file that has constraints established or defined for the file.</p>
<p><sup>4</sup> When
the Remove Physical File Constraint (RMVPFCST) command is invoked for the
parent file which has constraints established or defined, the parent and any
logical files over the parent file are all locked *EXCL.</p>
<p><sup>5</sup> For
referential constraints, the column refers to the dependent file or the dependent
member.</p>
<p><sup>6</sup> Unique constraint or primary key constraint is
a parent key in a referential constraint where the other file is a dependent
file.</p>
<p><sup>7</sup> The other file is a parent file.</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafoconcc.htm" title="By definition, all database files can be used by many users at the same time. However, some operations can lock the file, member, or data records in a member to prevent them from being shared across jobs.">Lock shared data</a></div>
</div>
</div>
</body>
</html>
Reference in New Issue Copy Permalink