ibm-information-center/dist/eclipse/plugins/i5OS.ic.dbp_5.4.0.1/rbafoprecmt.htm

63 lines
5.5 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="concept" />
<meta name="DC.Title" content="Protect your file with journaling and commitment control" />
<meta name="abstract" content="Journaling and commitment control are the preferred methods for data and transaction recovery on the iSeries system. You can use the COMMIT parameter to protect your file with journaling and commitment control." />
<meta name="description" content="Journaling and commitment control are the preferred methods for data and transaction recovery on the iSeries system. You can use the COMMIT parameter to protect your file with journaling and commitment control." />
<meta name="DC.subject" content="protecting, file, journaling, commitment control, database file, physical file, starting, start journaling, journaling physical file, COMMIT parameter, parameter, COMMIT, Start Journal Physical File (STRJRNPF) command, STRJRNPF (Start Journal Physical File) command, command, CL, STRJRNPF (Start Journal Physical File), Start Journal Physical File (STRJRNPF)" />
<meta name="keywords" content="protecting, file, journaling, commitment control, database file, physical file, starting, start journaling, journaling physical file, COMMIT parameter, parameter, COMMIT, Start Journal Physical File (STRJRNPF) command, STRJRNPF (Start Journal Physical File) command, command, CL, STRJRNPF (Start Journal Physical File), Start Journal Physical File (STRJRNPF)" />
<meta name="DC.Relation" scheme="URI" content="rbafoprercv.htm" />
<meta name="DC.Relation" scheme="URI" content="rbaforzahfpre.htm" />
<meta name="DC.Relation" scheme="URI" content="rbaforzahfprg.htm" />
<meta name="DC.Relation" scheme="URI" content="rbaforzahfrca.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="rbafoprecmt" />
<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>Protect your file with journaling and commitment control</title>
</head>
<body id="rbafoprecmt"><a name="rbafoprecmt"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">Protect your file with journaling and commitment control</h1>
<div><p>Journaling and commitment control are the preferred methods for
data and transaction recovery on the <span class="keyword">iSeries™</span> system.
You can use the COMMIT parameter to protect your file with journaling and
commitment control.</p>
<p>Database file journaling is started by running the Start Journal Physical
File (STRJRNPF) command for the file. Access path journaling is started by
running the Start Journal Access Path (STRJRNAP) command for the file or by
using System-Managed Access-Path Protection (SMAPP). You tell the system that
you want your files to run under commitment control through the Start Commitment
Control (STRCMTCTL) command and through high-level language specifications.
You can also specify the commitment control (COMMIT) parameter on the Open
Database File (OPNDBF) and Open Query File (OPNQRYF) commands. </p>
<p>If you are performing insert, update, or delete operations on a file that
is associated with a referential constraint and the delete rule, update rule,
or both are other than RESTRICT, you must use journaling. </p>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafoprercv.htm" title="These topics include the data integrity runtime considerations for more efficient file processing.">Data recovery and integrity</a></div>
</div>
<div class="relconcepts"><strong>Related concepts</strong><br />
<div><a href="rbaforzahfpre.htm" title="Journal management allows you to record all the data changes that occur to one or more database files. You can then use the journal for recovery.">Manage journals</a></div>
<div><a href="rbaforzahfprg.htm" title="Commitment control lets you define and process a number of changes to database files in a single unit (transaction). It can ensure that complex application transactions are logically synchronized, even if the job or system ends. Two-phase commitment control ensures that committable resources, such as database files on multiple systems, remain synchronized.">Ensure data integrity with commitment control</a></div>
<div><a href="rbaforzahfrca.htm" title="These topics discuss how to use referential constraints in your database to ensure that it contains only valid data.">Ensure data integrity with referential constraints</a></div>
</div>
</div>
</body>
</html>