133 lines
8.8 KiB
HTML
133 lines
8.8 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="task" />
|
||
|
|
<meta name="DC.Title" content="Move data between iSeries servers using copy file commands" />
|
||
|
|
<meta name="abstract" content="Another way to move data from one iSeries server to another is to copy the data using the copy file commands with DDM." />
|
||
|
|
<meta name="description" content="Another way to move data from one iSeries server to another is to copy the data using the copy file commands with DDM." />
|
||
|
|
<meta name="DC.subject" content="moving data, using copy file commands, copying files with DDM, distributed data management (DDM), moving data between, server, iSeries, DDM (distributed data management)" />
|
||
|
|
<meta name="keywords" content="moving data, using copy file commands, copying files with DDM, distributed data management (DDM), moving data between, server, iSeries, DDM (distributed data management)" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1mvdat.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/cpyf.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/cpysrcf.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/cpyfrmqryf.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/cpyfrmtap.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/cpytotap.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/crtpf.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/crtddmf.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../ddm/rbae5kickoff.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/ovrdbf.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/sbmrmtcmd.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="rbal1cpfddm" />
|
||
|
|
<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>Move data between iSeries servers
|
||
|
|
using copy file commands</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbal1cpfddm"><a name="rbal1cpfddm"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Move data between <span class="keyword">iSeries server</span>s
|
||
|
|
using copy file commands</h1>
|
||
|
|
<div><p>Another way to move data from one <span class="keyword">iSeries™ server</span> to
|
||
|
|
another is to copy the data using the copy file commands with DDM.</p>
|
||
|
|
<div class="section"> <p>You can use the <span class="cmdname">Copy File (CPYF)</span>, <span class="cmdname">Copy
|
||
|
|
Source File (CPYSRCF)</span>, and <span class="cmdname">Copy From Query File (CPYFRMQRYF)</span> commands
|
||
|
|
to copy data between files on source and application servers (ASs). You can
|
||
|
|
copy local relational database or device files from (or to) remote database
|
||
|
|
files, and remote files can also be copied to remote files.</p>
|
||
|
|
<p>For example,
|
||
|
|
if a dealership closes, the distributed relational database administrator
|
||
|
|
can copy the client and inventory tables from the remote server to the local
|
||
|
|
regional server. The administrator needs a properly authorized user profile
|
||
|
|
on the application server (AS) to access and copy the tables and must create
|
||
|
|
a DDM file on the application requester (AR) for each table or file that is
|
||
|
|
copied. The following example shows the command the database administrator
|
||
|
|
would use to copy a table called INVENT in a collection called SPIFFY from
|
||
|
|
a server with a remote location name of KC105 to a regional center server
|
||
|
|
called KC000. A DDM file called INCOPY in a library called TEST on the application
|
||
|
|
requester (AR) KC000 is used for the file access. These commands are run on
|
||
|
|
the KC000 server: </p>
|
||
|
|
<pre>CRTDDMF FILE(TEST/INCOPY) RMTFILE(SPIFFY/INVENT)
|
||
|
|
RMTLOCNAME(KC105)
|
||
|
|
CPYF FROMFILE(TEST/INCOPY) TOFILE(TEST/INVENTDDM)
|
||
|
|
MBROPT(*ADD)</pre>
|
||
|
|
<p>In this example, the administrator runs the
|
||
|
|
commands on the KC000 server. If the administrator is not on the KC000 server,
|
||
|
|
then pass-through must be used to run these commands on the KC000 server.
|
||
|
|
The <span class="cmdname">Submit Remote Command (SBMRMTCMD)</span> command cannot be
|
||
|
|
used to run the above commands because the <span class="keyword">iSeries server</span> cannot
|
||
|
|
be an application requester (AR) and an application server (AS) for the same
|
||
|
|
job.</p>
|
||
|
|
<p>Consider the following items when using this command with DDM:
|
||
|
|
</p>
|
||
|
|
<ul><li>A DDM file can be specified on the FROMFILE and the TOFILE parameters
|
||
|
|
for the <span class="cmdname">Copy File (CPYF)</span> command and <span class="cmdname">Copy Source
|
||
|
|
File (CPYSRCF)</span> commands. <div class="note"><span class="notetitle">Note:</span> For the <span class="cmdname">Copy From Query
|
||
|
|
File (CPYFRMQRYF)</span> and <span class="cmdname">Copy from Tape (CPYFRMTAP)</span> commands,
|
||
|
|
a DDM file name can be specified only on the TOFILE parameter; for the <span class="cmdname">Copy
|
||
|
|
to Tape (CPYTOTAP)</span> command, a DDM file name can be specified only
|
||
|
|
on the FROMFILE parameter.</div>
|
||
|
|
</li>
|
||
|
|
<li>When a delete-capable file is copied to a non-delete capable file, you
|
||
|
|
must specify COMPRESS(*YES), or an error message is sent and the job ends.</li>
|
||
|
|
<li>If the remote file name on a DDM file specifies a member name, the member
|
||
|
|
name specified for that file on the <span class="cmdname">Copy File (CPYF)</span> command
|
||
|
|
must be the same as the member name on the remote file name on the DDM file.
|
||
|
|
In addition, the <span class="cmdname">Override with Database File (OVRDBF)</span> command
|
||
|
|
cannot specify a member name that is different from the member name on the
|
||
|
|
remote file name on the DDM file.</li>
|
||
|
|
<li>If a DDM file does not specify a member name and if the <span class="cmdname">Override
|
||
|
|
with Database File (OVRDBF)</span> command specifies a member name for
|
||
|
|
the file, the <span class="cmdname">Copy File (CPYF)</span> command uses the member
|
||
|
|
name specified on the <span class="cmdname">OVRDBF</span> command.</li>
|
||
|
|
<li>If the TOFILE parameter is a DDM file that refers to a file
|
||
|
|
that does not exist, <span class="cmdname">CPYF</span> creates the file. Keep the following
|
||
|
|
special considerations for remote files created with the <span class="cmdname">Copy File
|
||
|
|
(CPYF)</span> command in mind: <ul><li>The user profile for the target DDM job must be authorized to the <span class="cmdname">Create
|
||
|
|
Physical File (CRTPF)</span> command on the application server (AS).</li>
|
||
|
|
<li>For an <span class="keyword">iSeries</span> target,
|
||
|
|
the TOFILE parameter has all the attributes of the FROMFILE parameter except
|
||
|
|
those described in the <a href="../dm/rbal3kickoff.htm">File
|
||
|
|
management</a> topic.</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li>When using TCP/IP, the second element of the RMTLOCNAME parameter of the <span class="cmdname">Create
|
||
|
|
Distributed Data Management File (CRTDDMF)</span> command must be *IP.</li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbal1mvdat.htm" title="A number of situations occur in enterprise operations that might require moving data from one iSeries server to another.">Move data from one iSeries server to another</a></div>
|
||
|
|
</div>
|
||
|
|
<div class="relconcepts"><strong>Related concepts</strong><br />
|
||
|
|
<div><a href="../ddm/rbae5kickoff.htm">Distributed data management</a></div>
|
||
|
|
</div>
|
||
|
|
<div class="relref"><strong>Related reference</strong><br />
|
||
|
|
<div><a href="../cl/cpyf.htm">Copy File (CPYF) command</a></div>
|
||
|
|
<div><a href="../cl/cpysrcf.htm">Copy Source File (CPYSRCF) command</a></div>
|
||
|
|
<div><a href="../cl/cpyfrmqryf.htm">Copy From Query File (CPYFRMQRYF) command</a></div>
|
||
|
|
<div><a href="../cl/cpyfrmtap.htm">Copy from Tape (CPYFRMTAP) command</a></div>
|
||
|
|
<div><a href="../cl/cpytotap.htm">Copy To Tape (CPYTOTAP) command</a></div>
|
||
|
|
<div><a href="../cl/crtpf.htm">Create Physical File (CRTPF) command</a></div>
|
||
|
|
<div><a href="../cl/crtddmf.htm">Create Distributed Data Management File (CRTDDMF) command</a></div>
|
||
|
|
<div><a href="../cl/ovrdbf.htm">Override with Database File (OVRDBF) command</a></div>
|
||
|
|
<div><a href="../cl/sbmrmtcmd.htm">Submit Remote Command (SBMRMTCMD) command</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|