86 lines
6.6 KiB
HTML
86 lines
6.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="topic" />
|
||
|
|
<meta name="DC.Title" content="DB2 Multisystem" />
|
||
|
|
<meta name="abstract" content="This topic describes the fundamental concepts of DB2 Multisystem, such as distributed relational database files, node groups, and partitioning, and provides the information necessary to create and to use database files that are partitioned across multiple iSeries servers. Information is provided on how to configure the systems, how to create the files, and how the files can be used in applications. This topic also describes table partitioning. Table partitioning varies from multisystem partitioning in that it is a table partitioned on a single server." />
|
||
|
|
<meta name="description" content="This topic describes the fundamental concepts of DB2 Multisystem, such as distributed relational database files, node groups, and partitioning, and provides the information necessary to create and to use database files that are partitioned across multiple iSeries servers. Information is provided on how to configure the systems, how to create the files, and how the files can be used in applications. This topic also describes table partitioning. Table partitioning varies from multisystem partitioning in that it is a table partitioned on a single server." />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzaf3whatsnew.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="printthis.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="intro.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzaf3c2-gen4.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="crtdf.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="partitionedtables.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="RZAF3C4-gen5.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="RZAF3C5-gen6.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="qqp.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="related.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="rzaf3kickoff" />
|
||
|
|
<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>DB2 Multisystem</title>
|
||
|
|
</head>
|
||
|
|
<body id="rzaf3kickoff"><a name="rzaf3kickoff"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">DB2 Multisystem</h1>
|
||
|
|
<div><p>This topic describes the fundamental concepts of DB2<sup>®</sup> Multisystem,
|
||
|
|
such as distributed relational database files, node groups, and partitioning,
|
||
|
|
and provides the information necessary to create and to use database files
|
||
|
|
that are partitioned across multiple <span class="keyword">iSeries™</span> servers.
|
||
|
|
Information is provided on how to configure the systems, how to create the
|
||
|
|
files, and how the files can be used in applications. This topic also describes
|
||
|
|
table partitioning. Table partitioning varies from multisystem partitioning
|
||
|
|
in that it is a table partitioned on a single server.</p>
|
||
|
|
<div class="note"><span class="notetitle">Note:</span> By using the code examples, you agree to the terms of the <a href="codedisclaimer.htm">Code license and disclaimer information</a>.</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="rzaf3whatsnew.htm">What's new for V5R4</a></strong><br />
|
||
|
|
<span><img src="./delta.gif" alt="Start of change" />This topic highlights some changes to the DB2 Multisystem
|
||
|
|
for V5R4.<img src="./deltaend.gif" alt="End of change" /></span></li>
|
||
|
|
<li class="ulchildlink"><strong><a href="printthis.htm">Printable PDF</a></strong><br />
|
||
|
|
Use this to view and print a PDF of this information.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="intro.htm">DB2 Multisystem introduction</a></strong><br />
|
||
|
|
<span class="keyword">DB2 Multisystem</span> is a
|
||
|
|
parallel processing technique that provides greater scalability for databases.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzaf3c2-gen4.htm">Introduction of node groups with DB2 Multisystem</a></strong><br />
|
||
|
|
To enable database files to be visible across a set of <span class="keyword">iSeries</span> servers, you must first define
|
||
|
|
the group of systems (node group) that you want the files on.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="crtdf.htm">Distributed files with DB2 Multisystem</a></strong><br />
|
||
|
|
A <em>distributed file</em> is a database file that is spread across
|
||
|
|
multiple <span class="keyword">iSeries</span> servers.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="partitionedtables.htm">Partitioned tables</a></strong><br />
|
||
|
|
DB2 UDB
|
||
|
|
for iSeries supports
|
||
|
|
partitioned tables using SQL.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="RZAF3C4-gen5.htm">Scalar functions available with DB2 Multisystem</a></strong><br />
|
||
|
|
For DB2 Multisystem,
|
||
|
|
scalar functions are available when you work with distributed files.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="RZAF3C5-gen6.htm">Performance and scalability with DB2 Multisystem</a></strong><br />
|
||
|
|
<span class="keyword">DB2 Multisystem</span> can
|
||
|
|
help you increase your database capacity, realize improvements
|
||
|
|
in query performance, and provide remote database access through an easier
|
||
|
|
method.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="qqp.htm">Query design for performance with DB2 Multisystem</a></strong><br />
|
||
|
|
This topic provides you with some guidelines for designing queries so that they use query resources more efficiently when you run queries that use distributed files.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="related.htm">Related information for DB2 Multisystem</a></strong><br />
|
||
|
|
Listed here are the information center topics that relate to the DB2 Multisystem
|
||
|
|
topic. </li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|