4.8.2 Example 1 (HiRDB/Single Server)

This example creates a user RDAREA to store a LOB column structure base table in the following HiRDB file system area for RDAREA:

Additionally, the example creates a user LOB RDAREA to store data with the LOB attribute in the following HiRDB file system area for LOB 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 USER03 for user used by PUBLIC                  1
   extension use 50 segments
   file name "C:\rdarea03\user03"
        initial 500 segments;
create rdarea ULOB03 for LOB used by PUBLIC                   2
   extension use 50 segments
   file name "C:\rdarea04\ulob03"
        initial 20000 segments;

Explanation:
  1. Definition of the user RDAREA (USER03)
    USER03 is a public RDAREA (PUBLIC). This example creates a HiRDB file named user03 in the HiRDB file system area. This HiRDB file has 500 segments. The example uses the RDAREA automatic extension feature. The extension size is 50 segments.
  2. Definition of the user LOB RDAREA (ULOB03)
    ULOB03 is a public RDAREA (PUBLIC). This example creates a HiRDB file named ulob03 in the HiRDB file system area. This HiRDB file has 20,000 segments.
    The example uses the RDAREA automatic extension feature. The extension size is 50 segments.

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

Example of command entry

pdmod -a C:\hirdb\pdmod02

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