20.1 HiRDB/Single Server

The table below shows formulas for determining the values to be set for 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, such as HiRDB cannot be started or a utility cannot be executed.

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

TypeFormulaCorresponding environment variableDefault
Number of message queue identifiers(16 + f) x a + 28 + 1PDUXPLMSGMNI50
Number of message queue tablesb x number of units + A + BPDUXPLMSGTQL80
Number of semaphore identifiers{[Figure]{2 x (b + 3) + 12} [Figure] 64[Figure] + [Figure]c[Figure] 64[Figure] + g + 5} x a + 2 + dPDUXPLSEMMAX64
Shared memory usage count[Figure]((2 + h) x e + i) 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: 1
#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.

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: 1
a: 1 for a single server
b: Value of the pd_max_users operand
c: Number of pdbuffer operands defined
d: Add when the system switchover facility is being used. Determine the value from the following table:
ConditionValue of d
pd_ha_acttype=monitor (or default)0
pd_ha_acttype=serverpd_ha_agent=standbyunit1
Omit pd_ha_agentpd_ha_server_process_standby=Y
(or default)
1
pd_ha_server_process_standby=N0
e: Value of the pd_max_server_process operand
f: 1 (if 1 or greater is specified in the pd_max_ard_process operand) or 0
g: 2 (if a value is specified in the pd_dfw_awt_process operand) or 0

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

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

#
For details about the shared memory used by global buffers, see 15.1.5 Formula for size of shared memory used by global buffers.