7.3.2 Examples
(1) Adding RDAREAs (1)
This example adds the following RDAREAs:
- PDBULOB11 (user LOB RDAREA)
- PDBUSER04 (user RDAREA)
- Overview
![[Figure]](figure/zx070020.gif)
(a) HiRDB/Single Server
- Contents of the control statement file (/usr/seifile/mofl01)
/* 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 "/svr02/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 "/dbarea/area1/rduser21" ..............................6
initial 100 segments ; ........................................7 |
- Explanation
- Specifies the name of the RDAREA to be added.
- Specifies the name of the global buffer to which the RDAREA is to be allocated.
- Specifies the type of RDAREA.
- Specifies the page length.
- Specifies the segment size.
- Specifies the name of the HiRDB file that constitutes the RDAREA.
- Specifies the number of HiRDB file segments.
(b) HiRDB/Parallel Server
- Contents of the control statement file (/usr/seifile/mofl01)
/* 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 "/svr02/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 "/dbarea/area1/rduser21" ..............................7
initial 100 segments ; ........................................8 |
- Explanation
- Specifies the name of the RDAREA to be added.
- Specifies the name of the global buffer to which the RDAREA is to be allocated.
- Specifies the type of RDAREA.
- Specifies the page length.
- Specifies the name of the server that manages the RDAREA.
- Specifies the segment size.
- Specifies the name of the HiRDB file that constitutes the RDAREA.
- Specifies the number of HiRDB file segments.
(2) Adding RDAREAs (2)
This example adds the following RDAREAs:
- PDBDDIC02 (data dictionary RDAREA)
- PDBDICL1 (data dictionary LOB RDAREA)
- PDBDICL2 (data dictionary LOB RDAREA)
- Overview
![[Figure]](figure/zx070040.gif)
(a) HiRDB/Single Server
- Contents of the control statement file (/usr/seifile/mofl01)
/* 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 "/svr01/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 "/svr01/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 "/svr01/rddicl2" ......................................6
initial 2000 segments ; .......................................7 |
- Explanation
- Specifies the name of the RDAREA to be added.
- Specifies the name of the global buffer to which the RDAREA is to be allocated.
- Specifies the type of RDAREA.
- Specifies the page length.
- Specifies the segment size.
- Specifies the name of the HiRDB file that constitutes the RDAREA.
- Specifies the number of HiRDB file segments.
(b) HiRDB/Parallel Server
- Contents of the control statement file (/usr/seifile/mofl01)
/* 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 "/svr01/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 "/svr01/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 "/svr01/rddicl2" ......................................7
initial 2000 segments ; .......................................8 |
- Explanation
- Specifies the name of the RDAREA to be added.
- Specifies the name of the global buffer to which the RDAREA is to be allocated.
- Specifies the type of RDAREA.
- Specifies the name of the server that manages the RDAREA.
- Specifies the page length.
- Specifies the segment size.
- Specifies the name of the HiRDB file that constitutes the RDAREA.
- Specifies the number of HiRDB file segments.