20.2.11 Memory size required for the execution of the dictionary import/export utility (pdexp)

The following tables show the formulas for determining the memory size required for the execution of the dictionary import/export utility (pdexp).

Organization of this subsection
(1) HiRDB/Single Server
(2) HiRDB/Parallel Server

(1) HiRDB/Single Server

LocationTypeValue (KB)
Single serverExporting table definition information11600
Importing table definition information10500 + 0.4 [Figure] (a + b) + 0.1 [Figure] c
Exporting procedure11600 + d
Importing procedure10500 + 0.1 [Figure] e
Utility special unitExporting table definition information5000
Importing table definition information6400 + 0.4 [Figure] (a + b) + 0.1 [Figure] c
Exporting procedure5000 + d
Importing procedure6400 + 0.1 [Figure] e
a: Number of columns in the table to be imported
b: Number of partitions for the table to be imported
c: If a LOB column is defined for the table being imported, number of LOB RDAREAs containing LOB data
d: Length of source of stored procedure1 (KB)
e: Number of resources used by stored procedure being imported2
1 Value of the SOURCE_SIZE column in the SQL_ROUTINES table.
2 Value of the N_RESOURCE column in the SQL_ROUTINES table.

(2) HiRDB/Parallel Server

LocationTypeValue (KB)
MGR4100
DSExporting table definition information7500
Importing table definition information6400 + 0.4 [Figure] (a + b) + 0.1 [Figure] c + 0.25 [Figure] f
Exporting procedures7500 + d
Importing procedures6400 + 0.1 [Figure] e
BESExporting table definition information7600
Importing table definition information6500 + 0.4 [Figure] (a + b) + 0.1 [Figure] c + 0.25 [Figure] f
Exporting procedures7600 + d
Importing procedures6500 + 0.1 [Figure] e
a: Number of columns in table to be imported
b: Number of partitions for the table to be imported
c: If a LOB column is defined for the table being imported, number of LOB RDAREAs containing LOB data
d: Length of source of stored procedure1 (KB)
e: Number of resources used by stored procedure being imported2
f: Number of partitions with boundary value specified for the table being imported
1 Value of the SOURCE_SIZE column in the SQL_ROUTINES table.
2 Value of the N_RESOURCE column in the SQL_ROUTINES table.