78 lines
5.9 KiB
HTML
78 lines
5.9 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="DB2 Multisystem introduction" />
|
||
|
|
<meta name="abstract" content="DB2 Multisystem is a parallel processing technique that provides greater scalability for databases." />
|
||
|
|
<meta name="description" content="DB2 Multisystem is a parallel processing technique that provides greater scalability for databases." />
|
||
|
|
<meta name="DC.subject" content=", Multisystem, DB2, introduction to, shared nothing cluster, definition, shared nothing cluster, installing, figure, distribution of database files, database file, distributed across systems figure" />
|
||
|
|
<meta name="keywords" content=", Multisystem, DB2, introduction to, shared nothing cluster, definition, shared nothing cluster, installing, figure, distribution of database files, database file, distributed across systems figure" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzaf3kickoff.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="benefits.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="basicterms.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="intro" />
|
||
|
|
<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 introduction</title>
|
||
|
|
</head>
|
||
|
|
<body id="intro"><a name="intro"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1"><span class="keyword">DB2 Multisystem</span> introduction</h1>
|
||
|
|
<div><p><span class="keyword">DB2<sup>®</sup> Multisystem</span> is a
|
||
|
|
parallel processing technique that provides greater scalability for databases.</p>
|
||
|
|
<p>Using DB2 Multisystem, you have the capability to attach multiple <span class="keyword">iSeries™</span> servers (up to 32 servers) together
|
||
|
|
in a shared- nothing cluster. (<dfn class="term">Shared-nothing</dfn> means
|
||
|
|
that each system in the coupled network owns and manages its own main memory
|
||
|
|
and disk storage.) As soon as the systems are connected, database files can
|
||
|
|
be spread across the storage units on each connected system. The database
|
||
|
|
files can have data partitioned (distributed) across a set of systems, and
|
||
|
|
each system has access to all of the data in the file. Yet to users, the file
|
||
|
|
behaves like a local file on their system. From the user's perspective, the
|
||
|
|
database appears as a single database: the user can run queries in parallel
|
||
|
|
across all the systems in the network and have realtime access to the data
|
||
|
|
in the files.</p>
|
||
|
|
<div class="fignone"><span class="figcap">Figure 1. Distribution of database files across systems</span><br /><img src="rv3l111.gif" alt="Users in different locations can access data on several servers. Using DB2" /><br /></div>
|
||
|
|
<p>This parallel processing technique means that heavy usage on one server
|
||
|
|
does not degrade the performance on the other connected systems in the network.
|
||
|
|
If you have large volumes of data and the need to run queries, DB2 Multisystem
|
||
|
|
provides you with a method of running those queries in one of the most efficient
|
||
|
|
methods available. In most cases, query performance improves because the queries
|
||
|
|
no longer run against local files, but run in parallel across several servers.</p>
|
||
|
|
<p>If you have not yet installed DB2 Multisystem, see <a href="../rzahg/rzahgos400software.htm">Install, upgrade, or
|
||
|
|
delete i5/OS™ and
|
||
|
|
related software</a> for information about installing additional licensed
|
||
|
|
programs. To install DB2 Multisystem, use option 27 in the list of installable
|
||
|
|
options for the operating system.</p>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="benefits.htm">Benefits of using DB2 Multisystem</a></strong><br />
|
||
|
|
Benefits of using DB2 Multisystem include improved query performance, decreased
|
||
|
|
data replication, larger database capacity, and so on.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="basicterms.htm">DB2 Multisystem: Basic terms and concepts</a></strong><br />
|
||
|
|
A <em>distributed file</em> is a database file that is spread across
|
||
|
|
multiple <span class="keyword">iSeries</span> servers. This
|
||
|
|
section describes some of the main concepts that are used in discussing the
|
||
|
|
creation and use of distributed files by DB2 Multisystem.</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rzaf3kickoff.htm" title="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.">DB2 Multisystem</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|