スケーラブルデータベースサーバ HiRDB Version 8 システム定義(Windows(R)用)
HiRDB/シングルサーバのシステム定義を作成します。システム構成は次のとおりです。
●ユニット構成
●システムファイルの構成
set pd_system_id = PDB1 1 set pd_name_port = 20001 2 set pd_master_file_name = "C:\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 "C:\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","D:\sysfile_a\usts1a",\ 2 "E:\sysfile_b\usts1b" set pd_syssts_file_name_2 = "untsts2","D:\sysfile_a\usts2a",\ "E:\sysfile_b\usts2b" |
set pd_sds_shmpool_size = 10000 1 set pd_log_dual = Y 2 set pd_sts_file_name_1 = "svrsts1","D:\sysfile_a\ssts1a",\ 3 "E:\sysfile_b\ssts1b" set pd_sts_file_name_2 = "svrsts2","D:\sysfile_a\ssts2a",\ "E:\sysfile_b\ssts2b" pdwork -v "C:\work01","C:\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 "D:\sysfile_a\log1a" -b "E:\sysfile_b\log1b" pdlogadpf -d sys -g log2 -a "D:\sysfile_a\log2a" -b "E:\sysfile_b\log2b" pdlogadpf -d sys -g log3 -a "D:\sysfile_a\log3a" -b "E:\sysfile_b\log3b" pdlogadpf -d sys -g log4 -a "D:\sysfile_a\log4a" -b "E:\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 "D:\sysfile_a\sync1" pdlogadpf -d spd -g sync2 -a "E:\sysfile_b\sync2" pdlogadpf -d spd -g sync3 -a "D:\sysfile_a\sync3" pdlogadpf -d spd -g sync4 -a "E:\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, 2017, Hitachi, Ltd.