20.2 HiRDB/Parallel Server

The following table shows the formulas for determining the values to be set in environment variables, related to the number of resources. Specify these values in the Windows system environment variables If the obtained value is greater than the default value for the corresponding environment variable, set the obtained value in the environment variable. Otherwise, a problem may result; for example, HiRDB might be unable to start or a utility might be unable to execute.

These formulas provide the values required for a server machine.

Table 20-2 Values of environment variables related to the number of resources (HiRDB/Parallel Server)

TypeFormulaCorresponding environment variableDefault
Number of message queue identifiersb
[Figure]Vi + 2 x a + 3 x b + c + d + e
i=1
+ 24 + 1 + m
PDUXPLMSGMNI50
Number of message queue tablesb x number of units + A + BPDUXPLMSGTQL80
Number of semaphore identifiers[Figure]When the standby-less system switchover (effects distributed) facility is not used
b
[Figure] {[Figure](Si + Ti + Ui) [Figure] 64[Figure] + Wi}
i = 1
+ 6 x b + 2 + f
[Figure] When the standby-less system switchover (effects distributed) facility is used
b
[Figure] {[Figure]{Yi x (j + k)} [Figure] 64[Figure] + Wi}
i=1
+ 6 x b + 2 + f
PDUXPLSEMMAX64
Shared memory usage count[Figure]((2 + z) x g + Ai) x 1.2[Figure]PDUXPLSHMMAX4,096

A: Use the following value:

m
[Figure]{
i = 1
Number of global buffer pools allocated to server i#1
+ skip count of effective synchronization point dumps on server i#2 x 2
+ maximum number of concurrent pdloads, pdrorgs, pdrbals, and no-log mode UAPs that can be executed on server i + 1
}
m:
Number of back-end servers in the unit + number of dictionary servers in the unit + number of guest BESs in the unit#3
#1
You can obtain this value by adding all buffer pool names displayed by the pdbufls command for each server.
#2
If a nonzero value is specified in the pd_spd_syncpoint_skip_limit operand, use the pd_spd_syncpoint_skip_limit operand's value. If 0 is specified in the pd_spd_syncpoint_skip_limit operand or this operand is omitted, see Method based on the byte count of all system logs in Monitoring UAP status (skipped effective synchronization point dump monitoring facility) in the HiRDB Version 9 System Operation Guide.
#3
Add if standby-less system switchover (effects distributed) is used.

B: Add the following value if you specified 1 or a greater value in the pd_max_ard_process operand:

m
[Figure]{
i = 1
Sum of the pdbuffer -m values for global buffer pools allocated to server i
}
m:
Number of back-end servers in the unit + number of dictionary servers in the unit + number of guest BESs in the unit#
#
Add if standby-less system switchover (effects distributed) is used.
a: Number of front-end servers in the server machine
b: Number of dictionary servers and back-end servers in the server machine
c: 4 for the front-end server; 0 for other
d: 8 for the dictionary server; 0 for other
e: 16 for the back-end server; 0 for other
f: Add when the system switchover facility is being used. Determine the value from the following table:
ConditionValue of f
pd_ha_acttype=monitor (or default)0
pd_ha_acttype=serverpd_ha_agent=standbyunit1
pd_ha_agent=server1
pd_ha_agent=activeunits0
pd_ha_agent omittedpd_ha_server_process_standby=Y
(or default)
1
pd_ha_server_process_standby=N0
g: Value of the pd_max_server_process operand
h: Value of the pd_max_users operand
j: Number of host BESs
k: Number of guest BESs
m: If there is a system manager unit, 3; otherwise, 0

z: [Figure](total amount of shared memory used by global buffers#[Figure] SHMMAX value)[Figure]

Ai: If the pd_audit_def_buffer_size operand's value is greater than 0, the value of h; otherwise, 0

Si: Number of pdbuffer -r operands defined for the RDAREAs in each server
Ti: Number of pdbuffer -i operands defined for the RDAREAs in each server
Ui: Number of pdbuffer -o operands defined
Vi: 1 (if 1 or greater is specified in the pd_max_ard_process operand) or 0
Wi: 2 (if a value is specified in the pd_dfw_awt_process operand) or 0
Yi: Number of -c options specified in the pdbuffer operand
#
For details about the shared memory used by global buffers, see 15.2.5 Formula for size of shared memory used by global buffers.