121 lines
8.1 KiB
HTML
121 lines
8.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="concept" />
|
|
<meta name="DC.Title" content="System activities after the distributed file is created" />
|
|
<meta name="abstract" content="As soon as the file is created, the system ensures that the data is partitioned and that the files remain at concurrent levels." />
|
|
<meta name="description" content="As soon as the file is created, the system ensures that the data is partitioned and that the files remain at concurrent levels." />
|
|
<meta name="DC.subject" content="distributed file, introduction" />
|
|
<meta name="keywords" content="distributed file, introduction" />
|
|
<meta name="DC.Relation" scheme="URI" content="crtdf.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="clwork.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="cldf.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="jourc.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="cllp.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="clwork.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="usedisfile" />
|
|
<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>System activities after the distributed file is created</title>
|
|
</head>
|
|
<body id="usedisfile"><a name="usedisfile"><!-- --></a>
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|
<h1 class="topictitle1">System activities after the distributed file is created</h1>
|
|
<div><p>As soon as the file is created, the system ensures that the data
|
|
is partitioned and that the files remain at concurrent levels.</p>
|
|
<p>As soon as the file is created, the following activities
|
|
occur automatically:</p>
|
|
<ul><li>All indexes created for the file are created on all the nodes.</li>
|
|
<li>Authority chaninformation about using distributed files with DB2<sup>®</sup> Multisystemges
|
|
are sent to all nodes.</li>
|
|
<li>The system prevents the file from being moved and prevents its library
|
|
from being renamed.</li>
|
|
<li>If the file itself is renamed, its new name is reflected on all nodes.</li>
|
|
<li>Several commands, such as Allocate Object (ALCOBJ), Reorganize Physical
|
|
File Member (RGZPFM), and Start Journal Physical File (STRJRNPF), now affect
|
|
all of the pieces of the file. This allows you to maintain the concept of
|
|
a local file when working with partitioned files. See CL commands: Affecting
|
|
all the pieces of a distributed file with DB2 Multisystem for a complete list of these
|
|
CL commands. <p>You can issue the Allocate Object (ALCOBJ)
|
|
command from any of the nodes in the node group. This locks all the pieces
|
|
and ensures the same integrity that is granted when a local file is allocated.
|
|
All of these actions are handled by the system, which keeps you from having
|
|
to enter the commands on each node.</p>
|
|
<p>In the case of the Start Journal
|
|
Physical File (STRJRNPF) command, journaling is started on each system. Therefore,
|
|
each system must have its own journal and journal receiver. Each system has
|
|
its own journal entries; recovery using the journal entries must be done on
|
|
each system individually. The commands to start and end journaling affect
|
|
all of the systems in the node group simultaneously. See Journaling considerations
|
|
with DB2 Multisystem
|
|
for additional information.</p>
|
|
</li>
|
|
<li>Several commands, such as Dump Object (DMPOBJ), Save Object (SAVOBJ),
|
|
and Work with Object Locks (WRKOBJLCK), only affect the piece of the file
|
|
on the system where the command was issued. See CL Commands: Affecting only
|
|
local pieces of a distributed file with DB2 Multisystem for a complete list of these
|
|
CL commands.</li>
|
|
</ul>
|
|
<p>As soon as a file is created as a distributed file, the
|
|
opening of the file results in an opening of the local piece of the file as
|
|
well as connections being made to all of the remote systems. When the file
|
|
is created, it can be accessed from any of the systems in the node group.
|
|
The system also determines which nodes and records it needs to use to complete
|
|
the file I/O task (GETS, PUTs, and UPDATES, for example). You do not need
|
|
to physically influence or specify any of this activity.</p>
|
|
<p>Note that Distributed
|
|
Relational Database Architecture™ (DRDA<sup>®</sup>) and distributed data management (DDM)
|
|
requests can target distributed files. Previously distributed applications
|
|
that use DRDA or
|
|
DDM to access a database file on a remote system can continue to work even
|
|
if that database file was changed to be a distributed file.</p>
|
|
<p>You should be aware that the arrival sequence of the records is different
|
|
for distributed database files than that of a local database file.</p>
|
|
<p>Because distributed files are physically distributed across systems, you
|
|
cannot rely on the arrival sequence or relative record number of the records.
|
|
With a local database file, the records are dealt with in order. If, for example,
|
|
you are inserting data into a local database file, the data is inserted starting
|
|
with the first record and continuing through the last record. All records
|
|
are inserted in sequential order. Records on an individual node are inserted
|
|
the same way that records are inserted for a local file.</p>
|
|
<p>When data is read from a local database file, the data
|
|
is read from the first record on through the last record. This is not true
|
|
for a distributed database file. With a distributed database file, the data
|
|
is read from the records (first to last record) in the first node, then the
|
|
second node, and so on. For example, reading to record 27 no longer means
|
|
that you read to a single record. With a distributed file, each node in the
|
|
node group can contain its own record 27, none of which is the same.</p>
|
|
</div>
|
|
<div>
|
|
<ul class="ullinks">
|
|
<li class="ulchildlink"><strong><a href="clwork.htm">How CL commands work with distributed files</a></strong><br />
|
|
This topic addresses issuing CL commands against distributed files
|
|
with DB2 Multisystem.</li>
|
|
</ul>
|
|
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="crtdf.htm" title="A distributed file is a database file that is spread across multiple iSeries servers.">Distributed files with DB2 Multisystem</a></div>
|
|
</div>
|
|
<div class="relconcepts"><strong>Related concepts</strong><br />
|
|
<div><a href="cldf.htm" title="Some CL commands, when run, affect all the pieces of the distributed file.">CL commands: Affect all the pieces of a distributed file with DB2 Multisystem</a></div>
|
|
<div><a href="jourc.htm" title="Although the Start Journal Physical File (STRJRNPF) and End Journal Physical File (ENDJRNPF) commands are distributed to other systems, the actual journaling takes place on each system independently and to each system's own journal receiver.">Journaling considerations with DB2 Multisystem</a></div>
|
|
<div><a href="cllp.htm" title="Some CL commands, when run, affect only the piece of the distributed file that is located on the local system (the system from which the command was run).">CL commands: Affect only local pieces of a distributed file with DB2 Multisystem</a></div>
|
|
<div><a href="clwork.htm" title="This topic addresses issuing CL commands against distributed files with DB2 Multisystem.">How CL commands work with distributed files</a></div>
|
|
</div>
|
|
</div>
|
|
</body>
|
|
</html> |