136 lines
13 KiB
HTML
136 lines
13 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="reference" />
|
||
<meta name="DC.Title" content="Save and restore processing for a distributed relational database" />
|
||
<meta name="abstract" content="Saving and restoring data and programs allows recovery from a program or server failure, exchange of information between servers, or storage of objects or data offline. A sound backup policy at each server in the distributed relational database network ensures that a server can be restored and made available to network users quickly in the event of a problem." />
|
||
<meta name="description" content="Saving and restoring data and programs allows recovery from a program or server failure, exchange of information between servers, or storage of objects or data offline. A sound backup policy at each server in the distributed relational database network ensures that a server can be restored and made available to network users quickly in the event of a problem." />
|
||
<meta name="DC.subject" content="saving, to tape, to save file, save file, restoring, from save file, from tape, object, library, changed object, save file data, command, SAVLIB (Save Library), Save Library (SAVLIB), command, CL, SAVLIB (Save Library), Save Library (SAVLIB), SAVOBJ (Save Object), Save Object (SAVOBJ), SAVOBJ (Save Object), Save Object (SAVOBJ), SAVCHGOBJ (Save Changed Object), Save Changed Object (SAVCHGOBJ), Save Changed Object (SAVCHGOBJ), changed object, SAVSAVFDTA (Save Save File Data), Save Save File Data (SAVSAVFDTA), SAVSAVFDTA (Save Save File Data), Save Save File Data (SAVSAVFDTA), SAVSYS (Save System), Save System (SAVSYS), Save System (SAVSYS), system, RSTLIB (Restore Library), Restore Library (RSTLIB), Restore Library (RSTLIB), RSTOBJ (Restore Object), Restore Object (RSTOBJ), Restore Object (RSTOBJ), RSTUSRPRF (Restore User Profiles), Restore User Profiles (RSTUSRPRF), Restore User Profiles (RSTUSRPRF), user profiles, RSTCFG (Restore Configuration), Restore Configuration (RSTCFG), Restore Configuration (RSTCFG), configuration, RSTAUT (Restore Authority), Restore Authority (RSTAUT), Restore Authority (RSTAUT), authority" />
|
||
<meta name="keywords" content="saving, to tape, to save file, save file, restoring, from save file, from tape, object, library, changed object, save file data, command, SAVLIB (Save Library), Save Library (SAVLIB), command, CL, SAVLIB (Save Library), Save Library (SAVLIB), SAVOBJ (Save Object), Save Object (SAVOBJ), SAVOBJ (Save Object), Save Object (SAVOBJ), SAVCHGOBJ (Save Changed Object), Save Changed Object (SAVCHGOBJ), Save Changed Object (SAVCHGOBJ), changed object, SAVSAVFDTA (Save Save File Data), Save Save File Data (SAVSAVFDTA), SAVSAVFDTA (Save Save File Data), Save Save File Data (SAVSAVFDTA), SAVSYS (Save System), Save System (SAVSYS), Save System (SAVSYS), system, RSTLIB (Restore Library), Restore Library (RSTLIB), Restore Library (RSTLIB), RSTOBJ (Restore Object), Restore Object (RSTOBJ), Restore Object (RSTOBJ), RSTUSRPRF (Restore User Profiles), Restore User Profiles (RSTUSRPRF), Restore User Profiles (RSTUSRPRF), user profiles, RSTCFG (Restore Configuration), Restore Configuration (RSTCFG), Restore Configuration (RSTCFG), configuration, RSTAUT (Restore Authority), Restore Authority (RSTAUT), Restore Authority (RSTAUT), authority" />
|
||
<meta name="DC.Relation" scheme="URI" content="rbal1recovsupp.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="rbal1saveindex.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="rbal1savesecurity.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="rbal1savesqlpackages.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="rbal1savrdbd.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="rbal1rcvtrn.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="../db2/rbafzmsth2clcu.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="../cl/strcmtctl.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="../rzakj/rzakjtrouble.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="../cl/wrkcmtdfn.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="rbal1cmt.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="../cl/savobj.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="../cl/savlib.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="../cl/savchgobj.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="../cl/savsavfdta.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="../cl/savsys.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="../cl/rstlib.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="../cl/rstobj.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="../cl/rstusrprf.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="../cl/rstaut.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="../cl/rstcfg.htm" />
|
||
<meta name="DC.Relation" scheme="URI" content="../cl/savsys.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="rbal1saverestore" />
|
||
<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>Save and restore processing for a distributed relational database</title>
|
||
</head>
|
||
<body id="rbal1saverestore"><a name="rbal1saverestore"><!-- --></a>
|
||
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
<h1 class="topictitle1">Save and restore processing for a distributed relational database</h1>
|
||
<div><p>Saving and restoring data and programs allows recovery from a program
|
||
or server failure, exchange of information between servers, or storage of
|
||
objects or data offline. A sound backup policy at each server in the distributed
|
||
relational database network ensures that a server can be restored and made
|
||
available to network users quickly in the event of a problem.</p>
|
||
<div class="section"><p>Saving the server on external media such as tape, protects server
|
||
programs and data from disasters, such as fire or flood. However, information
|
||
can also be saved to a disk file called a save file. A save file is a disk-resident
|
||
file used to store data until it is used in input and output operations or
|
||
for transmission to another <span class="keyword">iSeries™ server</span> over
|
||
communication lines. Using a save file allows unattended save operations because
|
||
an operator does not need to load tapes. In a distributed relational database,
|
||
save files can be sent to another server as a protection method.</p>
|
||
</div>
|
||
<div class="section"><p>When information is restored, the information is written from
|
||
tape or a save file into auxiliary storage where it can be accessed by server
|
||
users.</p>
|
||
</div>
|
||
<div class="section"><p>The <span class="keyword">iSeries server</span> has
|
||
a full set of commands to save and restore your database tables and SQL objects: </p>
|
||
<ul><li>The <span class="cmdname">Save Library (SAVLIB)</span> command saves one or more
|
||
collections </li>
|
||
<li>The <span class="cmdname">Save Object (SAVOBJ)</span> command saves one or more
|
||
objects such as SQL tables, views and indexes </li>
|
||
<li>The <span class="cmdname">Save Changed Object (SAVCHGOBJ)</span> command saves any
|
||
objects that have changed since either the last time the collection was saved
|
||
or from a specified date </li>
|
||
<li>The <span class="cmdname">Save Save File Data (SAVSAVFDTA)</span> command saves
|
||
the contents of a save file </li>
|
||
<li>The <span class="cmdname">Save System (SAVSYS)</span> command saves the operating
|
||
system, security information, device configurations, and server values </li>
|
||
<li>The <span class="cmdname">Restore Library (RSTLIB)</span> command restores a collection </li>
|
||
<li>The <span class="cmdname">Restore Object (RSTOBJ)</span> command restores one or
|
||
more objects such as SQL tables, views and indexes</li>
|
||
<li>The <span class="cmdname">Restore User Profiles (RSTUSRPRF)</span>, <span class="cmdname">Restore
|
||
Authority (RSTAUT)</span> and <span class="cmdname">Restore Configuration (RSTCFG)</span> commands
|
||
restore user profiles, authorities, and configurations saved by a <span class="cmdname">Save
|
||
System (SAVSYS)</span> command</li>
|
||
</ul>
|
||
</div>
|
||
<div class="section"></div>
|
||
</div>
|
||
<div>
|
||
<ul class="ullinks">
|
||
<li class="ulchildlink"><strong><a href="rbal1saveindex.htm">Save and restore indexes in the distributed relational database environment</a></strong><br />
|
||
Restoring an SQL index can be faster than rebuilding it. Although times vary depending on a number of factors, rebuilding a database index takes approximately one minute for every 10 000 rows.</li>
|
||
<li class="ulchildlink"><strong><a href="rbal1savesecurity.htm">Save and restore security information in the distributed relational database environment</a></strong><br />
|
||
You can use a variety of CL commands to save and restore security information.</li>
|
||
<li class="ulchildlink"><strong><a href="rbal1savesqlpackages.htm">Save and restore SQL packages in the distributed relational database environment</a></strong><br />
|
||
When an application program that refers to a relational database on a remote server is precompiled and bound, an SQL package is created on the application server (AS) to contain the control structures necessary to process any SQL statements in the application.</li>
|
||
<li class="ulchildlink"><strong><a href="rbal1savrdbd.htm">Save and restore relational database directories</a></strong><br />
|
||
The relational database directory is not an <span class="keyword">iSeries</span> object.
|
||
Instead it is made up of files that are opened by the server at IPL time.</li>
|
||
</ul>
|
||
|
||
<div class="familylinks">
|
||
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbal1recovsupp.htm" title="Failures that can occur on a computer server are a server failure (when the entire server is not operating); a loss of the site due to fire, flood, or similar catastrophe; or the damage or loss of an object. For a distributed relational database, a failure on one server in the network prevents users across the entire network from accessing the relational database on that server.">Recovery support for a distributed relational database</a></div>
|
||
</div>
|
||
<div class="reltasks"><strong>Related tasks</strong><br />
|
||
<div><a href="rbal1cmt.htm" title="Use the Work with Commitment Definitions (WRKCMTDFN) command if you want to work with the commitment definitions on the server.">Work with commitment definitions in a distributed relational database</a></div>
|
||
</div>
|
||
<div class="relref"><strong>Related reference</strong><br />
|
||
<div><a href="rbal1rcvtrn.htm" title="Commitment control is an extension of the journal management function on the iSeries server. The server can identify and process a group of relational database changes as a single unit of work (transaction).">Transaction recovery through commitment control</a></div>
|
||
</div>
|
||
<div class="relinfo"><strong>Related information</strong><br />
|
||
<div><a href="../db2/rbafzmsth2clcu.htm">DECLARE CURSOR</a></div>
|
||
<div><a href="../cl/strcmtctl.htm">Start Commitment Control (STRCMTCTL) command</a></div>
|
||
<div><a href="../rzakj/rzakjtrouble.htm">Troubleshoot transactions and commitment control</a></div>
|
||
<div><a href="../cl/wrkcmtdfn.htm">Work with Commitment Definitions (WRKCMTDFN) command</a></div>
|
||
<div><a href="../cl/savobj.htm">Save Object (SAVOBJ) command</a></div>
|
||
<div><a href="../cl/savlib.htm">Save Library (SAVLIB) command</a></div>
|
||
<div><a href="../cl/savchgobj.htm">Save Changed Object (SAVCHGOBJ) command</a></div>
|
||
<div><a href="../cl/savsavfdta.htm">Save Save File Data (SAVSAVFDTA) command</a></div>
|
||
<div><a href="../cl/savsys.htm">Save System (SAVSYS) command</a></div>
|
||
<div><a href="../cl/rstlib.htm">Restore Library (RSTLIB) command</a></div>
|
||
<div><a href="../cl/rstobj.htm">Restore Object (RSTOBJ) command</a></div>
|
||
<div><a href="../cl/rstusrprf.htm">Restore User Profiles (RSTUSRPRF) command</a></div>
|
||
<div><a href="../cl/rstaut.htm">Restore Authority (RSTAUT) command</a></div>
|
||
<div><a href="../cl/rstcfg.htm">Restore Configuration (RSTCFG) command</a></div>
|
||
</div>
|
||
</div>
|
||
</body>
|
||
</html> |