102 lines
10 KiB
HTML
102 lines
10 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="CL commands: Affect only local pieces of a distributed file with DB2 Multisystem" />
|
|
<meta name="abstract" content="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)." />
|
|
<meta name="description" content="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)." />
|
|
<meta name="DC.subject" content="command, CL, list of, commands that only affect local pieces of distributed files, restrictions, CL commands that only affect local pieces of distributed files, APYJRNCHG (Apply Journaled Changes) command, affects local file pieces only, Apply Journaled Changes (APYJRNCHG) command, affects local file pieces only, APYJRNCHG (Apply Journaled Changes), Apply Journaled Changes (APYJRNCHG), DSPOBJD (Display Object Description) command, affects local file pieces only, Display Object Description (DSPOBJD) command, DSPOBJD (Display Object Description), Display Object Description (DSPOBJD), DMPOBJ (Dump Object) command, affects local file pieces only, Dump Object (DMPOBJ) command, DMPOBJ (Dump Object), Dump Object (DMPOBJ), ENDJRNAP (End Journal Access Path) command, End Journal Access Path (ENDJRNAP) command, ENDJRNAP (End Journal Access Path), End Journal Access Path (ENDJRNAP), RMVJRNCHG (Remove Journaled Changes) command, Remove Journaled Changes (RMVJRNCHG) command, RMVJRNCHG (Remove Journaled Changes), Remove Journaled Changes (RMVJRNCHG), RSTOBJ (Restore Object) command, Restore Object (RSTOBJ) command, RSTOBJ (Restore Object), Restore Object (RSTOBJ), SAVOBJ (Save Object) command, Save Object (SAVOBJ) command, SAVOBJ (Save Object), Save Object (SAVOBJ), STRJRNAP (Start Journal Access Path) command, Start Journal Access Path (STRJRNAP) command, STRJRNAP (Start Journal Access Path), Start Journal Access Path (STRJRNAP), DSPFD (Display File Description) command, Display File Description (DSPFD) command, DSPFD (Display File Description), Display File Description (DSPFD), node group, displaying, information about, DSPPFM (Display Physical File Member) command, Display Physical File Member (DSPPFM) command, DSPPFM (Display Physical File Member), Display Physical File Member (DSPPFM), distributed file, local records, remote data, local record, remote data, FROMRCD (from record) parameter, from record (FROMRCD) parameter" />
|
|
<meta name="keywords" content="command, CL, list of, commands that only affect local pieces of distributed files, restrictions, CL commands that only affect local pieces of distributed files, APYJRNCHG (Apply Journaled Changes) command, affects local file pieces only, Apply Journaled Changes (APYJRNCHG) command, affects local file pieces only, APYJRNCHG (Apply Journaled Changes), Apply Journaled Changes (APYJRNCHG), DSPOBJD (Display Object Description) command, affects local file pieces only, Display Object Description (DSPOBJD) command, DSPOBJD (Display Object Description), Display Object Description (DSPOBJD), DMPOBJ (Dump Object) command, affects local file pieces only, Dump Object (DMPOBJ) command, DMPOBJ (Dump Object), Dump Object (DMPOBJ), ENDJRNAP (End Journal Access Path) command, End Journal Access Path (ENDJRNAP) command, ENDJRNAP (End Journal Access Path), End Journal Access Path (ENDJRNAP), RMVJRNCHG (Remove Journaled Changes) command, Remove Journaled Changes (RMVJRNCHG) command, RMVJRNCHG (Remove Journaled Changes), Remove Journaled Changes (RMVJRNCHG), RSTOBJ (Restore Object) command, Restore Object (RSTOBJ) command, RSTOBJ (Restore Object), Restore Object (RSTOBJ), SAVOBJ (Save Object) command, Save Object (SAVOBJ) command, SAVOBJ (Save Object), Save Object (SAVOBJ), STRJRNAP (Start Journal Access Path) command, Start Journal Access Path (STRJRNAP) command, STRJRNAP (Start Journal Access Path), Start Journal Access Path (STRJRNAP), DSPFD (Display File Description) command, Display File Description (DSPFD) command, DSPFD (Display File Description), Display File Description (DSPFD), node group, displaying, information about, DSPPFM (Display Physical File Member) command, Display Physical File Member (DSPPFM) command, DSPPFM (Display Physical File Member), Display Physical File Member (DSPPFM), distributed file, local records, remote data, local record, remote data, FROMRCD (from record) parameter, from record (FROMRCD) parameter" />
|
|
<meta name="DC.Relation" scheme="URI" content="clwork.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="usedisfile.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="jourc.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="cldf.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="cllp" />
|
|
<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>CL commands: Affect only local pieces of a distributed
|
|
file with DB2 Multisystem</title>
|
|
</head>
|
|
<body id="cllp"><a name="cllp"><!-- --></a>
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|
<h1 class="topictitle1">CL commands: Affect only local pieces of a distributed
|
|
file with DB2 Multisystem</h1>
|
|
<div><p>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).</p>
|
|
<p>These CL commands are:</p>
|
|
<ul><li>Apply Journaled Changes (APYJRNCHG). See Journaling considerations with DB2<sup>®</sup> Multisystem
|
|
for additional information about this command.</li>
|
|
<li>Display Object Description (DSPOBJD)</li>
|
|
<li>Dump Object (DMPOBJ)</li>
|
|
<li>End Journal Access Path (ENDJRNAP)</li>
|
|
<li>Remove Journaled Changes (RMVJRNCHG). See Journaling considerations with DB2 Multisystem
|
|
for additional information about this command.</li>
|
|
<li>Restore Object (RSTOBJ)</li>
|
|
<li>Save Object (SAVOBJ)</li>
|
|
<li>Start Journal Access Path (STRJRNAP)</li>
|
|
</ul>
|
|
<p>You can use the Submit Remote Command (SBMRMTCMD) command to issue any
|
|
CL command to all of the remote systems associated with a distributed file.
|
|
By issuing a CL command on the local system and then issuing the same command
|
|
through the SBMRMTCMD command for a distributed file, you can run a CL command
|
|
on all the systems of a distributed file. You do not need to do this for CL
|
|
commands that automatically run on all of the pieces of a distributed file.
|
|
See CL commands: Affecting all the pieces of a distributed file with DB2 Multisystem
|
|
for more information.</p>
|
|
<p>The Display File Description (DSPFD) command can be used to display node
|
|
group information for distributed files. The DSPFD command shows you the name
|
|
of the node group, the fields in the partitioning key, and a full description
|
|
of the node group. To display this information, you must specify *ALL or *NODGRP
|
|
for the TYPE parameter on the DSPFD command.</p>
|
|
<p>The Display Physical File Member (DSPPFM) command can be used to display
|
|
the local records of a distributed file; however, if you want to display remote
|
|
data as well as local data, you should specify *ALLDATA on the from record
|
|
(FROMRCD) parameter on the command.</p>
|
|
<p>When using the Save Object (SAVOBJ) command or the Restore Object (RSTOBJ)
|
|
command for distributed files, each piece of the distributed file must be
|
|
saved and restored individually. A piece of the file can only be restored
|
|
back to the system from which it was saved if it is to be maintained as part
|
|
of the distributed file. If necessary, the Allocate Object (ALLOBJ) command
|
|
can be used to obtain a lock on all of the pieces of the file to prevent any
|
|
updates from being made to the file during the save process.</p>
|
|
<p>The system automatically distributes any logical file when the file is
|
|
restored if the following conditions are true:</p>
|
|
<ul><li>The logical file was saved as a nondistributed file.</li>
|
|
<li>The logical file is restored to the system when its based-on files are
|
|
distributed.</li>
|
|
</ul>
|
|
<p>The saved pieces of the file also can be used to create a local file. To
|
|
do this, you must restore the piece of the file either to a different library
|
|
or to a system that was not in the node group used when the distributed file
|
|
was created. To get all the records in the distributed file into a local file,
|
|
you must restore each piece of the file to the same system and then copy the
|
|
records into one aggregate file. Use the Copy File (CPYF) command to copy
|
|
the records to the aggregate file.</p>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <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 class="relconcepts"><strong>Related concepts</strong><br />
|
|
<div><a href="usedisfile.htm" title="As soon as the file is created, the system ensures that the data is partitioned and that the files remain at concurrent levels.">System activities after the distributed file is created</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="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>
|
|
</div>
|
|
</body>
|
|
</html> |