Nonstop Database, HiRDB Version 9 Installation and Design Guide

[Contents][Index][Back][Next]

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 configuration
(2) HiRDB parallel server configuration
(3) Variables used in the formula

(1) HiRDB single server configuration

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

(2) HiRDB parallel server configuration

Conditions Memory required by formula (KB)
32-bit mode MGR 1,714 + 6.7 [Figure] [Figure]CTL [Figure] 100[Figure] + 0.07 [Figure] CTL
Host with export file 4,907 + 0.07 [Figure] CTL + 0.11 [Figure] CHK + 1.5 [Figure] FKY + CSZ + 0.5 [Figure] CMN + 0.01 [Figure] (CHK + FKY + CMN + DIV + 10) + 0.6 [Figure] DIV + DEF + 0.06 [Figure] LOB + 0.2 [Figure] TBL + SQL+ 8,791
64-bit mode MGR 2,016 + 6.7 [Figure] [Figure]CTL [Figure] 100[Figure] + 0.07 [Figure] CTL
Host with export file 5,293 + 0.07 [Figure] CTL + 0.11 [Figure] CHK + 1.5 [Figure] FKY + CSZ + 0.5 [Figure] CMN + 0.01 [Figure] (CHK + FKY + CMN + DIV + 10) + 0.6 [Figure] DIV + DEF + 0.06 [Figure] LOB + 0.2 [Figure] 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)

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2012, 2015, Hitachi, Ltd.