7.3.2 Examples

This section presents examples of using the database structure modification utility (adding an RDAREA).

Organization of this subsection
(1) Adding RDAREAs (1)
(2) Adding RDAREAs (2)

(1) Adding RDAREAs (1)

This example adds the following RDAREAs:

Overview
[Figure]
(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
  1. Specifies the name of the RDAREA to be added.
  2. Specifies the name of the global buffer to which the RDAREA is to be allocated.
  3. Specifies the type of RDAREA.
  4. Specifies the page length.
  5. Specifies the segment size.
  6. Specifies the name of the HiRDB file that constitutes the RDAREA.
  7. 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
  1. Specifies the name of the RDAREA to be added.
  2. Specifies the name of the global buffer to which the RDAREA is to be allocated.
  3. Specifies the type of RDAREA.
  4. Specifies the page length.
  5. Specifies the name of the server that manages the RDAREA.
  6. Specifies the segment size.
  7. Specifies the name of the HiRDB file that constitutes the RDAREA.
  8. Specifies the number of HiRDB file segments.

(2) Adding RDAREAs (2)

This example adds the following RDAREAs:

Overview
[Figure]
(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
  1. Specifies the name of the RDAREA to be added.
  2. Specifies the name of the global buffer to which the RDAREA is to be allocated.
  3. Specifies the type of RDAREA.
  4. Specifies the page length.
  5. Specifies the segment size.
  6. Specifies the name of the HiRDB file that constitutes the RDAREA.
  7. 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
  1. Specifies the name of the RDAREA to be added.
  2. Specifies the name of the global buffer to which the RDAREA is to be allocated.
  3. Specifies the type of RDAREA.
  4. Specifies the name of the server that manages the RDAREA.
  5. Specifies the page length.
  6. Specifies the segment size.
  7. Specifies the name of the HiRDB file that constitutes the RDAREA.
  8. Specifies the number of HiRDB file segments.