File loading techniques - Revision history

JAL: /* Table D parameters */ link repair

2018-04-23T20:14:20Z

Table D parameters: link repair

← Older revision		Revision as of 20:14, 23 April 2018
Line 322:		Line 322:
	====OINODES parameter====		====OINODES parameter====
	<p>		<p>
	The estimate for the Ordered Index B-tree node space (see [[File size calculation in detail#Calculating ~~the file size multiplier example~~\|Calculating ~~the file size multiplier example~~]]) can be checked by viewing the <var>[[OINODES parameter\|OINODES]]</var> parameter. <var>OINODES</var> shows the number of Table D pages used for the Ordered Index B-tree. The exact number of pages necessary for the Ordered Index B-tree can be accurately determined only after each of the values of all the <var>ORDERED</var> fields has been loaded. </p>		The estimate for the Ordered Index B-tree node space (see [[File size calculation in detail#Calculating Ordered Index space\|Calculating Ordered Index space]]) can be checked by viewing the <var>[[OINODES parameter\|OINODES]]</var> parameter. <var>OINODES</var> shows the number of Table D pages used for the Ordered Index B-tree. The exact number of pages necessary for the Ordered Index B-tree can be accurately determined only after each of the values of all the <var>ORDERED</var> fields has been loaded. </p>

	[[Category:File loading and reorganization]]		[[Category:File loading and reorganization]]

ELowell at 22:31, 13 April 2015

2015-04-13T22:31:00Z

← Older revision		Revision as of 22:31, 13 April 2015
Line 280:		Line 280:
	===Detecting overflows with the TABLEC command===		===Detecting overflows with the TABLEC command===
	<p>		<p>
	The <var>TABLEC</var> command reports on property entry overflows vs. number of pages with spills. As described in, [[File size calculation#Sizing Table C\|Sizing Table C]], Table C contains property entries and segment entries. </p>		The <var>TABLEC</var> command reports on property entry overflows vs. number of pages with spills. As described in, [[File size calculation in detail#Sizing Table C\|Sizing Table C]], Table C contains property entries and segment entries. </p>

	====About overflows====		====About overflows====

ELowell: /* OINODES parameter */

2015-04-13T22:28:09Z

OINODES parameter

← Older revision		Revision as of 22:28, 13 April 2015
Line 322:		Line 322:
	====OINODES parameter====		====OINODES parameter====
	<p>		<p>
	The estimate for the Ordered Index B-tree node space (see [[File size calculation#Calculating the file size multiplier example\|Calculating the file size multiplier example]]) can be checked by viewing the <var>[[OINODES parameter\|OINODES]]</var> parameter. <var>OINODES</var> shows the number of Table D pages used for the Ordered Index B-tree. The exact number of pages necessary for the Ordered Index B-tree can be accurately determined only after each of the values of all the <var>ORDERED</var> fields has been loaded. </p>		The estimate for the Ordered Index B-tree node space (see [[File size calculation in detail#Calculating the file size multiplier example\|Calculating the file size multiplier example]]) can be checked by viewing the <var>[[OINODES parameter\|OINODES]]</var> parameter. <var>OINODES</var> shows the number of Table D pages used for the Ordered Index B-tree. The exact number of pages necessary for the Ordered Index B-tree can be accurately determined only after each of the values of all the <var>ORDERED</var> fields has been loaded. </p>

	[[Category:File loading and reorganization]]		[[Category:File loading and reorganization]]

ELowell: /* Table C space requirements */

2015-04-13T22:23:23Z

Table C space requirements

← Older revision		Revision as of 22:23, 13 April 2015
Line 250:		Line 250:
	===Table C space requirements===		===Table C space requirements===
	<p>		<p>
	New <var>KEY</var> values require only two slots in Table C for small files. If the file size multiplier (discussed in [[File size calculation#Computing the file size multiplier (N)\|Computing the file size multiplier (N)]]) is greater than 1, <var>KEY</var> values might require more than two slots. Therefore, at a rate dependent upon the level and nature of update activity, the number of slots used increases.</p>		New <var>KEY</var> values require only two slots in Table C for small files. If the file size multiplier, discussed in [[File size calculation in detail#Computing the file size multiplier (N)\|Computing the file size multiplier (N)]], is greater than 1, <var>KEY</var> values might require more than two slots. Therefore, at a rate dependent upon the level and nature of update activity, the number of slots used increases.</p>

	===TABLEC command===		===TABLEC command===

ELowell: /* Preventing extension records */

2015-04-13T22:21:46Z

Preventing extension records

← Older revision		Revision as of 22:21, 13 April 2015
Line 213:		Line 213:
	If the value of <var>EXTNADD</var> is too high (that is, if you have too many extension records) reload the file with a smaller <var>BRECPPG</var> or a larger <var>BRESERVE</var>. </p>		If the value of <var>EXTNADD</var> is too high (that is, if you have too many extension records) reload the file with a smaller <var>BRECPPG</var> or a larger <var>BRESERVE</var>. </p>
	<p class="note"><b>Note:</b>		<p class="note"><b>Note:</b>
	If a few records within the file are much longer than the average record, it might be most efficient to allow the longest records to create extension records. For more information about sizing <var>BRESERVE</var> to avoid extension records, see [[ File size calculation#Computing BRESERVE (reserved Table B space)\|Computing BRESERVE (reserved Table B space)]].</p>		If a few records within the file are much longer than the average record, it might be most efficient to allow the longest records to create extension records. For more information about sizing <var>BRESERVE</var> to avoid extension records, see [[File size calculation in detail#Computing BRESERVE (reserved Table B space)\|Computing BRESERVE (reserved Table B space)]].</p>

	===Sizing Table B===		===Sizing Table B===

ELowell: /* Refining the file parameter settings */

2015-04-13T21:20:50Z

Refining the file parameter settings

← Older revision		Revision as of 21:20, 13 April 2015
Line 96:		Line 96:
	==Refining the file parameter settings==		==Refining the file parameter settings==
	<p>		<p>
	After sample records have been loaded, a number of file parameters can be reevaluated based on actual data. A few parameters can be viewed to determine whether any incorrect estimates have been made. These parameters are grouped by file table and are described in the following sections.For more detailed information about setting the file parameters, see [[File size calculation]]. </p>		After sample records have been loaded, a number of file parameters can be reevaluated based on actual data. A few parameters can be viewed to determine whether any incorrect estimates have been made. These parameters are grouped by file table and are described in the following sections.For more detailed information about setting the file parameters, see [[File size calculation in detail]]. </p>

	==Loading Large Object data==		==Loading Large Object data==

JAL: minor cleanup

2014-12-08T21:46:44Z

minor cleanup

Show changes

JAL at 22:01, 2 September 2014

2014-09-02T22:01:48Z

← Older revision		Revision as of 22:01, 2 September 2014
Line 212:		Line 212:
	===Sizing Table B===		===Sizing Table B===
	<p>		<p>
	This section describes the BSIZE and BHIGHPG parameters. For more information about sizing Table B, see [[ ~~Managing~~ File ~~and~~ Table ~~Size Manually#Overview~~\|~~Overview~~]] .</p>		This section describes the <var>BSIZE</var> and <var>BHIGHPG</var> parameters. For more information about sizing Table B, see [[File size calculation in detail#Sizing Table B\|Sizing Table B]].</p>

	====Using BHIGHPG to size BSIZE====		====Using BHIGHPG to size BSIZE====
	<p>		<p>
	To check your estimate of BSIZE, look at the BHIGHPG parameter. In ordinary and sorted files, BHIGHPG is the number of the last page used, one less than the number of pages used. If this number is significantly different from the estimate of space required for the sample, then adjust BSIZE accordingly. </p>		To check your estimate of <var>BSIZE</var>, look at the <var>BHIGHPG</var> parameter. In ordinary and sorted files, <var>BHIGHPG</var> is the number of the last page used, one less than the number of pages used. If this number is significantly different from the estimate of space required for the sample, then adjust <var>BSIZE</var> accordingly. </p>

	====Checking for overflow records in sorted files====		====Checking for overflow records in sorted files====

JAL at 20:22, 14 April 2014

2014-04-14T20:22:57Z

Show changes

ELowell at 21:48, 22 January 2014

2014-01-22T21:48:44Z

← Older revision		Revision as of 21:48, 22 January 2014
Line 221:		Line 221:
	<p> </p>		<p> </p>

	[[Category:File ~~management~~]]		[[Category:File loading and reorganization]]