20.1.6 File sizes required for the execution of the dictionary import/export utility (pdexp)

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

File typeFormula (bytes)
Export fileBase table0.8 + 0.4 [Figure] (a + b) + (0.8 + 0.1 [Figure] c) [Figure] d + 0.1 [Figure] f
View table0.5 + 0.4 [Figure] a + e
Procedure1.0 + 0.1 [Figure] 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.