Scalable Database Server, HiRDB Version 8 Installation and Design Guide

19.2.13 Memory size required for the execution of the rebalancing utility (pdrbal)

(1) For a HiRDB/Single Server

Formula for determining memory size (KB)

87563 + 536 + 0.02 number of columns + 0.2 number of target RDAREAs + 1.7 number of source RDAREAs + 0.26 number of target RDAREAs number of indexes + (0.09 + average index statement file length 1024) number of index statements + (0.02 + average directory length 1024) (number of idxwork statements + number of sort statements) + (length of control information file + length of execution results file) 1024 + 0.05 number of columns + 0.05 number of RDAREAs + 0.15 number of indexes + 0.05 number of index storage RDAREAs + 550 1024 + size of work file for sorting1 -n option specified: + page length of RDAREA2 number of batch input/output buffer sectors y Applicable table containing LOB columns: + 64 + 0.01 number of LOB columns + 0.18 number of target RDAREAs + 0.09 number of source RDAREAs + 0.08 number of LOB storage RDAREAs When the target table contains BINARY columns: + 33 (number of BINARY columns number of target RDAREAs number of source RDAREAs) Applicable table containing an abstract data type provided by plug-in: + 40 + (0.27 + 2 length of abstract data type) number of abstract data-type columns + 0.3 number of unld_func statements + (128 + 0.11 number of LOB attributes + 0.1 number of functions specifying unld_func + 0.07 number of abstract data type attributes) number of abstract data-type columns + (33 number of BINARY attributes number of target RDAREAs number of source RDAREAs) 2 + 0.01 number of plug-in indexes + 0.19 number of unld_func statements + (average length of unld_func statements 1024 number of unld_func statements) + (average length of reld_func statements 1024 number of reld_func statements) + number of abstract data-type columns 1 + (number of LOB attributes 0.05) number of RDAREAs + number of data type plug-ins 10 + number of plug-in indexes 10 + memory required for plug-ins When the specified index creation method is the batch index creation mode or the index information output mode and the following condition is satisfied: Number of table partitions number of index definitions > maximum number of processes that can be open - 576 + 2048

y: Use one of the following values:

• When the rebalancing facility is used with a FIX hash-partitioned table
  (1024 number of storage RDAREAs for the entire table) number of table storage RDAREAs in the corresponding server
  
• Other than the above
  1
  

¹ Add this value during batch index creation (-ic specified or omitted).

² If the page length varies from one RDAREA to another for a row-partitioned table, use the longest page length for this calculation.

³ For the 64-bit mode, the value is 14272.

(2) For a HiRDB/Parallel Server

Condition	Formula for determining memory size (KB)
MGR	14983 + 2 + 0.05 number of columns + 0.05 number of RDAREAs + 0.15 number of indexes + 0.05 number of index storage RDAREAs + (0.09 + average index statement file length 1024) number of index statements) + (0.02 + average directory length 1024) (number of idxwork statements + number of sort statements) + (length of control information file + length of execution results file) 1024 Applicable table containing LOB columns: + 0.08 number of LOB storage RDAREAs Applicable table containing an abstract data type provided by plug-in: + 0.19 number of unld_func statements + (average length of unld_func statement 1024 number of unld_func statements) + (average length of reld_func statement 1024 number of reld_func statements)
DS	14554 + 32 + 0.33 number of target BESs + 0.3 number of source BESs + 0.2 number of target RDAREAs + 0.22 number of source RDAREAs + 0.34 number of FESs + (0.09 + average index statement file length 1024) number of index statements + (0.02 + average directory length 1024) (number of idxwork statements + number of sort statements) + 0.05 number of columns + 0.05 number of RDAREAs + 0.15 number of indexes + 0.05 number of index storage RDAREAs Applicable table containing LOB columns: + 0.08 number of LOB storage RDAREAs When the target table contain BINARY columns: + 33 (number of BINARY columns number of target RDAREAs number of source RDAREAs) Applicable table containing an abstract data type provided by plug-in: + 0.01 number of target BESs + 0.19 number of unld_func statements + (average length of unld_func statements 1024 number of unld_func statements) + (average length of reld_func statements 1024 number of reld_func statements) + number of abstract data type columns 1 + (number of LOB attributes 0.05) number of RDAREAs + number of data type plug-ins 10 + number of plug-in indexes 10
BES	66015 + 50 + (517 + 0.01 number of columns) number of target BESs + (33 + 0.01 number of columns) number of source BESs + 0.2 number of target RDAREAs + 1.7 number of source RDAREAs + 0.01 number of columns + 0.26 number of target RDAREAs number of indexes + (0.09 + average index statement file length 1024) number of index statements + (0.02 + average directory length 1024) (number of idxwork statements + number of sort statements) + 0.05 number of columns + 0.05 number of RDAREAs + 0.15 number of indexes + 0.05 number of index storage RDAREAs + 550 1024 + size of work file for sorting1 -n option specified: + page length of RDAREA2 number of batch input/output buffer sectors y Applicable table containing LOB columns: + 32 + 0.01 number of LOB columns + (32 + 0.01 number of LOB columns) number of target BESs + 0.18 number of target RDAREAs + 0.1 number of source RDAREAs + 0.08 number of LOB storage RDAREAs When the target table contain BINARY columns: + 33 (number of BINARY columns number of target RDAREAs number of source RDAREAs) When the target table contains abstract data types provided by plug-ins: + 40 + (0.27 + 2 length of abstract data type) number of abstract data-type columns + 0.3 number of unld_func statements + {(64 + 0.05 number of LOB attributes) number of abstract data-type columns} number or target BESs + {(64 + 0.01 number of functions specifying unld_func + 0.07 number of abstract data type attributes + 0.05 number of LOB attributes) number of abstract data-type columns} number of source BESs + (33 number of BINARY attributes number of target RDAREAs number of source RDAREAs) 2 + 0.01 number of plug-in indexes + 0.19 number of unld_func statements + (average length of unld_func statements 1024 number of unld_func statements) + (average length of reld_func statements 1024 number of reld_func statements) + number of abstract data-type columns 1 + (number of LOB attributes 0.05) number of RDAREAs + number of data type plug-ins 10 + number of plug-in indexes 10 + memory required for plug-ins When the specified index creation method is the batch index creation mode or the index information output mode and the following condition is satisfied: Number of table partitions number of index definitions > maximum number of processes that can be open - 576 + 2048

y: Use one of the following values:

• When the rebalancing facility is used for FIX hash partitioning tables
  (1024 number of storage RDAREAs for the entire table) number of table storage RDAREAs in the corresponding server
  
• Other than the above
  1
  

¹ Add this value during batch index creation (-ic specified or omitted).

² If the page length varies from one RDAREA to another for a row-partitioned table, use the longest page length for this calculation.

³ For the 64-bit mode, the value is 4660.

⁴ For the 64-bit mode, the value is 15830.

⁵ For the 64-bit mode, the value is 11804.

[Contents][Back][Next]

[Trademarks]

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