4.9.2 Example 1 (HiRDB/Single Server)

This example creates data dictionary LOB RDAREAs in the following HiRDB file system area for RDAREA:

Organization of this subsection
(1) Creating the control statement file
(2) Executing the database structure modification utility (pdmod)

(1) Creating the control statement file

Create the control statement file that is to be specified in the database structure modification utility's (pdmod) argument. You can create the control statement file at any location. This example creates a file under the following filename:

Contents of the control statement file

create rdarea DICLOB01 for LOB used by HiRDB(SQL_ROUTINES)    1
   extension use 1000 segments
   file name "C:\rdarea05\diclob01"
       initial 10000 segments;
create rdarea DICLOB02 for LOB used by HiRDB(SQL_ROUTINES)    2
   extension use 1000 segments
   file name "C:\rdarea05\diclob02"
       initial 10000 segments;

Explanation:
  1. Definition of the data dictionary RDAREA (DICLOB01)
    DICLOB01 is a data dictionary LOB RDAREA for storing a definition source. The system uses the first data dictionary LOB RDAREA defined for storing a definition source. This example creates a HiRDB file named diclob01 in the HiRDB file system area. This HiRDB file has 10,000 segments.
    The example uses the RDAREA automatic extension feature. The extension size is 1,000 segments.
  2. Definition of the data dictionary RDAREA (DICLOB02)
    DICLOB02 is a data dictionary LOB RDAREA for storing SQL objects. The system uses the second data dictionary LOB RDAREA defined for storing SQL definitions. This example creates a HiRDB file named diclob02 in the HiRDB file system area. This HiRDB file has 10,000 segments.
    The example uses the RDAREA automatic extension feature. The extension size is 1,000 segments.

(2) Executing the database structure modification utility (pdmod)

Example of command entry

pdmod -a C:\hirdb\pdmod03

Explanation:
-a: Specifies the name of the control statement file that was previously created in (1).