Scalable Database Server, HiRDB Version 8 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
(2) HiRDB/Parallel Server

(1) HiRDB/Single Server

Location Type Value (KB)
Single server Exporting table definition information 17302
Importing table definition information 17318 + 0.4 [Figure] (a + b) + 0.1 [Figure] c
Exporting procedure 17302 + d
Importing procedure 17318 + 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 4067
DS Exporting table definition information 17043
Importing table definition information 16139 + 0.4 [Figure] (a + b) + 0.1 [Figure] c + 0.25 [Figure] f
Exporting procedure 17043 + d
Importing procedure 16139 + 0.1 [Figure] e
BES Exporting table definition information 5142
Importing table definition information 5142 + 0.4 [Figure] (a + b) + 0.1 [Figure] c + 0.25 [Figure] f
Exporting procedure 5142 + d
Importing procedure 5142 + 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.