<?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="Specify the recover (RECOVER) parameter" /> <meta name="abstract" content="After a failure, you must rebuild changed access paths that were not forced to auxiliary storage or journaled with the RECOVER parameter." /> <meta name="description" content="After a failure, you must rebuild changed access paths that were not forced to auxiliary storage or journaled with the RECOVER parameter." /> <meta name="DC.subject" content="recovery, access path, if the system fails, recovering, if the system fails, path, access, RECOVER parameter, parameter, RECOVER" /> <meta name="keywords" content="recovery, access path, if the system fails, recovering, if the system fails, path, access, RECOVER parameter, parameter, RECOVER" /> <meta name="DC.Relation" scheme="URI" content="rbafocrtatt.htm" /> <meta name="DC.Relation" scheme="URI" content="rbaforzahfpra.htm" /> <meta name="DC.Relation" scheme="URI" content="../books/sc415304.pdf" /> <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="rbafonoid18" /> <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>Specify the recover (RECOVER) parameter</title> </head> <body id="rbafonoid18"><a name="rbafonoid18"><!-- --></a> <!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script> <h1 class="topictitle1">Specify the recover (RECOVER) parameter</h1> <div><p>After a failure, you must rebuild changed access paths that were not forced to auxiliary storage or journaled with the RECOVER parameter.</p> <div class="p">To rebuild access paths and to recover data, you can use the RECOVER parameter on the following commands. These commands specify when the access path is to be rebuilt: <ul><li>Create Physical File (CRTPF)</li> <li>Create Logical File (CRTLF)</li> <li>Create Source Physical File (CRTSRCPF)</li> </ul> <div class="note"><span class="notetitle">Note:</span> Access paths are rebuilt either during the initial program load (IPL), after the IPL, or when a file is opened.</div> </div> <p><a href="#rbafonoid18__rbafoopstab">Table 1</a> shows your choices for possible combinations of duplicate key and maintenance options.</p> <div class="tablenoborder"><a name="rbafonoid18__rbafoopstab"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="rbafonoid18__rbafoopstab" width="100%" frame="border" border="1" rules="rows"><caption>Table 1. Recovery options</caption><thead align="left"><tr><th align="left" valign="bottom" width="25.252525252525253%" id="d0e68">With this duplicate key option</th> <th align="left" valign="bottom" width="24.494949494949495%" id="d0e70">And this maintenance option</th> <th align="left" valign="bottom" width="50.252525252525245%" id="d0e72">Your recovery options are</th> </tr> </thead> <tbody><tr><td align="left" valign="top" width="25.252525252525253%" headers="d0e68 ">Unique</td> <td align="left" valign="top" width="24.494949494949495%" headers="d0e70 ">Immediate</td> <td align="left" valign="top" width="50.252525252525245%" headers="d0e72 ">Rebuild during the IPL (*IPL) Rebuild after the IPL (*AFTIPL, default) Do not rebuild at IPL, wait for first open (*NO)</td> </tr> <tr><td align="left" valign="top" width="25.252525252525253%" headers="d0e68 ">Not unique</td> <td align="left" valign="top" width="24.494949494949495%" headers="d0e70 ">Immediate or delayed</td> <td align="left" valign="top" width="50.252525252525245%" headers="d0e72 ">Rebuild during the IPL (*IPL) Rebuild after the IPL (*AFTIPL) Do not rebuild at IPL, wait for first open (*NO, default)</td> </tr> <tr><td align="left" valign="top" width="25.252525252525253%" headers="d0e68 ">Not unique</td> <td align="left" valign="top" width="24.494949494949495%" headers="d0e70 ">Rebuild</td> <td align="left" valign="top" width="50.252525252525245%" headers="d0e72 ">Do not rebuild at IPL, wait for first open (*NO, default)</td> </tr> </tbody> </table> </div> <div class="section" id="rbafonoid18__rbafonoid19"><a name="rbafonoid18__rbafonoid19"><!-- --></a><h4 class="sectiontitle">RECOVER parameter tip</h4><p>A list of files with access paths that need to be recovered is shown on the Edit Rebuild of Access Paths display during the next IPL if the IPL is in manual mode. You can edit the original recovery option for the file by selecting the desired option on the display. After the IPL is complete, you can use the Edit Rebuild of Access Paths (EDTRBDAP) command to set the sequence in which access paths are rebuilt. If the IPL is unattended, the Edit Rebuild of Access Paths display is not shown and the access paths are rebuilt in the order determined by the RECOVER parameter. You only see the *AFTIPL and *NO (open) access paths.</p> </div> </div> <div> <div class="familylinks"> <div class="parentlink"><strong>Parent topic:</strong> <a href="rbafocrtatt.htm" title="When you create a database file, database attributes are stored with the file and members. You specify attributes with database command parameters.">Specify database file and member attributes</a></div> </div> <div class="relconcepts"><strong>Related concepts</strong><br /> <div><a href="rbaforzahfpra.htm" title="These topics discuss the iSeries functions of recovering or restoring your database after the system loses data.">Recover and restore your database</a></div> <div><a href="../books/sc415304.pdf" target="_blank">Backup and Recovery PDF</a></div> </div> </div> </body> </html>