Scalable Database Server, HiRDB Version 8 Description

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

11.3.1 Differences in HiRDB system definition

The 64-bit mode enables higher maximum values to be specified in some definition operands, as shown in Table 11-2.

Table 11-2 Operands with higher maximum value specifications (HiRDB system definition)

Operand Specification item Max value in 32-bit mode Max value in 64-bit mode
pd_hash_table_size Hash table size when application of hash execution for a hash join or a subquery is specified 524,288 kilobytes 2,097,152 kilobytes
pd_sql_object_cache_size SQL object buffer size 256,000 kilobytes 2,000,000 kilobytes
pd_table_def_cache_size Table definition information buffer size 65,535 kilobytes 2,000,000 kilobytes
pd_view_def_cache_size View analysis information buffer size 32,000 kilobytes 2,000,000 kilobytes
pd_type_def_cache_size User-defined type information buffer size 65,536 kilobytes 2,000,000 kilobytes
pd_routine_def_cache_size Routine definition information buffer size 65,536 kilobytes 2,000,000 kilobytes
pd_sds_shmpool_size Single-server shared memory size 200,000 kilobytes 4,000,000,000 kilobytes
pd_dic_shmpool_size Dictionary server shared memory size 200,000 kilobytes 4,000,000,000 kilobytes
pd_bes_shmpool_size Back-end server shared memory size 200,000 kilobytes 4,000,000,000 kilobytes
pd_lck_pool_size Lock pool size per server 2,000,000 kilobytes 2,000,000,000 kilobytes
pd_fes_lck_pool_size Lock pool size for front-end servers 2,000,000 kilobytes 2,000,000,000 kilobytes
pd_work_buff_size Work table buffer size 1,000,000 kilobytes 4,000,000,000 kilobytes
pdbuffer Number of global buffer definitions 500 per server* 1,000 per server*
pdbuffer -n Number of global buffer sectors 460,000 1,073,741,824
SHMMAX Maximum shared memory segment size 2,047 megabytes 4,194,304 megabytes

* Total of 1600 definitions per system.