61 lines
4.6 KiB
HTML
61 lines
4.6 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="Distributed unit of work" />
|
||
|
|
<meta name="abstract" content="Distributed unit of work (DUW) enables a user or application program to read or update data at multiple locations within a unit of work. Within one unit of work, an application running on one system can direct SQL requests to multiple remote database management systems using the SQL supported by those systems." />
|
||
|
|
<meta name="description" content="Distributed unit of work (DUW) enables a user or application program to read or update data at multiple locations within a unit of work. Within one unit of work, an application running on one system can direct SQL requests to multiple remote database management systems using the SQL supported by those systems." />
|
||
|
|
<meta name="DC.subject" content="DRDA (Distributed Relational Database Architecture) Level 2 support, distributed unit of work (DUW), definition, DUW (distributed unit of work)" />
|
||
|
|
<meta name="keywords" content="DRDA (Distributed Relational Database Architecture) Level 2 support, distributed unit of work (DUW), definition, DUW (distributed unit of work)" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1drdbp.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="rbal1duw" />
|
||
|
|
<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>Distributed unit of work</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbal1duw"><a name="rbal1duw"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Distributed unit of work</h1>
|
||
|
|
<div><p><dfn class="term">Distributed unit of work</dfn> (DUW) enables a user or application
|
||
|
|
program to read or update data at multiple locations within a unit of work.
|
||
|
|
Within one unit of work, an application running on one system can direct SQL
|
||
|
|
requests to multiple remote database management systems using the SQL supported
|
||
|
|
by those systems.</p>
|
||
|
|
<p>For example, the shop inventory program can perform updates to the inventory
|
||
|
|
table on one system and the accounts receivable table on another system within
|
||
|
|
one unit of work. The following figure illustrates this idea.</p>
|
||
|
|
<div class="fignone" id="rbal1duw__rbal1dunit"><a name="rbal1duw__rbal1dunit"><!-- --></a><span class="figcap">Figure 1. Distributed unit of work in a distributed
|
||
|
|
relational database</span><br /><img src="rbal1504.gif" alt="Distributed unit of work in a distributed relational database" /><br /></div>
|
||
|
|
<p>The target of the requests is controlled by the user or application with
|
||
|
|
SQL statements such as CONNECT TO and SET CONNECTION. Each SQL statement must
|
||
|
|
refer to data at a single location.</p>
|
||
|
|
<p>When the application is ready to commit the work, it initiates the commit;
|
||
|
|
commitment coordination is performed by a synchronization-point manager or
|
||
|
|
a transaction manager.</p>
|
||
|
|
<p>DUW allows update access or read-only access to multiple
|
||
|
|
database management systems in one unit of work.</p>
|
||
|
|
<p>Whether an application can update a given database management system in
|
||
|
|
a unit of work is dependent on the level of DRDA<sup>®</sup> (if DRDA is used to access the remote relational
|
||
|
|
database) and the order in which the connections and updates are made.</p>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbal1drdbp.htm" title="A relational database is a set of data stored in one or more tables in a computer.">Distributed relational database processing</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|