Scalable Database Server, HiRDB Version 8 Description
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.
All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.