61 lines
4.1 KiB
HTML
61 lines
4.1 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="reference" />
|
|
<meta name="DC.Title" content="Do iSeries files have to be journaled?" />
|
|
<meta name="abstract" content="Journaling is not required if the client application is using an isolation level of no-commit (NC) or uncommitted read (UR), and if the DB2 UDB SQL function determines that the query data can be blocked. In that case commitment control is not enabled, which makes journaling unnecessary." />
|
|
<meta name="description" content="Journaling is not required if the client application is using an isolation level of no-commit (NC) or uncommitted read (UR), and if the DB2 UDB SQL function determines that the query data can be blocked. In that case commitment control is not enabled, which makes journaling unnecessary." />
|
|
<meta name="DC.subject" content="files, iSeries, journaling, files" />
|
|
<meta name="keywords" content="files, iSeries, journaling, files" />
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1xplat.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="rbal1faqjournal" />
|
|
<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>Do iSeries files have
|
|
to be journaled?</title>
|
|
</head>
|
|
<body id="rbal1faqjournal"><a name="rbal1faqjournal"><!-- --></a>
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|
<h1 class="topictitle1">Do <span class="keyword">iSeries™</span> files have
|
|
to be journaled?</h1>
|
|
<div><p>Journaling is not required if the client application is using an
|
|
isolation level of no-commit (NC) or uncommitted read (UR), and if the <span class="keyword">DB2<sup>®</sup> UDB SQL</span> function determines that the
|
|
query data can be blocked. In that case commitment control is not enabled,
|
|
which makes journaling unnecessary.</p>
|
|
<div class="section"><p>The answer to this question is closely related to the question
|
|
in <a href="rbal1ques2.htm#rbal1ques2">When will query data be blocked for better performance?</a>. </p>
|
|
</div>
|
|
<div class="section"><p>Examples of methods of changing isolation levels are: </p>
|
|
<ul><li>The <span>DB2 Universal Database™ for Linux<sup>®</sup>, UNIX<sup>®</sup> and Windows<sup>®</sup></span> precompiler
|
|
uses the ISOLATION UR parameter to specify uncommitted read.</li>
|
|
<li>The <span>DB2 Universal Database for Linux, UNIX and Windows</span> command
|
|
line processor (CLP) uses the command DBM CHANGE SQLISL TO UR to specify uncommitted
|
|
read.</li>
|
|
<li>The <span>DB2 Universal Database for Linux, UNIX and Windows</span> command
|
|
line processor (CLP) uses the command DBM CHANGE SQLISL TO NC to specify no-commit.</li>
|
|
<li>JDBC clients set their connection property isolation level to TRANSACTION_READ_UNCOMMITTED
|
|
to specify uncommitted read.</li>
|
|
</ul>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbal1xplat.htm" title="This topic collection concentrates on describing iSeries support for distributed relational databases in a network of iSeries servers (a like environment).">User FAQs</a></div>
|
|
</div>
|
|
</div>
|
|
</body>
|
|
</html> |