19.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
(3) Variables used in the formula

(1) HiRDB/Single Server

ConditionsMemory required by formula (KB)
32-bit modeSDS1,307 + 6.7 x[Figure]CTL[Figure] 100[Figure] + 0.07 x CTL
Host with export file4,499 + 0.07 x CTL + 0.11 x CHK + 1.5 x FKY + CSZ + 0.5 x CMN + 0.01 x (CHK + FKY + CMN + DIV + 10) + 0.6 x DIV + DEF + 0.06 x LOB + 0.2 x TBL + SQL+ 8,791
64-bit modeSDS1,494 + 6.7 x[Figure]CTL[Figure] 100[Figure] + 0.07 x CTL
Host with export file4,582 + 0.07 x CTL + 0.11 x CHK + 1.5 x FKY + CSZ + 0.5 x CMN + 0.01 x (CHK + FKY + CMN + DIV + 10) + 0.6 x DIV + DEF + 0.06 x LOB + 0.2 x TBL + SQL+ 8,791

(2) HiRDB/Parallel Server

ConditionsMemory required by formula (KB)
32-bit modeMGR1,714 + 6.7 x[Figure]CTL[Figure] 100[Figure] + 0.07 x CTL
Host with export file4,907 + 0.07 x CTL + 0.11 x CHK + 1.5 x FKY + CSZ + 0.5 x CMN + 0.01 x (CHK + FKY + CMN + DIV + 10) + 0.6 x DIV + DEF + 0.06 x LOB + 0.2 x TBL + SQL+ 8,791
64-bit modeMGR2,016 + 6.7 x[Figure]CTL[Figure] 100[Figure] + 0.07 x CTL
Host with export file5,293 + 0.07 x CTL + 0.11 x CHK + 1.5 x FKY + CSZ + 0.5 x CMN + 0.01 x (CHK + FKY + CMN + DIV + 10) + 0.6 x DIV + DEF + 0.06 x LOB + 0.2 x TBL + SQL+ 8,791

(3) Variables used in the formula

CMN: Number of columns
CHK: Number of check constraints
CSZ: Total size of search conditions of check constraint (CHK_SOURCE_LEN value in SQL_TABLES table) (bytes)
CTL: Number of controls specified in control statement file
DEF: Maximum definition length of DEFAULT clause (bytes)
DIV: Number of partition conditions
FKY: Number of foreign keys
LOB: Number of LOB storage RDAREAs
SQL: Memory required to use the following SQL statements:
  • For table export/import: CREATE TABLE statement
  • For procedure export/import: CREATE PROCEDURE statement
  • For trigger import/export: CREATE TRIGGER statement
For details about these memory requirements, see 15.1.6 Formulas for size of memory required during SQL execution and 15.1.7 Formula for size of memory required during SQL preprocessing.
TBL: Number of tables, procedures and triggers actually imported or exported (for procedures and triggers, the same as CTL)