Nonstop Database, HiRDB Version 9 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 x 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} x 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](2,056 + 128 x d) [Figure] g[Figure] + [Figure]2,512 [Figure] g[Figure] + [Figure]40 [Figure] g[Figure]
+ [Figure]308 [Figure] g[Figure] + [Figure]4,000 [Figure] g[Figure] + [Figure]43,536 [Figure] g[Figure] + [Figure]32 [Figure] g[Figure]
Server [Figure]128 [Figure] g[Figure] + [Figure]3,280#1 [Figure] g[Figure] + [Figure](592#2 + j x b) [Figure] g[Figure]
+ [Figure]8,192 [Figure] g[Figure] + [Figure](8,192 - 128) [Figure] g[Figure] x {[Figure](a + m) [Figure] k[Figure] - 1}
+ [Figure][[Figure]{([Figure]c [Figure] 127[Figure] + 1) x 2,048} [Figure] 8,192[Figure] x 8,192] [Figure] g[Figure]
+ [Figure]2,048 [Figure] g[Figure] + [Figure]{244 + 64 x (2 x h + 7)} [Figure] g[Figure]
+ [Figure]96 [Figure] g[Figure] + [Figure]{48 + 68 x (2 x h + 7)} [Figure] g[Figure]
+ [Figure]{20,480 + [Figure](e x 98 [Figure] 20,480)[Figure] x 20,480 + [Figure](f x 80 [Figure] 20,480)[Figure] x 20,480} [Figure] g[Figure]
+ [Figure](8 x c + 4) [Figure] g[Figure] + [Figure]256 [Figure] g[Figure]
+ w
[Figure] If the status file record length < 4,096, add:
+ [Figure]MAX{3,400 [Figure] r + 0.7, 1}[Figure] x MAX([Figure]4,096 [Figure] s[Figure], 2) x n
+ [Figure]5,662,310 [Figure] r + 0.7[Figure] x MAX([Figure]4,096 [Figure] s[Figure], 2) x p
[Figure] If 4,096 [Figure] the status file record length < 12,288, add:
+ [Figure]MAX{(3,400 [Figure] [Figure](s - 348) [Figure] 20[Figure]) + 0.7, 1}[Figure] x n
+ [Figure](5,662,310 [Figure] [Figure](s - 348) [Figure] 20[Figure]) + 0.7[Figure] x p
[Figure] If 12,288 [Figure] the status file record length, add:
+ [Figure]MAX{(3,400 [Figure] [Figure](s - 876) [Figure] 20[Figure]) + 0.7, 1}[Figure] x n
+ [Figure](5,662,310 [Figure] [Figure](s - 876) [Figure] 20[Figure]) + 0.7[Figure] x p
[Figure] If the pd_log_auto_unload_path is specified, add:
+ [Figure]20,848 [Figure] g[Figure]
[Figure] If you are using the rapid system switchover facility and standby-less system switchover facility, add:
+ [Figure](256 x i + 4,096) [Figure] g[Figure]
[Figure] If Y is specified for the pd_dbbuff_modify operand, add:
+ 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] 3,400, the value is 1.
If 3,401 [Figure] number of RDAREAs in the server [Figure] 6,800, the value is 2.
If 6,801 [Figure] number of RDAREAs in the server, the value is 3.

p: If the number of RDAREAs in the server [Figure] 10,200, the value is 0.
If 10,201 [Figure] number of RDAREAs in the server [Figure] 5,672,510, the value is 1.
If 5,672,511 [Figure] number of RDAREAs in the server [Figure] 11,334,820, the value is 2.
If 11,334,821 [Figure] number of RDAREAs in the server, the value is 3.

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

s: Status file record length

v: 32-bit mode: [Figure](24 + 28 x (x + value of the pd_max_dbbuff_shm_no operand) + 32 + 112 x y) [Figure] g[Figure]
64-bit mode: [Figure](32 + 32 x x + 32 + 128 x y) [Figure] g[Figure]

w: 32-bit mode: [Figure]((([Figure]([Figure](c [Figure] 8)[Figure] + 3) [Figure] 4[Figure]) x 4) x z) [Figure] g[Figure]
64-bit mode: [Figure]((([Figure]([Figure](c [Figure] 8)[Figure] + 7) [Figure] 8[Figure])x 8) x z) [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 3,456.

#2: For the 64-bit mode, use a value of 688.
(b) HiRDB/Parallel Server
Type Formula for S
Unit [Figure][2,056 + 128 x {14 x (p + q) + (p + q + r)
+ (24 + s x 2 + q x 7 + r x 3 + p x 15 + 2)
+ (38 + (p + q + r) x 4 + z + d) + 3}] [Figure] j[Figure]
+ [Figure]944 [Figure] j[Figure] + [Figure]4,816 [Figure] j[Figure] + [Figure]40 [Figure] j[Figure]
+ [Figure]308 [Figure] j[Figure] + [Figure]4,000 [Figure] j[Figure] + [Figure]43,536 [Figure] j[Figure]
+ [Figure]16 [Figure] j[Figure] + [Figure]32 [Figure] j[Figure] + [Figure]16 [Figure] j[Figure]
[Figure] If you are using the standby-less system switchover (effects distributed) facility, add:
+ [Figure]{20,480 + [Figure](f x 98 [Figure] 20,480)[Figure] x 20,480 + [Figure](g x 80 [Figure] 20,480)[Figure] x 20,480} [Figure] j[Figure]
Front-end server [Figure]128 [Figure] j[Figure] + [Figure]3,280#1 [Figure] j[Figure] + [Figure](592#2 + A x b) [Figure] j[Figure]
+ [Figure]8,192 [Figure] j[Figure] + [Figure](8,192 - 128) [Figure] j[Figure] x {[Figure](a + C) [Figure] B[Figure] - 1}
+ [Figure]8,192 [Figure] j[Figure] + [Figure]2,048 [Figure] j[Figure]
+ [Figure]{244 + 64 x (2 x e + 7)} [Figure] j[Figure] + [Figure]96 [Figure] j[Figure] + [Figure]32 [Figure] j[Figure]
[Figure] If the pd_log_auto_unload_path operand is specified, add:
+ [Figure]20,848 [Figure] j[Figure]
Dictionary server [Figure]128 [Figure] j[Figure] + [Figure]3,280#1 [Figure] j[Figure] + [Figure](592#2 + A x b) [Figure] j[Figure]
+ [Figure]8,192 [Figure] j[Figure] + [Figure]8,192 [Figure] j[Figure] x {[Figure](a + C) [Figure] B[Figure] - 1}
+ [Figure][[Figure]{([Figure]c [Figure] 127[Figure] + 1) x 2,048} [Figure] 8,192[Figure] x 8,192] [Figure] j[Figure]
+ [Figure]2,048 [Figure] j[Figure] + [Figure]{244 + 64 x (2 x h + 7)} [Figure] j[Figure] + [Figure]96 [Figure] j[Figure]
+ [Figure]{48 + 68 x (2 x h + 7)} [Figure] j[Figure]
+ [Figure]{20,480 + [Figure](f x 98 [Figure] 20,480)[Figure] x 20,480 + [Figure](g x 80 [Figure] 20,480)[Figure] x 20,480} [Figure] j[Figure]
+ [Figure](8 x c + 4) [Figure] j[Figure] + [Figure]32 [Figure] j[Figure]
+ H
[Figure] If the status file record length < 4,096, add:
+ [Figure]MAX{3,400 [Figure] D + 0.7, 1}[Figure] x MAX([Figure]4,096 [Figure] n[Figure], 2)
[Figure] If 4,096 [Figure] the status file record length < 12,288, add:
+ [Figure]MAX{(3,400 [Figure] [Figure](n - 348) [Figure] 20[Figure]) + 0.7, 1}[Figure]
[Figure] If 12,288 [Figure] the status file record length, add:
+ [Figure]MAX{(3,400 [Figure] [Figure](n - 876) [Figure] 20[Figure]) + 0.7, 1}[Figure]
[Figure] When using the system switchover facility, add:
+ [Figure](256 x c + 4,096) [Figure] j[Figure]
[Figure] When the pd_log_auto_unload_path operand is specified, add:
+ [Figure]20,848 [Figure] j[Figure]
[Figure] When Y is specified for the pd_dbbuff_modify operand, add:
+ G
Back-end server [Figure]128 [Figure] j[Figure] + [Figure]3,280#1 [Figure] j[Figure] + [Figure](592#2 + A x b) [Figure] j[Figure]
+ [Figure]8,192 [Figure] j[Figure] + [Figure]8,192 [Figure] j[Figure] x {[Figure](a + C) [Figure] B[Figure] - 1}
+ [Figure][[Figure]{([Figure]c [Figure] 127[Figure] + 1) x 2,048} [Figure] 8,192[Figure] x 8,192] [Figure] j[Figure]
+ [Figure]2,048 [Figure] j[Figure] + [Figure]{244 + 64 x (2 x i + 7)} [Figure] j[Figure] + [Figure]96 [Figure] j[Figure]
+ [Figure]{48 + 68 x (2 x i + 7)} [Figure] j[Figure] + [Figure](8 x c + 4) [Figure] j[Figure] + [Figure]256 [Figure] j[Figure]
+ [Figure]{20,480 + [Figure](f x 98 [Figure] 20,480)[Figure] x 20,480 + [Figure](g x 80 [Figure] 20,480)[Figure] x 20,480} [Figure] j[Figure]#3
+ [Figure]32 [Figure] j[Figure] + H
[Figure] If status file record length < 4,096, add:
+ [Figure]MAX{3,400 [Figure] D + 0.7, 1}[Figure] x MAX([Figure]4,096 [Figure] n[Figure], 2) x k
+ [Figure]5,662,310 [Figure] D + 0.7[Figure] x MAX([Figure]4,096 [Figure] n[Figure], 2) x m
[Figure] If 4,096 [Figure] status file record length < 12,288, add:
+ [Figure]MAX{(3,400 [Figure] [Figure](n - 348) [Figure] 20[Figure]) + 0.7, 1}[Figure] x k
+ [Figure](5,662,310 [Figure] [Figure](n - 348) [Figure] 20[Figure]) + 0.7[Figure] x m
[Figure] If 12,288 [Figure] status file record length, add:
+ [Figure]MAX{(3,400 [Figure] [Figure](n - 876) [Figure] 20[Figure]) + 0.7, 1}[Figure] x k
+ [Figure](5,662,310 [Figure] [Figure](n - 876) [Figure] 20[Figure]) + 0.7[Figure] x m
[Figure] If using the system switchover facility, add:
+ [Figure](256 x y + 4,096) [Figure] j[Figure]
[Figure] If the pd_log_auto_unload_path operand is specified, add:
+ [Figure]20,848 [Figure] j[Figure]
[Figure] If Y is specified for the pd_dbbuff_modify operand, add:
+ 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] 3,400, the value is 1.
If 3,401 [Figure] number of RDAREAs in the server [Figure] 6,800, the value is 2.
If 6,801 [Figure] number of RDAREAs in the server, the value is 3.

m: If the number of RDAREAs in the server [Figure] 10,200, the value is 0.
If 10,201 [Figure] number of RDAREAs in the server [Figure] 5,672,510, the value is 1.
If 5,672,511 [Figure] number of RDAREAs in the server [Figure] 11,334,820, the value is 2.
If 11,334,821 [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

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] x (MAX([Figure]4,096 [Figure] n[Figure],2) - 1)

G: 32-bit mode: [Figure](24 + 28 x (I + value of the pd_max_dbbuff_shm_no operand) + 32 + 112 x J) [Figure] j[Figure]
64-bit mode: [Figure](32 + 32 x I + 32 + 128 x J) [Figure] j[Figure]

H: 32-bit mode: [Figure]((([Figure]([Figure](c [Figure] 8)[Figure] + 3) [Figure] 4[Figure]) x 4) x K) [Figure] j[Figure]
64-bit mode: [Figure]((([Figure]([Figure](c [Figure] 8)[Figure] + 7) [Figure] 8[Figure]) x 8) x K) [Figure] j[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 3,456.

#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) 2012, Hitachi, Ltd.