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.7 + 0.5 CMN + (0.1 CMN 10) DEF + (0.1 + DSn) + 0.1 LRD 10 n = 1 + 0.6 DIV 10 + 2.8 REF CHK + (0.1 + 1.0 CSn 10) n = 1 IDX + (2.7 + 0.2 IRn) n = 1
	View table	0.6 + 0.4 CMN + (0.1 CMN 10) + e
	Procedure	0.6 + 0.1 g + h

CHK: Number of check constraints (0 CHK 254)

CMN: Number of table columns (1 CMN 30,000)

CSn: Size of search conditions of nth check constraint (0 CSn 2,000,000)

DEF: Number of default value definition columns (0 DEF 30,000)

DIV: Number of partition conditions (0 DIV 4,096)

DSn: Default size of nth default column (1 DSn 64,003)

IDX: Number of indexes (0 IDX 254)

IRn: Number of RDAREAs for storing nth index (0 IRn 4,096)

LRD: Number of LOB RDAREAs (0 LRD 4,096)

REF: Number of reference constraints (0 REF 255)

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

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.