![[Contents]](FIGURE/CONTENT.GIF)
Scalable Database Server, HiRDB Version 8 Command Reference
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
This section presents examples of using the database structure modification utility (adding an RDAREA).
This example adds the following RDAREAs:
![[Figure]](FIGURE/ZW070020.GIF)
/* Adding a LOB RDAREA */
create rdarea PDBULOB11 ..................................................1
globalbuffer gb01 ...............................................2
for LOB used by PUBLIC ..........................................3
page 8192 characters ............................................4
storage control segment 1 pages .................................5
file name "c:\dbarea\rdsys03\rdulob11" ..........................6
initial 50 segments ; .........................................7
/* Adding a user RDAREA */
create rdarea PDBUSER04 ..................................................1
globalbuffer gb02 ...............................................2
for user used by "userid" .......................................3
page 4096 characters ............................................4
storage control segment 50 pages ................................5
file name "c:\dbarea\rdsys04\rduser21" ..........................6
initial 100 segments ; ........................................7
|
/* Adding a user LOB RDAREA */
create rdarea PDBULOB11 ..................................................1
globalbuffer gb01 ...............................................2
for LOB used by PUBLIC ..........................................3
server name bes1 ................................................4
page 8192 characters ............................................5
storage control segment 1 pages .................................6
file name "c:\dbarea\rdsys03\rdulob11" ..........................7
initial 50 segments ; .........................................8
/* Adding a user RDAREA */
create rdarea PDBUSER04 ..................................................1
globalbuffer gb02 ...............................................2
for user used by "userid" .......................................3
server name bes2 ................................................4
page 4096 characters ............................................5
storage control segment 50 pages ................................6
file name "c:\dbarea\rdsys04\rduser21" ..........................7
initial 100 segments ; ........................................8
|
This example adds the following RDAREAs:
![[Figure]](FIGURE/ZW070040.GIF)
/* Adding a data dictionary RDAREA */
create rdarea PDBDDIC02 ..................................................1
globalbuffer gbp01 ..............................................2
for datadictionary of routines ..................................3
page 4096 characters ............................................4
storage control segment 30 pages ................................5
file name "c:\dbarea\rdsys02\rdddic02" ..........................6
initial 150 segments ; ........................................7
/* Adding a data dictionary LOB RDAREA */
create rdarea PDBDICL01 ..................................................1
globalbuffer gbp01 ..............................................2
for LOB used by HiRDB(SQL_ROUTINES) .............................3
page 8192 characters ............................................4
storage control segment 1 pages .................................5
file name "c:\dbarea\rdsys02\rddicl1" ...........................6
initial 200 segments ; ........................................7
/* Adding a data dictionary LOB RDAREA */
create rdarea PDBDICL02 ..................................................1
globalbuffer gbp01 ..............................................2
for LOB used by HiRDB(SQL_ROUTINES) .............................3
page 8192 characters ............................................4
storage control segment 1 pages .................................5
file name "c:\dbarea\rdsys02\rddicl2" ...........................6
initial 2000 segments ; .......................................7
|
/* Adding a data dictionary RDAREA */
create rdarea PDBDDIC02 ..................................................1
globalbuffer gbp01 ..............................................2
for datadictionary of routines ..................................3
server name dics ................................................4
page 4096 characters ............................................5
storage control segment 30 pages ................................6
file name "c:\dbarea\rdsys02\rdddic02" ..........................7
initial 150 segments ; ........................................8
/* Adding a data dictionary LOB RDAREA */
create rdarea PDBDICL01 ..................................................1
globalbuffer gbp01 ..............................................2
for LOB used by HiRDB(SQL_ROUTINES) .............................3
server name dics ................................................4
page 8192 characters ............................................5
storage control segment 1 pages .................................6
file name "c:\dbarea\rdsys02\rddicl1" ...........................7
initial 200 segments ; ........................................8
/* Adding a data dictionary LOB RDAREA */
create rdarea PDBDICL02 ..................................................1
globalbuffer gbp01 ..............................................2
for LOB used by HiRDB(SQL_ROUTINES) .............................3
server name dics ................................................4
page 8192 characters ............................................5
storage control segment 1 pages .................................6
file name "c:\dbarea\rdsys02\rddicl2" ...........................7
initial 2000 segments ; .......................................8
|
All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.