Scalable Database Server, HiRDB Version 8 Installation and Design Guide

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

17.3 Determining the size of status files

Organization of this section
(1) Determining the size of a status file
(2) Determining the number of records in a status file
(3) Determining the value of S

(1) Determining the size of a status file

The following formula is used to determine the size of a status file.

Formula
Size of status file (bytes) = a [Figure] b

a: Number of records in the status file.
See (2) as follows; the obtained value is specified in the -c option of the pdstsinit command.

b: Record length of the status file. This value is specified in the -l option of the pdstsinit command.

(2) Determining the number of records in a status file

The following formula is used to determine the number of records in a status file.

Formula
Number of records
= [Figure] {[Figure]S [Figure] (record length - 40)[Figure] + [Figure]S [Figure] 100[Figure] + S + 2} [Figure] 1.2[Figure]

See (3) as follows for the value of S.

(3) Determining the value of S

(a) HiRDB/Single Server
Type Formula for S
Unit [Figure](2056 + 128 [Figure] d) [Figure] g[Figure] + [Figure]2512 [Figure] g[Figure] + [Figure]40 [Figure] g[Figure]
+ [Figure]308 [Figure] g[Figure] + [Figure]32 [Figure] g[Figure] + [Figure]4000 [Figure] g[Figure]
Server [Figure]128 [Figure] g[Figure] + [Figure]32801 [Figure] g[Figure] + [Figure](5922 + j [Figure] b) [Figure] g[Figure]
+ [Figure]8192 [Figure] g[Figure] + [Figure](8192 - 128) [Figure] g[Figure] [Figure] {((a + m) [Figure] k) - 1}
+ [Figure][[Figure]{([Figure]c [Figure] 127[Figure] + 1) [Figure] 2048} [Figure] 8192[Figure] [Figure] 8192] [Figure] g[Figure]
+ [Figure]2048 [Figure] g[Figure] + [Figure]{244 + 64 [Figure] (2 [Figure] h + 7)} [Figure] g[Figure]
+ [Figure]96 [Figure] g[Figure] + [Figure]{48 + 68 [Figure] (2 [Figure] h + 7)} [Figure] g[Figure]
+ [Figure]{8192 + [Figure](e [Figure] 98 [Figure] 8192)[Figure] [Figure] 8192 + [Figure](f [Figure] 80 [Figure] 8192)[Figure] [Figure] 8192} [Figure] g[Figure]
+ [Figure](8 [Figure] c + 4) [Figure] g[Figure] + [Figure]256 [Figure] g[Figure]
+ w
[Figure] If the status file record length < 4096, add:
+ [Figure]MAX{3400 [Figure] r + 0.7,1}[Figure] [Figure] MAX([Figure]4096 [Figure] s[Figure],2) [Figure] n
+ [Figure]5662310 [Figure] r + 0.7[Figure] [Figure] MAX([Figure]4096 [Figure] s[Figure],2) [Figure] p
+ [Figure]MAX{MAX([Figure]51200 [Figure] t[Figure],1) [Figure] 8 + 0.7,1}[Figure] [Figure] MAX([Figure]4096 [Figure] s[Figure],2) [Figure] 8 [Figure] 2
[Figure] If 4096 [Figure] status file record length < 12288, add:
+ [Figure]MAX{(3400 [Figure] [Figure](s - 348) [Figure] 20[Figure]) + 0.7,1}[Figure] [Figure] n
+ [Figure](5662310 [Figure] [Figure](s - 348) [Figure] 20[Figure]) + 0.7[Figure] [Figure] p
+ [Figure]MAX{(MAX(u,1) [Figure] 8) + 0.7,1}[Figure] [Figure] 8 [Figure] 2
[Figure] If 12288 [Figure] status file record length, add:
+ [Figure]MAX{(3400 [Figure] [Figure](s - 876) [Figure] 20[Figure]) + 0.7,1}[Figure] [Figure] n
+ [Figure](5662310 [Figure] [Figure](s - 876) [Figure] 20[Figure]) + 0.7[Figure] [Figure] p
+ [Figure]MAX{(MAX(u,1) [Figure] 8) + 0.7,1}[Figure] [Figure] 8 [Figure] 2
[Figure] Add when the pd_log_auto_unload_path operand is specified.
+ [Figure]20848 [Figure] g[Figure]
[Figure] Add when the rapid system switchover facility and the standby-less system switchover facility are used.
+ [Figure](256 [Figure] i + 4096) [Figure] g[Figure]
[Figure] Add when Y is specified in the pd_dbbuff_modify operand.
+ v

a: Number of specified pdlogadfg operands

b: Number of specified pdlogadfg -d spd operands

c: Value of pd_max_rdarea_no operand

d: 90

e: Number of specified pdbuffer operands

f: Number of -i options specified in the pdbuffer operand

g: Record length of status file minus 40

h: Value of pd_max_users

i: Value of pd_max_rdarea_no operand

j: 736

k: 11

m: 1

n: If the number of RDAREAs in the server [Figure] 3400, the value is 1.
If 3401 [Figure] number of RDAREAs in the server [Figure] 6800, the value is 2.
If 6801 [Figure] number of RDAREAs in the server, the value is 3.

p: If the number of RDAREAs in the server [Figure] 10200, the value is 0.
If 10201 [Figure] number of RDAREAs in the server [Figure] 5672510, the value is 1.
If 5672511 [Figure] number of RDAREAs in the server [Figure] 11334820, the value is 2.
If 11334821 [Figure] number of RDAREAs in the server, the value is 3.

r: [Figure](s - 348) [Figure] 20[Figure] + [Figure]g [Figure] 20[Figure] [Figure] (MAX([Figure]4096 [Figure] s[Figure],2) - 1)

s: Status file record length

t: [Figure](s - 68) [Figure] 20[Figure] + [Figure](s - 44) [Figure] 20[Figure] [Figure] (MAX([Figure]4096 [Figure] s[Figure],2) - 1)

u: [Figure]51200 [Figure] {[Figure](s - 72) [Figure] 20[Figure]}[Figure]

v: In 32-bit mode: [Figure](24 + 28 [Figure] x + 32 + 112 [Figure] y) [Figure] g[Figure]
In 64-bit mode: [Figure](32 + 32 [Figure] x + 32 + 128 [Figure] y) [Figure] g[Figure]

x: Value of pd_max_add_dbbuff_shm_no operand

y: Value of pd_max_add_dbbuff_no operand

z: Value obtained by adding the pd_max_add_dbbuff_no operand value to the total number of -i options specified in the pdbuffer operand (if a value other than Y is specified in the pd_dbbuff_modify operand, 0 is used)

1 For the 64-bit mode, use a value of 3456.

2 For the 64-bit mode, use a value of 688.
(b) HiRDB/Parallel Server
Type Formula for S
Unit [Figure][2056 + 128 [Figure] {14 [Figure] (p + q) + (p + q + r)
+ (24 + s [Figure] 2 + q [Figure] 7 + r [Figure] 3 + p [Figure] 15 + 2)
+ (38 + (p + q + r) [Figure] 4 + z + d) + 3}] [Figure] j[Figure]
+ [Figure]944 [Figure] j[Figure] + [Figure]4816 [Figure] j[Figure] + [Figure]40 [Figure] j[Figure] + [Figure]372 [Figure] j[Figure]
+ [Figure]32 [Figure] j[Figure] + [Figure]4000 [Figure] j[Figure] + [Figure]43456 [Figure] j[Figure]
[Figure] If the unit contains the system manager, add:
+ [Figure](32 + 16 [Figure] number of units) [Figure] j[Figure]
+ [Figure] (72 + 24 [Figure] (the total number of units in the system - 1)) [Figure] j [Figure]
[Figure] If the standby-less system switchover (effects distributed) facility is used, add:
+ [Figure]{8192 + [Figure](f [Figure] 98 [Figure] 8192)[Figure] [Figure] 8192 + [Figure](g [Figure] 80 [Figure] 8192)[Figure] [Figure] 8192} [Figure] j[Figure]
Front-end server [Figure]128 [Figure] j[Figure] + [Figure]32801 [Figure] j[Figure] + [Figure](5922 + A [Figure] b) [Figure] j[Figure]
+ [Figure]8192 [Figure] j[Figure] + [Figure](8192 - 128) [Figure] j[Figure] [Figure] {[Figure](a + C) [Figure] B[Figure] - 1}
+ [Figure]8192 [Figure] j[Figure] + [Figure]2048 [Figure] j[Figure]
+ [Figure]{244 + 64 [Figure] (2 [Figure] e + 7)} [Figure] j[Figure] + [Figure]96 [Figure] j[Figure]
[Figure] Add when the pd_log_auto_unload_path operand is specified.
+ [Figure]20848 [Figure] j[Figure]
Dictionary server [Figure]128 [Figure] j[Figure] + [Figure]32801 [Figure] j[Figure] + [Figure](5922 + A [Figure] b) [Figure] j[Figure]
+ [Figure]8192 [Figure] j[Figure] + [Figure]8192 [Figure] j[Figure] [Figure] {[Figure](a + C) [Figure] B[Figure] - 1}
+ [Figure][[Figure]{([Figure]c [Figure] 127[Figure] + 1) [Figure] 2048} [Figure] 8192[Figure] [Figure] 8192] [Figure] j[Figure]
+ [Figure]2048 [Figure] j[Figure] + [Figure]{244 + 64 [Figure] (2 [Figure] h + 7)} [Figure] j[Figure] + [Figure]96 [Figure] j[Figure]
+ [Figure]{48 + 68 [Figure] (2 [Figure] h + 7)} [Figure] j[Figure]
+ [Figure]{8192 + [Figure](f [Figure] 98 [Figure] 8192)[Figure] [Figure] 8192 + [Figure](g [Figure] 80 [Figure] 8192)[Figure] [Figure] 8192} [Figure] j[Figure]
+ [Figure](8 [Figure] c + 4) [Figure] j[Figure]
+ H
[Figure] If the status file record length < 4096, add:
+ [Figure]MAX{3400 [Figure] D + 0.7,1}[Figure] [Figure] MAX([Figure]4096 [Figure] n[Figure],2)
+ [Figure]MAX{MAX([Figure]51200 [Figure] E[Figure],1) [Figure] 8 + 0.7,1}[Figure] [Figure] MAX([Figure]4096 [Figure] n[Figure],2) [Figure] 8 [Figure] 2
[Figure] If 4096 [Figure] status file record length < 12288, add:
+ [Figure]MAX{(3400 [Figure] [Figure](n - 348) [Figure] 20[Figure]) + 0.7,1}[Figure]
+ [Figure]MAX{(MAX(F,1) [Figure] 8) + 0.7,1}[Figure] [Figure] 8 [Figure] 2
[Figure] If 12288 [Figure] status file record length, add:
+ [Figure]MAX{(3400 [Figure] [Figure](n - 876) [Figure] 20[Figure]) + 0.7,1}[Figure]
+ [Figure]MAX{(MAX(F,1) [Figure] 8) + 0.7,1}[Figure] [Figure] 8 [Figure] 2
[Figure] Add when the system switchover facility is used.
+ [Figure](256 [Figure] c + 4096) [Figure] j[Figure]
[Figure] Add when the pd_log_auto_unload_path operand is specified.
+ [Figure]20848 [Figure] j[Figure]
[Figure] Add when HiRDB External Data Access is used.
+ [Figure]{128 [Figure] (v + w + 1)} [Figure] j[Figure]
[Figure] Add when Y is specified in the pd_dbbuff_modify operand.
+ G
Back-end server [Figure]128 [Figure] j[Figure] + [Figure]32801 [Figure] j[Figure] + [Figure](5922 + A [Figure] b) [Figure] j[Figure]
+ [Figure]8192 [Figure] j[Figure] + [Figure]8192 [Figure] j[Figure] [Figure] {[Figure](a + C) [Figure] B[Figure] - 1}
+ [Figure][[Figure]{([Figure]c [Figure] 127[Figure] + 1) [Figure] 2048} [Figure] 8192[Figure] [Figure] 8192] [Figure] j[Figure]
+ [Figure]2048 [Figure] j[Figure] + [Figure]{244 + 64 [Figure] (2 [Figure] i + 7)} [Figure] j[Figure] + [Figure]96 [Figure] j[Figure]
+ [Figure]{48 + 68 [Figure] (2 [Figure] i + 7)} [Figure] j[Figure] + [Figure](8 [Figure] c + 4) [Figure] j[Figure] + [Figure]256 [Figure] j[Figure]
+ [Figure]{8192 + [Figure](f [Figure] 98 [Figure] 8192)[Figure] [Figure] 8192 + [Figure](g [Figure] 80 [Figure] 8192)[Figure] [Figure] 8192} [Figure] j[Figure]4
+ H
[Figure] If the status file record length < 4096, add:
+ [Figure]MAX{3400 [Figure] D + 0.7,1}[Figure] [Figure] MAX([Figure]4096 [Figure] n[Figure],2) [Figure] k
+ [Figure]5662310 [Figure] D + 0.7[Figure] [Figure] MAX([Figure]4096 [Figure] n[Figure],2) [Figure] m
+ [Figure]MAX{MAX([Figure]51200 [Figure] E[Figure],1) [Figure] 8 + 0.7,1}[Figure] [Figure] MAX([Figure]4096 [Figure] n[Figure],2) [Figure] 8 [Figure] 2
[Figure] If 4096 [Figure] status file record length < 12288, add:
+ [Figure]MAX{(3400 [Figure] [Figure](n - 348) [Figure] 20[Figure]) + 0.7,1}[Figure] [Figure] k
+ [Figure](5662310 [Figure] [Figure](n - 348) [Figure] 20[Figure]) + 0.7[Figure] [Figure] m
+ [Figure]MAX{(MAX(F,1) [Figure] 8) + 0.7,1}[Figure] [Figure] 8 [Figure] 2
[Figure] If 12288 [Figure] status file record length, add:
+ [Figure]MAX{(3400 [Figure] [Figure](n - 876) [Figure] 20[Figure]) + 0.7,1}[Figure] [Figure] k
+ [Figure](5662310 [Figure] [Figure](n - 876) [Figure] 20[Figure]) + 0.7[Figure] [Figure] m
+ [Figure]MAX{(MAX(F,1) [Figure] 8) + 0.7,1}[Figure] [Figure] 8 [Figure] 2
[Figure] Add when the system switchover facility is used.
+ [Figure](256 [Figure] y + 4096) [Figure] j[Figure]
[Figure] Add when the pd_log_auto_unload_path operand is specified.
+ [Figure] 10608 [Figure] j [Figure]
[Figure] Add when HiRDB External Data Access is used.
+ [Figure]{128 [Figure] (t + u + 1)} [Figure] j[Figure]
[Figure] Add when Y is specified in the pd_dbbuff_modify operand.
+ G

a: Number of specified pdlogadfg operands

b: Number of specified pdlogadfg -d spd operands

c: Value of pd_max_rdarea_no operand

d: 3
For a HiRDB/Parallel Server on a single server machine, the value is 2.

e: value of pd_max_users operand + 1
However, if a HiRDB/Parallel Server is used with a single server machine, value of pd_max_users operand

f: Number of specified pdbuffer operands

g: Number of -i options specified in the pdbuffer operand

h: Value of pd_max_dic_process operand

i: Value of pd_max_bes_process operand

j: Record length of status file minus 40

k: If the number of RDAREAs in the server [Figure] 3400, the value is 1.
If 3401 [Figure] number of RDAREAs in the server [Figure] 6800, the value is 2.
If 6801 [Figure] number of RDAREAs in the server, the value is 3.

m: If the number of RDAREAs in the server [Figure] 10200, the value is 0.
If 10201 [Figure] number of RDAREAs in the server [Figure] 5672510, the value is 1.
If 5672511 [Figure] number of RDAREAs in the server [Figure] 11334820, the value is 2.
If 11334821 [Figure] number of RDAREAs in the server, the value is 3.

n: Status file record length

p: Number of back-end servers in unit

q: 1 if there is a dictionary server in the unit; otherwise, 0

r: 1 if there is a front-end server in the unit; otherwise, 0

s: 1 if there is a system manager in the unit; otherwise, 0

t: Number of foreign servers defined to link to this back-end server

u: Number of user mappings defined for foreign servers to link to this back-end server

v: Total number of foreign server definitions

w: Total number of user mapping definitions

y: Value of pd_max_rdarea_no operand

z: 1 in the following cases:
  • When there is a system manager in the unit
  • When there is no system manager in the unit and local is specified in the pd_mlg_msg_log_unit operand
0 when there is no system manager in the unit and manager is specified in the pd_mlg_msg_log_unit operand or specification is omitted

A: 736

B: 11

C: 1

D: [Figure](n - 348) [Figure] 20[Figure] + [Figure]j [Figure] 20[Figure] [Figure] (MAX([Figure]4096 [Figure] n[Figure],2) - 1)

E: [Figure](n - 68) [Figure] 20[Figure] + [Figure](n - 44) [Figure] 20[Figure] [Figure] (MAX([Figure]4096 [Figure] n[Figure],2) - 1)

F: [Figure]51200 [Figure] {[Figure](n - 72) [Figure] 20[Figure]}[Figure]

G: In 32-bit mode: [Figure](24 + 28 [Figure] I + 32 + 112 [Figure] J) [Figure] g[Figure]
In 64-bit mode: [Figure](32 + 32 [Figure] I + 32 + 128 [Figure] J) [Figure] g[Figure]

H: In 32-bit mode: [Figure](([Figure]([Figure](c [Figure] 8)[Figure] + 3) [Figure] 4[Figure]) [Figure] 4) [Figure] K) [Figure] g[Figure]
In 64-bit mode: [Figure](([Figure]([Figure](c [Figure] 8)[Figure] + 7) [Figure] 8[Figure]) [Figure] 8) [Figure] K) [Figure] g[Figure]

I: Value of pd_max_add_dbbuff_shm_no operand

J: Value of pd_max_add_dbbuff_no operand

K: Value obtained by adding the pd_max_add_dbbuff_no operand value to the total number of specified -i options in the pdbuffer operand (if a value other than Y is specified in the pd_dbbuff_modify operand, 0 is used)

1 For the 64-bit mode, use a value of 3456.

2 For the 64-bit mode, use a value of 688.

3 Do not add this value if you use the standby-less system switchover (effects distributed) facility.

[Contents][Back][Next]

[Trademarks]

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