62 lines
4.3 KiB
HTML
62 lines
4.3 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="Database distribution" />
|
|
<meta name="abstract" content="DB2 Multisystem, a separately priced feature, provides a simple and direct method of distributing a database file over multiple systems in a loosely-coupled environment." />
|
|
<meta name="description" content="DB2 Multisystem, a separately priced feature, provides a simple and direct method of distributing a database file over multiple systems in a loosely-coupled environment." />
|
|
<meta name="DC.subject" content="database distribution, distribution, database, Multisystem, Multisystem, DB2" />
|
|
<meta name="keywords" content="database distribution, distribution, database, Multisystem, Multisystem, DB2" />
|
|
<meta name="DC.Relation" scheme="URI" content="rbafomanage.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="../dbmult/rzaf3kickoff.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="rbafomulsys" />
|
|
<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 distribution</title>
|
|
</head>
|
|
<body id="rbafomulsys"><a name="rbafomulsys"><!-- --></a>
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|
<h1 class="topictitle1">Database distribution</h1>
|
|
<div><p><span class="keyword">DB2<sup>®</sup> Multisystem</span>, a separately
|
|
priced feature, provides a simple and direct method of distributing a database
|
|
file over multiple systems in a loosely-coupled environment.</p>
|
|
<p><span class="keyword">DB2 Multisystem</span> allows users
|
|
on distributed <span class="keyword">iSeries™</span> systems
|
|
real-time query and update access to a distributed database as if it existed
|
|
totally on their particular system. <span class="keyword">DB2 Multisystem</span> places
|
|
new records on the appropriate system based on a user-defined key field or
|
|
fields. <span class="keyword">DB2 Multisystem</span> chooses
|
|
a system on the basis of either a system-supplied or user-defined hashing
|
|
algorithm.</p>
|
|
<p>Query performance is improved by a factor approaching the number of nodes
|
|
in the environment. For example, a query against a database distributed over
|
|
four systems runs in approximately one quarter of the time. However, performance
|
|
can vary greatly when queries involve joins and grouping. Performance is also
|
|
influenced by the balance of the data across the multiple nodes. Multisystem
|
|
runs the query on each system concurrently. <span class="keyword">DB2 Multisystem</span> can
|
|
significantly reduce query time on very large databases. </p>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafomanage.htm" title="These topics discuss how to maintain control of database files on your system by managing the files, their descriptions and attributes. Information about how to maintain control over your data to protect it from loss, how to ensure data integrity with constraints, and how to set up trigger events when the data changes is included.">Manage database files</a></div>
|
|
</div>
|
|
<div class="relconcepts"><strong>Related concepts</strong><br />
|
|
<div><a href="../dbmult/rzaf3kickoff.htm">DB2 Multisystem</a></div>
|
|
</div>
|
|
</div>
|
|
</body>
|
|
</html> |