3.4.1 Adding an RD area
(1) Invoking the embedded DB prompt
In the Start menu of Windows go to Cosminexus - Database Console, and invoke the embedded DB prompt.
(2) Initialize the file area for the RD area
Initialize the file area for an RD area by entering the following command in the embedded DB prompt:
pdfmkfs -k DB -n Physical file size -l Maximum number of logical files in a physical file
-e Maximum capacity extension frequency of a logical file Physical file absolute path |
With the embedded database, one physical file is divided into many logical files, and is managed. The different parameters of a physical file and logical file are specified below:
- -n Physical-file-size
Code the file size in MB. Specify an unsigned integer from 1 to 2047.
- -l Maximum-number-of-logical-files-in-a-physical-file
Specify the upper limit for the number of logical files that can be created in one physical file. Specify an unsigned integer from 1 to 4096.
- -e Maximum-capacity-extension-frequency-of-a-logical-file
Specify the upper limit for the capacity extension frequency of the logical file. Specify an unsigned integer from 0 to 60000. The default value is 0.
Based on the frequency specified in the embedded database, increase the capacity of the logical file as required. Note that the maximum extension frequency of one logical file is 23. If you specify the maximum number of logical files more than 23 times, the specifications will not be applied, and the value that is calculated by the maximum number of logical files times 23 will be assumed.
- Physical-file-absolute-path
Specify an absolute path for the physical file.
(3) Adding an RD area
Add an RD area by entering the following command in the embedded DB prompt:
pdmod -a Parameter file path |
Describe the following contents in the parameter file. Note that the RD area is managed in segments. One segment is equivalent to 8,192 bytes.
create rdarea "RD area name"
for LOB used by PUBLIC
extension use Number of increased segments segments
file name "Physical file absolute path\logical file name"
initial Number of initial segments segments; |
- RD-area-name
Specify an identifier from 1 to 30 characters for the RD area name. When you create a table specifying the RD areas, specify the name to be specified as a parameter of the create table statement.
- Number-of-increased-segments
With this parameter, specify the number of segments increased with one capacity extension. Specify an unsigned integer from 1 to 64000.
If the capacity of an RD area is insufficient, the RD area will be extended automatically if some free space is available in the physical file (you cannot extend the capacity more than the number of times specified with the -e option of pdfmkfs).
- Physical-file-absolute-path-name\logical-file-name
Specify a value within 131 characters for the absolute path of the physical file and the name of a logical file that you will allocate to the RD area. Match the absolute path of the physical file with the value specified in pdfmkfs. Specify a unique string within the physical file for the logical file name.
- Number-of-initial-segments
Specify the number of segments secured beforehand. Specify an unsigned integer.
(4) Create a table that specifies RD areas
Create a table by specifying the added RD areas. For details on how to create a table, see the manual HiRDB SQL Reference.