Scalable Database Server, HiRDB Version 8 Installation and Design Guide

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

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

Location Type Value (KB)
Single server Exporting table definition information 11600
Importing table definition information 10500 + 0.4 [Figure] (a + b) + 0.1 [Figure] c
Exporting procedure 11600 + d
Importing procedure 10500 + 0.1 [Figure] e
Utility special unit Exporting table definition information 5000
Importing table definition information 6400 + 0.4 [Figure] (a + b) + 0.1 [Figure] c
Exporting procedure 5000 + d
Importing procedure 6400 + 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

Location Type Value (KB)
MGR 4100
DS Exporting table definition information 7500
Importing table definition information 6400 + 0.4 [Figure] (a + b) + 0.1 [Figure] c + 0.25 [Figure] f
Exporting procedures 7500 + d
Importing procedures 6400 + 0.1 [Figure] e
BES Exporting table definition information 7600
Importing table definition information 6500 + 0.4 [Figure] (a + b) + 0.1 [Figure] c + 0.25 [Figure] f
Exporting procedures 7600 + d
Importing procedures 6500 + 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.

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.