100 lines
7.0 KiB
HTML
100 lines
7.0 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="Move data from one iSeries server to another" />
|
||
|
|
<meta name="abstract" content="A number of situations occur in enterprise operations that might require moving data from one iSeries server to another." />
|
||
|
|
<meta name="description" content="A number of situations occur in enterprise operations that might require moving data from one iSeries server to another." />
|
||
|
|
<meta name="DC.subject" content="moving data, between, server, iSeries" />
|
||
|
|
<meta name="keywords" content="moving data, between, server, iSeries" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1dbload.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1createuwap.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1queryint.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1queryremote.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1copydisk.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1cpfddm.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1trnasnfc.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal1movesave.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="rbal1mvdat" />
|
||
|
|
<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 from one iSeries server to
|
||
|
|
another</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbal1mvdat"><a name="rbal1mvdat"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Move data from one <span class="keyword">iSeries server</span> to
|
||
|
|
another</h1>
|
||
|
|
<div><p>A number of situations occur in enterprise operations that might
|
||
|
|
require moving data from one <span class="keyword">iSeries™ server</span> to
|
||
|
|
another.</p>
|
||
|
|
<p>An example for a situation that might require moving data from an <span class="keyword">iSeries server</span> to another server would be
|
||
|
|
a new dealership opens in a region, and some clients from one or two other
|
||
|
|
dealerships might be transferred to the new dealership as determined by client
|
||
|
|
address. Perhaps a dealership closed or no longer represents Spiffy Corporation
|
||
|
|
sales and service. That dealer's inventories and required service information
|
||
|
|
must be allocated to either the regional office or other area dealerships.
|
||
|
|
Perhaps a dealership has grown to the extent that it needs to upgrade its
|
||
|
|
server, and the entire database must be moved to the new server.</p>
|
||
|
|
<p>Some alternatives for moving data from one <span class="keyword">iSeries server</span> to
|
||
|
|
another are: </p>
|
||
|
|
<ul><li>User-written application programs</li>
|
||
|
|
<li>Interactive SQL (ISQL)</li>
|
||
|
|
<li>DB2
|
||
|
|
Universal Database™ for <span class="keyword">iSeries</span> Query
|
||
|
|
Management functions</li>
|
||
|
|
<li>Copy to and from tape devices</li>
|
||
|
|
<li>Copy file commands with DDM</li>
|
||
|
|
<li>The network file commands</li>
|
||
|
|
<li><span class="keyword">iSeries server</span> save and restore
|
||
|
|
commands</li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1createuwap.htm">Create a user-written application program</a></strong><br />
|
||
|
|
A program compiled with distributed unit of work (DUW) connection management can connect to a remote database and a local database and FETCH from one to INSERT into the other to move the data.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1queryint.htm">Query a database using Interactive SQL</a></strong><br />
|
||
|
|
Using the SQL SELECT statement and Interactive SQL, you can query
|
||
|
|
a database on another <span class="keyword">iSeries server</span> for
|
||
|
|
data you need to create or update a table on the local server. </li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1queryremote.htm">Query remote servers using DB2 Universal Database for iSeries query management function</a></strong><br />
|
||
|
|
The DB2
|
||
|
|
Universal Database for <span class="keyword">iSeries</span> query
|
||
|
|
management function provides almost the same support as Interactive SQL for
|
||
|
|
querying a remote server and returning the results in an output file to the
|
||
|
|
local server.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1copydisk.htm">Copy files to and from tape</a></strong><br />
|
||
|
|
There are several different commands that you can use to copy files to and from tape.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1cpfddm.htm">Move data between iSeries servers using copy file commands</a></strong><br />
|
||
|
|
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.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1trnasnfc.htm">Transfer data over network using Network File commands</a></strong><br />
|
||
|
|
Data can be transferred over networks protocols that support Systems Network Architecture (SNA) distribution services (SNADS). In addition to APPC and APPN protocols used with distributed relational database processing, SNADS can be used with binary synchronous equivalence link (BSCEL) and SNA Upline Facility (SNUF) protocols.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal1movesave.htm">Move a table using server save and restore commands</a></strong><br />
|
||
|
|
You can move a table from another <span class="keyword">iSeries server</span> using
|
||
|
|
the <span class="cmdname">Save Object (SAVOBJ)</span> and <span class="cmdname">Restore Object (RSTOBJ)</span> commands.
|
||
|
|
The save commands save database files on tape or in a save file. The save
|
||
|
|
file can be distributed to another server through communications.</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbal1dbload.htm" title="Applications in the distributed relational database environment operate on data stored in tables. In general, applications are used to query a table for information, to insert, update, or delete rows of a table or tables, or to create a new table. Other situations occur where data on one server must be moved to another server.">Load data into tables in a distributed relational database</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|