スケーラブルデータベースサーバ HiRDB Version 8 コマンドリファレンス(UNIX(R)用)
データベース初期設定ユティリティの使用例を,例1に示します。
次に示すRDエリアを作成します。 ・PDBMAST(マスタディレクトリ用RDエリア) ・PDBDDIR(データディレクトリ用RDエリア) ・PDBDDIC(データディクショナリ用RDエリア) ・PDBDICL1(データディクショナリLOB用RDエリア) ・PDBDICL2(データディクショナリLOB用RDエリア) ・PDBUSER01(ユーザ用RDエリア) ・PDBULOB01(ユーザLOB用RDエリア) ・PDBUSER02(ユーザ用RDエリア) なお,既に次のHiRDBファイルシステム領域が作成されているものとします。 ・/svr01(キャラクタ型スペシャルファイル) ・/svr02(キャラクタ型スペシャルファイル) ・/dbarea/area1(通常ファイル) |
pdinit -d /usr/seifile/infl01 |
/* マスタディレクトリ用RDエリアの定義 */ create rdarea PDBMAST ...............................1 for masterdirectory ...................2 page 4096 characters ..................3 storage control segment 50 pages ......4 file name "/svr01/rdmaster" initial 10 segments ; .............5 /* データディレクトリ用RDエリアの定義 */ create rdarea PDBDDIR ...............................6 for datadirectory .....................7 page 4096 characters ..................8 storage control segment 50 pages ......9 file name "/svr01/rdddir" initial 5 segments ; ..............10 /* データディクショナリ用RDエリアの定義 */ create rdarea PDBDDIC ...............................11 for datadictionary ....................12 page 4096 characters ..................13 storage control segment 30 pages ......14 file name "/svr01/rdddic" initial 150 segments ; ............15 /* データディクショナリLOB用RDエリアの定義 */ create rdarea PDBDICL1 ..............................16 for LOB used by HiRDB(SQL_ROUTINES) ...17 page 8192 characters ..................18 storage control segment 1 pages .......19 file name "/svr01/rddicl1" initial 200 segments ; ............20 /* データディクショナリLOB用RDエリアの定義 */ create rdarea PDBDICL2 ..............................21 for LOB used by HiRDB(SQL_ROUTINES) ...22 page 8192 characters ..................23 storage control segment 1 pages .......24 file name "/svr01/rddicl2" initial 2000 segments ; ...........25 /* ユーザ用RDエリアの定義 */ create rdarea PDBUSER01 .............................26 for user used by PUBLIC ...............27 page 4096 characters ..................28 storage control segment 150 pages .....29 file name "/svr02/rduser01" initial 50 segments ; .............30 /* ユーザLOB用RDエリアの定義 */ create rdarea PDBULOB01 .............................31 for LOB used by PUBLIC ................32 page 8192 characters ..................33 storage control segment 1 pages .......34 file name "/svr02/rdulob01" initial 50 segments ; .............35 /* ユーザ用RDエリアの定義 */ create rdarea PDBUSER02 .............................36 for user used by USERID ...............37 page 4096 characters ..................38 storage control segment 50 pages ......39 file name "/dbarea/area1/rduser02" initial 100 segments ; ............40 |
pdinit -d /usr/seifile/infl01 |
/* マスタディレクトリ用RDエリアの定義 */ create rdarea PDBMAST ..........................................1 for masterdirectory ..............................2 server name dics .................................3 page 4096 characters .............................4 storage control segment 50 pages .................5 file name "/svr01/rdmaster" initial 10 segments ; ........................6/* データディレクトリ用RDエリアの定義 */ create rdarea PDBDDIR ..........................................7 for datadirectory ................................8 server name dics .................................9 page 4096 characters .............................10 storage control segment 50 pages .................11 file name "/svr01/rdddir" initial 5 segments ; .........................12/* データディクショナリ用RDエリアの定義 */ create rdarea PDBDDIC ..........................................13 for datadictionary ...............................14 server name dics .................................15 page 4096 characters .............................16 storage control segment 30 pages .................17 file name "/svr01/rdddic" initial 150 segments ; .......................18/* データディクショナリLOB用RDエリアの定義 */ create rdarea PDBDICL1 .........................................19 for LOB used by HiRDB(SQL_ROUTINES) ..............20 server name dics .................................21 page 8192 characters .............................22 storage control segment 1 pages ..................23 file name "/svr01/rddicl1" initial 200 segments ; .......................24 /* データディクショナリLOB用RDエリアの定義 */ create rdarea PDBDICL2 .........................................25 for LOB used by HiRDB(SQL_ROUTINES) ..............26 server name dics .................................27 page 8192 characters .............................28 storage control segment 1 pages ..................29 file name "/svr01/rddicl2" initial 2000 segments ; ......................30 /* ユーザ用RDエリアの定義 */ create rdarea PDBUSER01 ........................................31 for user used by PUBLIC ..........................32 server name bes1 .................................33 page 4096 characters .............................34 storage control segment 150 pages ................35 file name "/svr02/rduser01" initial 50 segments ; ........................36/* ユーザLOB用RDエリアの定義 */ create rdarea PDBULOB01 ........................................37 for LOB used by PUBLIC ...........................38 server name bes1 .................................39 page 8192 characters .............................40 storage control segment 1 pages ..................41 file name "/svr02/rdulob01" initial 50 segments ; ........................42/* ユーザ用RDエリアの定義 */ create rdarea PDBUSER02 ........................................43 for user used by USERID ..........................44 server name bes2 .................................45 page 4096 characters .............................46 storage control segment 50 pages .................47 file name "/dbarea/area1/rduser02" initial 100 segments ; .......................48 |
All Rights Reserved. Copyright (C) 2006, 2016, Hitachi, Ltd.