19.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.7 + 0.5 x CMN + (0.1 x[Figure]CMN[Figure] 10[Figure])
DEF
+ [Figure](0.1 + DSn) + 0.1 x[Figure]LRD[Figure] 10[Figure]
n = 1
+ 0.6 x[Figure]DIV[Figure] 10[Figure] + 0.7 x REF
CHK
+ [Figure](0.1 + 1.0 x[Figure]CSn[Figure] 10[Figure])
n = 1
IDX
+ [Figure](0.7 + 0.2 x IRn)
n = 1
View table0.6 + 0.4 x CMN + (0.1 x[Figure]CMN[Figure] 10[Figure]) + e
Procedure0.6 + 0.1 x g + h
CHK: Number of check constraints (0 [Figure] CHK[Figure] 254)
CMN: Number of table columns (1 [Figure] CMN[Figure] 30,000)
CSn: Size of search conditions of nth check constraint (0 [Figure] CSn[Figure] 2,000,000)
DEF: Number of default value definition columns (0 [Figure] DEF[Figure] 30,000)
DIV: Number of partition conditions (0 [Figure] DIV[Figure] 4,096)
DSn: Default size of nth default column (1 [Figure] DSn[Figure] 64,003)
IDX: Number of indexes (0 [Figure] IDX[Figure] 254)
IRn: Number of RDAREAs for storing nth index (0 [Figure] IRn[Figure] 4,096)
LRD: Number of LOB RDAREAs (0 [Figure] LRD[Figure] 4,096)
REF: Number of reference constraints (0 [Figure] REF[Figure] 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.