Nonstop Database, HiRDB Version 9 Installation and Design Guide

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

17.1.2 Amount of system log information output during table definition

The formulas used to obtain the amount of system log information that is output during table definition are presented as follows.

Organization of this subsection
(1) HiRDB/Single Server
(2) HiRDB/Parallel Server

(1) HiRDB/Single Server

Condition Amount of system log information (bytes)
Table not partitioned ((1,256 x b + 2,500) x 1.2) x a + (632 x a x d)#
Table partitioned ((1,256 x b + 1,800 x c + 2,500) x 1.2) x a + (632 x a x d)#

a: Total number of tables to be defined

b: Average number of columns in tables to be defined

c: Average number of partitions in tables to be defined

d: Number of RDAREAs for storing LOB columns

#: Add this value if a LOB column is defined in any of the tables.

(2) HiRDB/Parallel Server

Condition Amount of system log information (bytes)
Amount of system log information output by dictionary server ((1,256 x b + 1,800 x c + 2,500) x 1.2) x a
Amount of system log information output by back-end server 912 x a x d + (632 x a x e)#

a: Total number of tables to be defined

b: Average number of columns in tables to be defined

c: Average number of partitions in tables to be defined

d: Number of partitions in the back-end server for tables to be defined

e: Number of RDAREAs for storing LOB columns in the back-end server

#: Add this value if a LOB column is defined in any of the tables that are defined in the back-end server.

[Contents][Back][Next]

[Trademarks]

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