Table A-1 shows the memory requirements for HiRDB Dataextractor. The required memory is allocated in the local memory.

Table A-1 Memory requirements for HiRDB Dataextractor

Type	Process	Procedure size (KB)	Dynamic memory size (KB)	Variables
HiRDB	Extraction process	250	24 + 32 x 2 + B x 2 + 0.15 x C	B: Length of extracted data C: Number of extracted columns
	Import process	200	16 + 32 x 2 + 0.1 x C
XDM/XT	HiRDB extraction process	850	24 + 32 x 2 + B x 2 + 0.15 x C	B: Length of extracted data C: Number of extracted columns
	HiRDB import process	850	180 + 12 x L	L: Number of LOAD JXUMCTL control statements specified
File creation	Extraction process	250	24 + 32 x 2 + B x 2 + 0.15 x C	B: Length of extracted data C: Number of extracted columns
	File creation process	650	16 + 32 x 4

HiRDB

Importing extracted data into HiRDB or creating a file from extracted data and then importing it into HiRDB.

XDM/XT

Data extraction and import between a mainframe database and HiRDB using XDM/XT.

File creation

Data extraction from HiRDB followed by file creation, or file creation from data extracted from a mainframe database using XDM/XT.

The formula for determining the size of an output file depends on the value of the XTNLDFLT environment variable.

Table A-2 presents the formulas for determining file size.

Table A-2 Determining file size

Type of file			Formula (bytes)
Output file	Import to HiRDB or creation of binary file	When the value of XTNLDFLT environment variable is 0 or 11	c { (column-data-length-i4)} x n i=1
		When the value of XTNLDFLT environment variable is 2	c { (column-data-length-i4) + 4 x (c + 1)} x n i=1
	Creation of DAT file2		c { (maximum-length-of-character-conversion-for-column-i5)} x n i=1
LOB input file3			LOB-data-length6

n: Number of rows

c: Number of column definitions

¹ If 0 is specified in the XTLOBKIND environment variable, a LOB input file is created separately.

² If there is an SGMLTEXT or BLOB column, a LOB input file is created separately.

³ A LOB input file is created for each column.

⁴ For details about the length of column data, see (4) Output file in 4.2.4 Contents of files specified with the xtrep command.

⁵ For the maximum length for a character conversion for a column, see the table below. In the case of repetition columns, you must take into account the number of elements. For details about the data format of repetition columns during creation of a DAT file, see (6) Extracting repetition columns in 3.1.1 Extracting selected data.

Data type	Maximum length of character conversion (bytes)
INTEGER	11
SMLLINT	6
DECIMAL	31
FLOAT	24
SMALLFLT	23
CHAR	Defined length + 2
VARCHAR	Real length + 2
NCHAR	Defined length x 2 + 2
NVARCHAR	Real length + 2
MCHAR	Defined length + 2
MVARCHAR	Real length + 2
DATE	10
TIME	8
INTERVAL YEAR TO DAY	10
INTERVAL HOUR TO SECOND	8
BLOB	Maximum length of absolute path name of LOB input file
SGMLTEXT	Maximum length of absolute path name of LOB input file
BINARY	Real length + 2
TIMESTAMP	26

⁶ The maximum number of files is as follows:

Number of LOB data columns defined per row x number of rows