104 lines
7.7 KiB
HTML
104 lines
7.7 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="Reset the sequence number of journal entries" />
|
|||
|
|
<meta name="abstract" content="Normally, when you change journal receivers, you continue the sequence number of journal entries. When the sequence number becomes very large, consider resetting the sequence to start the numbering at 1. You can reset the sequence number only when all changes are forced to auxiliary storage for all journaled objects and commitment control is not active for the journal. Resetting the sequence number has no effect on how the new journal receiver is named." />
|
|||
|
|
<meta name="description" content="Normally, when you change journal receivers, you continue the sequence number of journal entries. When the sequence number becomes very large, consider resetting the sequence to start the numbering at 1. You can reset the sequence number only when all changes are forced to auxiliary storage for all journaled objects and commitment control is not active for the journal. Resetting the sequence number has no effect on how the new journal receiver is named." />
|
|||
|
|
<meta name="DC.Relation" scheme="URI" content="rzakiswapdel.htm" />
|
|||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/chgjrn.htm" />
|
|||
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 2004, 2006" />
|
|||
|
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 2004, 2006" />
|
|||
|
|
<meta name="DC.Format" content="XHTML" />
|
|||
|
|
<meta name="DC.Identifier" content="rzakiresetjrn" />
|
|||
|
|
<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>Reset the sequence number of journal entries</title>
|
|||
|
|
</head>
|
|||
|
|
<body id="rzakiresetjrn"><a name="rzakiresetjrn"><!-- --></a>
|
|||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|||
|
|
<h1 class="topictitle1">Reset the sequence number of journal entries</h1>
|
|||
|
|
<div><p>Normally, when you change journal receivers, you continue the sequence
|
|||
|
|
number of journal entries. When the sequence number becomes very large, consider
|
|||
|
|
resetting the sequence to start the numbering at 1. You can reset the sequence
|
|||
|
|
number only when all changes are forced to auxiliary storage for all journaled
|
|||
|
|
objects and commitment control is not active for the journal. Resetting the
|
|||
|
|
sequence number has no effect on how the new journal receiver is named.</p>
|
|||
|
|
<div class="section"><p>Some conditions prevent you from resetting the sequence number,
|
|||
|
|
such as an active commit cycle. If the system cannot reset the sequence number,
|
|||
|
|
you receive message CPF7018.</p>
|
|||
|
|
<p>If you use system journal-receiver management
|
|||
|
|
for a journal and RCVSIZOPT(*MAXOPT3) is not specified, the sequence number
|
|||
|
|
for the journal is reset to 1 whenever you restart the system or vary on the
|
|||
|
|
independent disk pool containing the journal. When you restart the system
|
|||
|
|
or vary on an independent disk pool, the system performs the change journal
|
|||
|
|
operation for every journal on the system or disk pool that specifies system
|
|||
|
|
journal-receiver management. The operation that the system performs is equivalent
|
|||
|
|
to <samp class="codeph">CHGJRN JRN(xxx) JRNRCV(*GEN) SEQOPT(*RESET)</samp>. The sequence
|
|||
|
|
number is not reset if journal entries exist that are needed for commitment
|
|||
|
|
control IPL recovery. When RCVSIZOPT(*MAXOPT3) is specified, the sequence
|
|||
|
|
number is only reset when you restart your system or vary on an independent
|
|||
|
|
disk pool if it is approaching the maximum value. </p>
|
|||
|
|
<p><img src="./delta.gif" alt="Start of change" />If you
|
|||
|
|
specify RCVSIZOPT(*MAXOPT1), RCVSIZOPT(*MAXOPT2), or RCVSIZOPT(*SYSDFT) for
|
|||
|
|
the journal to which you attached the receiver, the maximum sequence number
|
|||
|
|
is 9 999 999 999. If you specify RCVSIZOPT(*MAXOPT3), the maximum
|
|||
|
|
sequence number is 18 446 744 073 709 551 600.
|
|||
|
|
If you do not specify a receiver-size option, the maximum sequence number
|
|||
|
|
is 2 147 483 136. If these numbers are reached, journaling
|
|||
|
|
stops for that journal. Whenever you change journal receivers, the system
|
|||
|
|
tells you what the starting sequence number is through message CPF7019. Also,
|
|||
|
|
when you are approaching the sequence number limit, CPF7019 is additionally
|
|||
|
|
sent to the QSYSOPR message queue every time you change journal receivers.<img src="./deltaend.gif" alt="End of change" /></p>
|
|||
|
|
<p><img src="./delta.gif" alt="Start of change" />The system sends a warning message (CPI70E7) to the journal's message
|
|||
|
|
queue when the sequence number exceeds 2 147 000 000. If you
|
|||
|
|
specified RCVSIZOPT(*MAXOPT1), RCVSIZOPT(*MAXOPT2), or RCVSIZOPT(*SYSDFT)
|
|||
|
|
for the journal that you attached the receiver to, the system sends the warning
|
|||
|
|
message when the sequence number exceeds 9 900 000 000. If
|
|||
|
|
you specified RCVSIZOPT(*MAXOPT3), the system sends the warning message when
|
|||
|
|
the sequence number exceeds 18 446 644 000 000 000 000.
|
|||
|
|
If you use system change-journal management support (MNGRCV(*SYSTEM)) for
|
|||
|
|
the journal, the system attempts to change the journal and reset the sequence
|
|||
|
|
number one time. The message is sent only if the attempt is not successful. <img src="./deltaend.gif" alt="End of change" /></p>
|
|||
|
|
<p>To
|
|||
|
|
reset the sequence numbers for journal entries proceed as follows:</p>
|
|||
|
|
</div>
|
|||
|
|
<ol><li><span>In the <strong>iSeries™ Navigator</strong> window, expand the system you
|
|||
|
|
want to use.</span></li>
|
|||
|
|
<li><span>Expand <span class="uicontrol">Databases</span>.</span></li>
|
|||
|
|
<li><span>Expand the database that you want to work with and <span class="uicontrol">Schemas</span>.</span></li>
|
|||
|
|
<li><span>Double-click the journal you want to use.</span></li>
|
|||
|
|
<li><span>Select <span class="uicontrol">Swap receivers</span> and under <span class="uicontrol">Sequence
|
|||
|
|
numbering</span> select <span class="uicontrol">Reset</span>.</span></li>
|
|||
|
|
<li><span>Click <span class="uicontrol">OK</span>. The <span class="uicontrol">Journal properties</span> dialog
|
|||
|
|
closes. The new journal receiver is automatically created and attached.</span></li>
|
|||
|
|
</ol>
|
|||
|
|
<div class="section"><div class="note"><span class="notetitle">Note:</span> If you attempt to use the <span class="cmdname">CHGJRN</span> command
|
|||
|
|
with the same journal receiver name and SEQOPT(*CONT), you may receive the
|
|||
|
|
message CPF701A. To recover, delete the journal receiver and use the <span class="cmdname">CHGJRN</span> command
|
|||
|
|
again.</div>
|
|||
|
|
<p>To change the sequence number with the <span class="cmdname">Change Journal
|
|||
|
|
(CHGJRN)</span> command, specify the SEQOPT(*RESET) parameter.</p>
|
|||
|
|
</div>
|
|||
|
|
</div>
|
|||
|
|
<div>
|
|||
|
|
<div class="familylinks">
|
|||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rzakiswapdel.htm" title="The management tasks that you need to perform most often for journaling are swapping journal receivers and saving and deleting journal receivers.">Swap, delete, and save journals and receivers</a></div>
|
|||
|
|
</div>
|
|||
|
|
<div class="relref"><strong>Related reference</strong><br />
|
|||
|
|
<div><a href="../cl/chgjrn.htm">Change Journal (CHGJRN) command</a></div>
|
|||
|
|
</div>
|
|||
|
|
</div>
|
|||
|
|
</body>
|
|||
|
|
</html>
|