スケーラブルデータベースサーバ HiRDB Version 8 システム定義(UNIX(R)用)
HiRDB/シングルサーバのシステム定義を作成します。システム構成は次のとおりです。
●ユニット構成
●システムファイルの構成
set pd_system_id = PDB1 1 set pd_name_port = 20001 2 set pd_master_file_name = "/rdarea/mast/mast01" 3 set pd_max_users = 100 4 set pd_max_server_process = 220 5 set pd_max_access_tables = 50 6 set pd_sql_object_cache_size = 3000 7 set pd_max_rdarea_no = 200 8 set pd_max_file_no = 600 9 set pd_optimize_level = "PRIOR_NEST_JOIN", \ 10 "PRIOR_OR_INDEXES","DETER_AND_INDEXES", \ "RAPID_GROUPING","DETER_WORK_TABLE_FOR_UPDATE", \ "APPLY_ENHANCED_KEY_COND" set pd_additional_optimize_level = "COST_BASE_2" 11 pdunit -x host1 -u UNT1 -d "/HiRDB" 12 pdstart -t SDS -s sds1 -u UNT1 13 pdbuffer -a gbuf01 -r RDMAST,RDDIC,RDDIR -n 1000 14 pdbuffer -a gbuf02 -r RDAREA1,RDAREA2,RDAREA3 -n 1000 15 pdbuffer -a gbuf03 -r RDAREA4,RDAREA5,RDAREA6 -n 1000 16 pdbuffer -a gbuf04 -o -n 1000 17 putenv SHMMAX 16 18 |
set pd_unit_id = UNT1 1 set pd_syssts_file_name_1 = "untsts1","/sysfile_a/usts1a",\ 2 "/sysfile_b/usts1b" set pd_syssts_file_name_2 = "untsts2","/sysfile_a/usts2a",\ "/sysfile_b/usts2b" |
set pd_sds_shmpool_size = 10000 1 set pd_log_dual = Y 2 set pd_sts_file_name_1 = "svrsts1","/sysfile_a/ssts1a",\ 3 "/sysfile_b/ssts1b" set pd_sts_file_name_2 = "svrsts2","/sysfile_a/ssts2a",\ "/sysfile_b/ssts2b" pdwork -v "/work01","/work02" 4 pdlogadfg -d sys -g log1 ONL 5 pdlogadfg -d sys -g log2 ONL pdlogadfg -d sys -g log3 ONL pdlogadfg -d sys -g log4 ONL pdlogadpf -d sys -g log1 -a "/sysfile_a/log1a" -b "/sysfile_b/log1b" pdlogadpf -d sys -g log2 -a "/sysfile_a/log2a" -b "/sysfile_b/log2b" pdlogadpf -d sys -g log3 -a "/sysfile_a/log3a" -b "/sysfile_b/log3b" pdlogadpf -d sys -g log4 -a "/sysfile_a/log4a" -b "/sysfile_b/log4b" pdlogadfg -d spd -g sync1 ONL 6 pdlogadfg -d spd -g sync2 ONL pdlogadfg -d spd -g sync3 ONL pdlogadfg -d spd -g sync4 ONL pdlogadpf -d spd -g sync1 -a "/sysfile_a/sync1" pdlogadpf -d spd -g sync2 -a "/sysfile_b/sync2" pdlogadpf -d spd -g sync3 -a "/sysfile_a/sync3" pdlogadpf -d spd -g sync4 -a "/sysfile_b/sync4" |
set pd_uap_wait = Y 1 pdlbuffer -a localbuf1 -r RDAREA10 -n 1000 -p 16 2 pdlbuffer -a localbuf2 -r RDAREA11,RDAREA12 -n 1000 3 pdlbuffer -a localbuf3 -i USER01.INDX01 -n 1000 4 |
All Rights Reserved. Copyright (C) 2006, 2016, Hitachi, Ltd.