Indexed File Size Limits

The following file size limits affect indexed files. The default (where IDXFORMAT=0) is IDXFORMAT 8.

To create files of a different format, use the IDXFORMAT extfh.cfg or compiler directive setting. To convert existing files to other formats, use the Rebuild utility.

IDXFORMAT	Exclusive (#)	Exclusive with duplicate key compression on	Shared with default locking	FILEMAXSIZE set to
1	4 Gb	2 Gb	1 Gb	4 or 8
2	4 Gb	2 Gb	1 Gb	4 or 8
3	4 Gb	2 Gb	1 Gb	4 or 8
4	4 Gb	2 Gb	1 Gb	4 or 8
8 and 12	4 Gb	2 Gb	1 Gb	4
8 and 12	256 Tb	128 Tb	256 Tb	8

where:

(#) = either accessing files exclusively or accessing shared files with the extfh.cfg or compiler directive setting of LOCKTYPE 1 or 2. That is, file size is not affected when using LOCKTYPE 1 or 2.
FILEMAXSIZE is an extfh.cfg setting that defaults to 8

For IDXFORMAT 8 or IDXFORMAT 12 files only, if you increase the extfh.cfg setting FILEPOINTERSIZE to 8, you increase file size limits to:

IDXFORMAT	Exclusive (#)	Exclusive with duplicate key compression on	Shared with default locking	FILEMAXSIZE set to
8 and 12	16 Eb	8 Eb	4 Eb	8

Note:

The above figures are determined by the pointer size used to address the file. For example:

32 bits	=	2^32	=	4,294,967,296 bytes	=	4 Gb (Gigabytes)
48 bits	=	2^48	=	281,474,976,710,656 bytes	=	256 Tb (Terabytes)
64 bits	=	2^64	=	18,446,744,073,709,551,616 bytes	=	16 Eb (Exabytes or MegaTerabytes)

LOCKTYPE settings of 1 and 2 were specifically introduced in order to avoid the file size limit imposed by sharing files.
If you set FILEMAXSIZE to 8, IDXFORMAT 8 and IDXFORMAT 12 both support very large files with the default locking mechanism. Therefore, you are recommended to use IDXFORMAT 8 or IDXFORMAT 12 for large files rather than any of the other formats which also require LOCKTYPE 1 or 2 for large files. (LOCKTYPE=1 has the disadvantage of not allowing locked data to be read at all while LOCKTYPE=2 has the disadvantage of using up an extra file handle for the .LCK file that contains the locks).