ibm-information-center/dist/eclipse/plugins/i5OS.ic.dbp_5.4.0.1/rbafoaspfm.htm

75 lines
4.5 KiB
HTML
Raw Permalink Blame History

This file contains invisible Unicode characters

This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<?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="Size of the physical file member" />
<meta name="abstract" content="The SIZE parameter specifies the maximum number of records that can be placed in each member (CRTPF, CHGPF, CRTSRCPF, AND CHGSRCPF commands)." />
<meta name="description" content="The SIZE parameter specifies the maximum number of records that can be placed in each member (CRTPF, CHGPF, CRTSRCPF, AND CHGSRCPF commands)." />
<meta name="DC.subject" content="physical file, member size, SIZE parameter, parameter, SIZE" />
<meta name="keywords" content="physical file, member size, SIZE parameter, parameter, SIZE" />
<meta name="DC.Relation" scheme="URI" content="rbafophyfm.htm" />
<meta name="DC.Relation" scheme="URI" content="rbafoappmax.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="rbafoaspfm" />
<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>Size of the physical file member</title>
</head>
<body id="rbafoaspfm"><a name="rbafoaspfm"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">Size of the physical file member</h1>
<div><p>The SIZE parameter specifies the maximum number of records that
can be placed in each member (CRTPF, CHGPF, CRTSRCPF, AND CHGSRCPF commands).</p>
<p>The following formula can be used to determine the maximum:</p>
<p>R + (I * N)</p>
<div class="p">where:<dl><dt class="dlterm">R</dt>
<dd>is the starting record count</dd>
<dt class="dlterm">I</dt>
<dd>is the number of records (increment) to add each time</dd>
<dt class="dlterm">N</dt>
<dd>is the number of times to add the increment</dd>
</dl>
</div>
<div class="p">The defaults for the SIZE parameter are:<dl><dt class="dlterm">R</dt>
<dd>10 000</dd>
<dt class="dlterm">I</dt>
<dd>1000</dd>
<dt class="dlterm">N</dt>
<dd>3 (CRTPF command)</dd>
<dt class="dlterm"></dt>
<dd>499 (CRTSRCPF command)</dd>
</dl>
</div>
<p>For example, assume that R is a file created for 5000 records plus 3 increments
of 1000 records each. The system can add 1000 to the initial record count
of 5000 three times to make the total maximum 8000. When the
total maximum is reached, the system operator either stops the job or tells
the system to add another increment of records and continue. When increments
are added, a message is sent to the system history log. When the file is extended
beyond its maximum size, the minimum extension is 10% of the current size,
even if this is larger than the specified increment. Instead of taking the
default size or specifying a size, you can specify *NOMAX. </p>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafophyfm.htm" title="This topic describes some of the attributes you can specify for physical files and members on the Create Physical File (CRTPF), Create Source Physical File (CRTSRCPF), Change Physical File (CHGPF), Change Source Physical File (CHGSRCPF), Add Physical File Member (ADDPFM), and Change Physical File Member (CHGPFM) commands.">Specify physical file and member attributes when creating a physical file</a></div>
</div>
<div class="relref"><strong>Related reference</strong><br />
<div><a href="rbafoappmax.htm" title="When designing files on the iSeries server, you should keep in mind the sizes for database files.">Database file sizes</a></div>
</div>
</div>
</body>
</html>