Table E (File architecture) - Revision history

JAL: /* Summary */ typo

2016-09-01T20:50:44Z

Summary: typo

← Older revision		Revision as of 20:50, 1 September 2016
Line 6:		Line 6:

	==Summary==		==Summary==
	Storage and manipulation of Large Objects (LOBs) differs greatly depending on whether <var>[[FILEORG parameter\|FILEORG]]</var> X'100' is set.		Storage and manipulation of Large Objects (LOBs) differs greatly depending on whether <var>[[FILEORG parameter\|FILEORG]]</var> X'100' is set:

	:[[Table E and non-FILEORG X'100' files (File architecture)\|Table E without FILEORG X'100']]		:[[Table E and non-FILEORG X'100' files (File architecture)\|Table E without FILEORG X'100']]

ELowell at 17:07, 12 May 2014

2014-05-12T17:07:55Z

← Older revision		Revision as of 17:07, 12 May 2014
Line 1:		Line 1:
	<span class="pageSubtitle">Holds Large Object data (BLOBs and CLOBs)</span>		<span class="pageSubtitle">Holds Large Object data (BLOBs and CLOBs)</span>

	Table E is enabled by reorganizing/[[CREATE command: File\|creating]] a file with <var>[[ESIZE parameter\|ESIZE]]</var> greater than 0, and then [[DEFINE FIELD command\|defining a field]] with a data type of [[Field design#BLOB.2C CLOB and ~~MINLOBE attributes~~\|CLOB or BLOB]] (the file must have a non-zero <var>ESIZE</var> value for the latter to occur).		Table E is enabled by reorganizing/[[CREATE command: File\|creating]] a file with <var>[[ESIZE parameter\|ESIZE]]</var> greater than 0, and then [[DEFINE FIELD command\|defining a field]] with a data type of [[Field design#BLOB.2C CLOB.2C and MINLOBE_attributes\|CLOB or BLOB]] (the file must have a non-zero <var>ESIZE</var> value for the latter to occur).

	Table E is available as of Model 204 V7.1		Table E is available as of Model 204 V7.1

ELowell at 17:07, 12 May 2014

2014-05-12T17:07:03Z

← Older revision		Revision as of 17:07, 12 May 2014
Line 44:		Line 44:
	<td>Even a single byte of data requires a full page of Table E. </td>		<td>Even a single byte of data requires a full page of Table E. </td>

	<td>Fields can be defined with the <var>[[Field design#BLOB.2C CLOB and MINLOBE_attributes\|MINLOBE]]</var> attribute to permit small amounts of data to be stored directly in the record in Table B. <var>MINLOBE</var> can be set up to 200 bytes. </td></tr>		<td>Fields can be defined with the <var>[[Field design#BLOB.2C CLOB.2C and MINLOBE_attributes\|MINLOBE]]</var> attribute to permit small amounts of data to be stored directly in the record in Table B. <var>MINLOBE</var> can be set up to 200 bytes. </td></tr>

	<tr><th>Change a LOB</th>		<tr><th>Change a LOB</th>

ELowell at 17:05, 12 May 2014

2014-05-12T17:05:40Z

← Older revision		Revision as of 17:05, 12 May 2014
Line 1:		Line 1:
	<span class="pageSubtitle">Holds Large Object data (BLOBs and CLOBs)</span>		<span class="pageSubtitle">Holds Large Object data (BLOBs and CLOBs)</span>

	Table E is enabled by reorganizing/[[CREATE command: File\|creating]] a file with <var>[[ESIZE parameter\|ESIZE]]</var> greater than 0, and then [[DEFINE FIELD command\|defining a field]] with a data type of [[Field design ~~(File management)~~#BLOB.2C CLOB and MINLOBE attributes\|CLOB or BLOB]] (the file must have a non-zero <var>ESIZE</var> value for the latter to occur).		Table E is enabled by reorganizing/[[CREATE command: File\|creating]] a file with <var>[[ESIZE parameter\|ESIZE]]</var> greater than 0, and then [[DEFINE FIELD command\|defining a field]] with a data type of [[Field design#BLOB.2C CLOB and MINLOBE attributes\|CLOB or BLOB]] (the file must have a non-zero <var>ESIZE</var> value for the latter to occur).

	Table E is available as of Model 204 V7.1		Table E is available as of Model 204 V7.1
Line 44:		Line 44:
	<td>Even a single byte of data requires a full page of Table E. </td>		<td>Even a single byte of data requires a full page of Table E. </td>

	<td>Fields can be defined with the <var>[[Field design ~~(File management)~~#BLOB.2C CLOB and MINLOBE_attributes\|MINLOBE]]</var> attribute to permit small amounts of data to be stored directly in the record in Table B. <var>MINLOBE</var> can be set up to 200 bytes. </td></tr>		<td>Fields can be defined with the <var>[[Field design#BLOB.2C CLOB and MINLOBE_attributes\|MINLOBE]]</var> attribute to permit small amounts of data to be stored directly in the record in Table B. <var>MINLOBE</var> can be set up to 200 bytes. </td></tr>

	<tr><th>Change a LOB</th>		<tr><th>Change a LOB</th>

JAL at 00:26, 28 January 2014

2014-01-28T00:26:31Z

← Older revision		Revision as of 00:26, 28 January 2014
Line 8:		Line 8:
	Storage and manipulation of Large Objects (LOBs) differs greatly depending on whether <var>[[FILEORG parameter\|FILEORG]]</var> X'100' is set.		Storage and manipulation of Large Objects (LOBs) differs greatly depending on whether <var>[[FILEORG parameter\|FILEORG]]</var> X'100' is set.

	:[[Table E non x'100' (File architecture)\|Table E without FILEORG X'100']]		:[[Table E and non-FILEORG X'100' files (File architecture)\|Table E without FILEORG X'100']]

	:[[Table E FILEORG x'100' (File architecture)\|Table E with FILEORG X'100']]		:[[Table E and FILEORG X'100' files (File architecture)\|Table E with FILEORG X'100']]

	<p>Regardless of the <var>FILEORG</var> setting, an individual LOB occurrence may be up to 2 GB. The maximum [[ESIZE parameter\|size of Table E]] is 1,073,741,823 pages.</p>		<p>Regardless of the <var>FILEORG</var> setting, an individual LOB occurrence may be up to 2 GB. The maximum [[ESIZE parameter\|size of Table E]] is 1,073,741,823 pages.</p>

JAL at 23:38, 27 January 2014

2014-01-27T23:38:40Z

← Older revision		Revision as of 23:38, 27 January 2014
Line 1:		Line 1:
	<span class="pageSubtitle">Holds Large Object data (BLOBs and CLOBs)</span>		<span class="pageSubtitle">Holds Large Object data (BLOBs and CLOBs)</span>

	Table E is enabled by reorganizing/[[CREATE command: File\|~~CREATE~~]]~~ing~~ a file with <var>[[ESIZE parameter\|ESIZE]]</var> greater than 0, and then [[DEFINE FIELD command\|defining a field]] with a data type of [[Field design (File management)#BLOB.2C CLOB and MINLOBE attributes\|CLOB or BLOB]] (the file must have an <var>ESIZE</var> ~~set~~ for the latter to occur).		Table E is enabled by reorganizing/[[CREATE command: File\|creating]] a file with <var>[[ESIZE parameter\|ESIZE]]</var> greater than 0, and then [[DEFINE FIELD command\|defining a field]] with a data type of [[Field design (File management)#BLOB.2C CLOB and MINLOBE attributes\|CLOB or BLOB]] (the file must have a non-zero <var>ESIZE</var> value for the latter to occur).

	Table E is available as of Model 204 V7.1		Table E is available as of Model 204 V7.1

	==Summary==		==Summary==
	Storage and manipulation of Large Objects (LOBs) differs greatly depending on whether <var>[[FILEORG parameter\|FILEORG]]</var> x'100' is set.		Storage and manipulation of Large Objects (LOBs) differs greatly depending on whether <var>[[FILEORG parameter\|FILEORG]]</var> X'100' is set.

	:[[Table E non x'100' (File architecture)\|Table E without FILEORG X'100']]		:[[Table E non x'100' (File architecture)\|Table E without FILEORG X'100']]
Line 12:		Line 12:
	:[[Table E FILEORG x'100' (File architecture)\|Table E with FILEORG X'100']]		:[[Table E FILEORG x'100' (File architecture)\|Table E with FILEORG X'100']]

	<p>Regardless of the <var>FILEORG</var> setting, an individual LOB occurrence may be up to 2 Gb. The maximum [[ESIZE parameter\|size of Table E]] is 1,073,741,823 pages.</p>		<p>Regardless of the <var>FILEORG</var> setting, an individual LOB occurrence may be up to 2 GB. The maximum [[ESIZE parameter\|size of Table E]] is 1,073,741,823 pages.</p>

	==Table E differences without or with the X'100' setting==		==Table E differences without or with the X'100' setting==

JAL: /* Table E differences without or with the X'100' setting */

2014-01-27T18:40:26Z

Table E differences without or with the X'100' setting

← Older revision		Revision as of 18:40, 27 January 2014
Line 22:		Line 22:
	<th align="center">X'100' </th></tr>		<th align="center">X'100' </th></tr>

	<tr><th>General space management</th>		<tr><th nowrap>General space management</th>
	<td>LOBs require contiguous space.		<td>LOBs require contiguous space.
	<p>		<p>
Line 40:		Line 40:
	<td>There is a 27-byte pointer in the record on Table B / X for every occurrence of every LOB.<br/> <br/>There are 4 bytes reserved on every page in Table E for the chaining of LOBs. </td></tr>		<td>There is a 27-byte pointer in the record on Table B / X for every occurrence of every LOB.<br/> <br/>There are 4 bytes reserved on every page in Table E for the chaining of LOBs. </td></tr>

	<tr><th ~~nowrap~~>Storing small amounts of <br>		<tr><th>Storing small amounts of <br>
	data in a LOB field</th>		data in a LOB field</th>
	<td>Even a single byte of data requires a full page of Table E. </td>		<td>Even a single byte of data requires a full page of Table E. </td>
Line 56:		Line 56:
	<td>Used to defragment Table E to increase the amount of contiguous space. </td>		<td>Used to defragment Table E to increase the amount of contiguous space. </td>

	<td>The <var>[[COMPACTE command\|COMPACTE]]<var> command is not necessary, and attempts to execute it will generate an error. </td></tr>		<td>The <var>[[COMPACTE command\|COMPACTE]]</var> command is not necessary, and attempts to execute it will generate an error. </td></tr>
	</table>		</table>

	[[Category:File architecture]]		[[Category:File architecture]]

JAL at 18:38, 27 January 2014

2014-01-27T18:38:25Z

@@ Line 1: / Line 1: @@
-Holds Large Object Data (BLOBs and CLOBs)
+<span class="pageSubtitle">Holds Large Object data (BLOBs and CLOBs)</span>
-Enabled by reorganizing / [[CREATE command: File|CREATE]]ing a file with [[ESIZE parameter|ESIZE]] greater than 0, and then [[DEFINE FIELD command|defining a field]] with a data type of [[Field design (File management)#BLOB.2C CLOB and MINLOBE attributes|CLOB or BLOB]] (the file must have an ESIZE for the latter to occur).
+<p>Regardless of the <var>FILEORG</var> setting, an individual LOB occurrence may be up to 2 Gb. The maximum [[ESIZE parameter|size of Table E]] is 1,073,741,823 pages.</p>
-Available as of Model 204 V7.1
+==Table E differences without or with the X'100' setting==
-==Summary==
+<table class="thJustBold" style="width:90%">
-Storage and manipulation of Large Objects (LOBs) differs greatly depending on whether [[FILEORG parameter|FILEORG]] x'100' is set.
+<tr><th>General space management</th>
-:[[Table E non x'100' (File architecture)|Table E without FILEORG x'100']]
+<td>LOBs are stored as a series of chained pages, and new LOBs are written first using those in the reuse queue (due to deletes).
-:[[Table E FILEORG x'100' (File architecture)|Table E with FILEORG x'100']]
+<tr><th nowrap>Storing small amounts of <br>
-<p>Regardless of the FILEORG setting, an individual LOB occurrence may be up to 2 Gb. The maximum [[ESIZE parameter|size of Table E]] is 1,073,741,823 pages.</p>
+<td>Fields can be defined with the <var>[[Field design (File management)#BLOB.2C CLOB and MINLOBE_attributes|MINLOBE]]</var> attribute to permit small amounts of data to be stored directly in the record in Table B. <var>MINLOBE</var> can be set up to 200 bytes. </td></tr>
-== Table E Differences Without / With the x'100' Setting ==
+<td>LOBs may be changed as needed (on adds and stores, the <var>RESERVE</var>, if present, is ignored).
-{| class="wikitable";style="width="90%
+<td>The <var>[[COMPACTE command|COMPACTE]]<var> command is not necessary, and attempts to execute it will generate an error. </td></tr>
-|-
+</table>
 [[Category:File architecture]]

Admin: Admin moved page Table E (File Architecture) to Table E (File architecture)

2014-01-23T17:06:56Z

Admin moved page Table E (File Architecture) to Table E (File architecture)

← Older revision	Revision as of 17:06, 23 January 2014
(No difference)

JAL at 21:04, 2 January 2014

2014-01-02T21:04:41Z

← Older revision		Revision as of 21:04, 2 January 2014
Line 37:		Line 37:
	\|-		\|-
	! scope="row"\| Change a LOB		! scope="row"\| Change a LOB
	\| At the time a LOB is first stored, if you expect to subsequently need to increase its size, you will need to RESERVE the necessary space in the initial [[~~Data_Maintenance~~#~~ADD_statement~~\|add]].		\| At the time a LOB is first stored, if you expect to subsequently need to increase its size, you will need to RESERVE the necessary space in the initial [[Data maintenance#ADD statement\|add]].
	\| LOBs may be changed as needed (on adds and stores, the RESERVE, if present, is ignored). <br/>		\| LOBs may be changed as needed (on adds and stores, the RESERVE, if present, is ignored). <br/>
	Change statements are not permitted if MINLOBE is in use. (A delete / add or insert can be used.)		Change statements are not permitted if MINLOBE is in use. (A delete / add or insert can be used.)
Line 45:		Line 45:
	\| The [[COMPACTE command]] is not necessary, and attempts to execute it will generate an error.		\| The [[COMPACTE command]] is not necessary, and attempts to execute it will generate an error.
	\|}		\|}










	[[Category:File architecture]]		[[Category:File architecture]]

← Older revision		Revision as of 00:26, 28 January 2014
Line 8:		Line 8:
	Storage and manipulation of Large Objects (LOBs) differs greatly depending on whether <var>[[FILEORG parameter\|FILEORG]]</var> X'100' is set.		Storage and manipulation of Large Objects (LOBs) differs greatly depending on whether <var>[[FILEORG parameter\|FILEORG]]</var> X'100' is set.

	:[[Table E non x'100' (File architecture)\|Table E without FILEORG X'100']]		:[[Table E and non-FILEORG X'100' files (File architecture)\|Table E without FILEORG X'100']]

	:[[Table E FILEORG x'100' (File architecture)\|Table E with FILEORG X'100']]		:[[Table E and FILEORG X'100' files (File architecture)\|Table E with FILEORG X'100']]

	<p>Regardless of the <var>FILEORG</var> setting, an individual LOB occurrence may be up to 2 GB. The maximum [[ESIZE parameter\|size of Table E]] is 1,073,741,823 pages.</p>		<p>Regardless of the <var>FILEORG</var> setting, an individual LOB occurrence may be up to 2 GB. The maximum [[ESIZE parameter\|size of Table E]] is 1,073,741,823 pages.</p>