100 lines
6.2 KiB
HTML
100 lines
6.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="concept" />
|
||
|
|
<meta name="DC.Title" content="Process constraints that are in check pending status" />
|
||
|
|
<meta name="abstract" content="Constraints that are created for large database files might take a great deal of time to be validated by the system. You can list the constraints that are in check pending and schedule them for verification as required." />
|
||
|
|
<meta name="description" content="Constraints that are created for large database files might take a great deal of time to be validated by the system. You can list the constraints that are in check pending and schedule them for verification as required." />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbaforzahfcoj.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/edtcpcst.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="rbaforzahfcol" />
|
||
|
|
<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>Process constraints that are in check pending status</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbaforzahfcol"><a name="rbaforzahfcol"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Process constraints that are in check pending status</h1>
|
||
|
|
<div><p>Constraints that are created for large database files might take
|
||
|
|
a great deal of time to be validated by the system. You can list the constraints
|
||
|
|
that are in check pending and schedule them for verification as required.</p>
|
||
|
|
<div class="p">To display and edit the list of constraints that are in check pending status,
|
||
|
|
follow these steps:<ol><li>Run the Edit Check Pending Constraints (EDTCPCST) command.</li>
|
||
|
|
<li>Check the status of the constraint you want to process.</li>
|
||
|
|
<li>If the constraint is in a status other than RUN or READY, change the *HLD
|
||
|
|
value in the Seq field to a value between 1 and 99.</li>
|
||
|
|
<li>Press Enter.</li>
|
||
|
|
</ol>
|
||
|
|
</div>
|
||
|
|
<pre class="screen"> Edit Check Pending Constraints
|
||
|
|
|
||
|
|
Type sequence, press Enter.
|
||
|
|
Sequence: 1-99, *HLD
|
||
|
|
|
||
|
|
------------Constraints----------- Verify Elapsed
|
||
|
|
Seq Status Cst File Library Time Time
|
||
|
|
1 RUN EMP1 DEP EPPROD 00:01:00 00:00:50
|
||
|
|
1 READY CONST > DEP EPPROD 00:02:00 00:00:00
|
||
|
|
*HLD CHKPND FORTH > STYBAK EPPROD 00:03:00 00:00:00
|
||
|
|
*HLD CHKPND CST88 STYBAK EPPROD 00:10:00 00:00:00
|
||
|
|
*HLD CHKPND CS317 STYBAK EPPROD 00:20:00 00:00:00
|
||
|
|
*HLD CHKPND KSTAN STYBAK EPPROD 02:30:00 00:00:00
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
Bottom
|
||
|
|
F3=Exit F5=Refresh F12=Cancel F13=Repeat all F15=Sort by
|
||
|
|
F16=Repeat position to F17=Position to F22=Display constraint name
|
||
|
|
</pre>
|
||
|
|
<div class="section" id="rbaforzahfcol__rbaforzahfcom"><a name="rbaforzahfcol__rbaforzahfcom"><!-- --></a><h4 class="sectiontitle">Details: Process constraints that are in
|
||
|
|
check pending status</h4><p>Additional information about processing constraints
|
||
|
|
that are in check pending status includes the Status field of the Edit Check
|
||
|
|
Pending Constraints display, the Constraint and the Verify time columns.</p>
|
||
|
|
<div class="p">The
|
||
|
|
Status field of the Edit Check Pending Constraints display has one of the
|
||
|
|
following values: <ul><li><strong>RUN</strong> indicates that the constraint is being verified.</li>
|
||
|
|
<li><strong>READY</strong> indicates that the constraint is ready to be verified.</li>
|
||
|
|
<li><strong>NOTVLD</strong> indicates that the access path that is associated with the
|
||
|
|
constraint is not valid. After the access path has been rebuilt, the system
|
||
|
|
automatically verifies the constraint. This value applies only to a referential
|
||
|
|
constraint.</li>
|
||
|
|
<li><strong>HELD</strong> indicates that the constraint is not being verified. You must
|
||
|
|
change the sequence to a value from 1 to 99 to change this state.</li>
|
||
|
|
<li><strong>CHKPND</strong> indicates that the system attempted to verify the constraint,
|
||
|
|
but the constraint is still in check pending. You must change the sequence
|
||
|
|
to a value from 1 to 99 to change this state.</li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
<p>The Constraint column contains the first five characters of the
|
||
|
|
constraint name. A > symbol follows the name if it exceeds five characters.
|
||
|
|
You can display the whole long name, put the cursor on that line and press
|
||
|
|
the F22 key.</p>
|
||
|
|
<p>The Verify time column shows the time it would
|
||
|
|
take to verify the constraint if there were no other jobs on the system. The
|
||
|
|
elapsed time column indicates the time already spent on verifying the constraint.</p>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbaforzahfcoj.htm" title="When you add a referential or check constraint, the system automatically checks all the records in the database file to ensure that they meet the constraint definition. If the constraint is not valid or if it cannot be verified, the system places it in check pending status.">Work with constraints that are in check pending status</a></div>
|
||
|
|
</div>
|
||
|
|
<div class="relref"><strong>Related reference</strong><br />
|
||
|
|
<div><a href="../cl/edtcpcst.htm">Edit Check Pending Constraints (EDTCPCST) command</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|