The following shows an example of creating a HiRDB file system area for work table files:
- Example
- Create a HiRDB file system area for work table files:
pdfmkfs -n 50 -l 20 -k WORK -e 3300 -i -a C:\workarea01 |
- Explanation:
- -n: Specifies the size of the HiRDB file system area in MB.
- For details about how to estimate the area size, see Chapter 18. Determining Work Table File Size.
- -l: Specifies the maximum number of files that can be created in this HiRDB file system area.
- -k: Specifies the purpose of this HiRDB file system area.
- This example specifies WORK because this HiRDB file system area is for work table files.
- -e: Specifies the number of HiRDB file extensions permitted for this HiRDB file system area.
- -i: Specifies that the entire HiRDB file system area is to be initialized.
- When the -i option is specified, the system allocates the entire area. When the -i option is omitted, the system creates only the management information for the HiRDB file system area.
- -a: Specifies that the HiRDB file system area is to be extended automatically.
- Specify the -a option to automatically extend the HiRDB file system area as much as necessary even if it exceeds the size specified with the -n option when, for example, an SQL statement that uses automatic extension of an RDAREA or a work table is executed.
- C:\workarea01: Specifies the name of the HiRDB file system area to be created.
- Enter the name that was specified in the pdwork operand in the HiRDB system definitions.
After the command has executed, the execution results should be checked for errors. For details about how to check command execution results, see the manual HiRDB Version 9 Command Reference.