The following table shows the formulas for determining the file sizes required for the execution of the dictionary import/export utility (pdexp):

File type		Formula (bytes)
Export file	Base table	0.8 + 0.4 (a + b) + (0.8 + 0.1 c) d + 0.1 f
	View table	0.5 + 0.4 a + e
	Procedure	1.0 + 0.1 g + h

a: Number of columns in table to be exported

b: Number of partitioning conditions for table to be exported

c: Number of index storage RDAREAs defined for table to be exported

d: Number of indexes defined for table to be exported

e: Length of the source during view table definition (KB)

f: If a LOB column is defined in the table to be exported, this is the number of user LOB RDAREAs storing the LOB data.

g: Number of resources used by a stored procedure that is exported^*

This is the value of the N_RESOURCE column in the SQL_ROUTINES table.

h: Length of the source of a stored procedure (KB)

This is the value of the SOURCE_SIZE column in the SQL_ROUTINES table.

^* If exporting multiple tables, determine the previously described sizes for each table. The sum of the sizes obtained is the size of the export file.