22.3 Using the system generator to construct a HiRDB system
(1) Setting the HiRDB directory as the current directory
The OS's cd command is used to set the HiRDB directory as the current directory:
(2) Starting the system generator (pdgen)
HiRDB's pdgen command is used to start the system generator. The type specification screen is displayed.
(3) Specifying the license selection
Specify your HiRDB license selection.
- HiRDB/Single Server License selection menu screen
![[Figure]](figure/ga210010.gif)
To specify the necessary information on the HiRDB/Single Server License selection menu screen, use the following procedure:
- On the HiRDB/Single Server License selection menu screen, at the last line, Select 1/2 or q >, enter either 1 or 2
whatever corresponds to your license selection
and then press the ENTER key.
The Master menu is displayed.
(4) Setting main information for the HiRDB system
The Master menu is used to set main information for HiRDB system construction.
- Master menu screen
![[Figure]](figure/ga210020.gif)
Following is the setup procedure on the Master menu screen:
(a) Specify the number of concurrently executable users
- At Enter 1-12 or o-q > on the last line of the Master menu screen, enter 3.
3: Number of concurrently execute user: is displayed on the last line.
- Enter 60, then press the Enter key (for simple installation, the number of concurrently executable users is preset to 60).
(b) Specify the volume of database updating per day
- At Enter 1-12 or o-q > on the last line of the Master menu screen, enter 5.
5: Database update size per day: is displayed on the last line.
- Enter 10, then press the Enter key (for simple installation, the volume of database updating per day is preset to 10 MB).
(c) Set the size of the HiRDB file system area for system files
This specification sets the size of the HiRDB file system area that is to be used to store system files, such as files for HiRDB database log information.
To set the size of the HiRDB file system area for system files:
- At Enter 1-12 or i-q > on the last line of the Master menu screen, enter 8.
The message shown below is displayed.
- At Enter file name with completely path > on the second line from the bottom of the message, enter /opt/HiRDB_S/sysfiles, then press the Enter key.
- At Enter HiRDB-file-system-area size [MB] > on the last line of the message, enter the value displayed as xxxx in the message, The size of HiRDB-file-system-area will more than xxxx [MB], then press the Enter key.
A HiRDB file system area for system files of the specified size is registered, and the cursor is placed on the line Enter 1-12 or o-q >.
- Message (In this example, 150 is displayed)
Enter file name and partition size for HiRDB-file-system-area.
This HiRDB-file-system-area will be used for HiRDB system files. (log and status etc...)
-- Attention --
Please enter file name with complete path.
If specified file are already exist pdgen will delete the file and recreate.
The size of HiRDB-file-system-area will more than 150 [MB].
The HiRDB-file-system-area creates as UNIX file with specified size.
Enter file name with completely path > /opt/HiRDB_S/sysfiles
Enter HiRDB-file-system-area size [MB] >150 |
(d) Specify the size of the HiRDB file system area for RDAREAs
This specification sets the size of the HiRDB file system area that is to be used for system RDAREAs, user RDAREAs, and user LOB RDAREAs.
To set the size of the HiRDB file system area for RDAREAs:
- At Enter 1-12 or i-q > on the last line of the Master menu screen, enter 12, then press the Enter key.
The message shown below is displayed.
- At Enter file name with completely path > on the second line from the bottom of the message, enter /opt/test/HiRDB_S/rdfiles, then press the Enter key.
- At Enter HiRDB-file-system-area size [MB] > on the last line of the message, enter the value equal to the value displayed as xxxx in the message, The size of HiRDB-file-system-area will more than xxxx [MB], plus 81 for the area to be used for user RDAREAs and user LOB RDAREAs, plus 5 for extra space, then press the Enter key.
A HiRDB file system area for RDAREAs of the specified size is registered, and the cursor is placed on the line Enter 1-12 or o-q >.
- Message (In the following example, the area size displayed is 77)
Enter file name and partition size for HiRDB-file-system-area.
This HiRDB-file-system-area will be used for rdarea.
-- Attention --
Please enter file name with complete path.
If specified file are already exist pdgen will delete the file and recreate. The size of HiRDB-file-system-area will more than 77 [MB].
The HiRDB-file-system-area creates as UNIX file with specified size.
Enter file name with completely path >/opt/HiRDB_S/rdfiles
Enter HiRDB-file-system-area size [MB] >163 |
(5) Creating the HiRDB.
To create the HiRDB:
- At Enter 1-12 or o-q > on the last line of the Master menu screen, enter g, then press the Enter key.
The message lines shown as follows are displayed, the HiRDB system is created automatically, and the message, Push enter key to main menu>, is displayed on the last line.
- Press the Enter key.
Creation of the HiRDB system is now complete, and the Master menu is displayed.
- Message (The following is only an example; the actual message that is displayed depends on the values that have been set)
Start HiRDB system generation
HiRDB starting
Initializing rdareas
KFPX24000-I DB initialize ended, return code=0
Rdarea initialize completed
A...A XX:XX:XX u001 _rdm KFPS05110-I HiRDB unit u001 initialization process complete
A...A XX:XX:XX u001 _rdm KFPS05210-I HiRDB system initialization process complete
Initializing rdareas for registry
KFPX24600-I Pdreginit command start at XX:XX:XX on YYYY/YY/YY
KFPX24225-I Processing of create rdarea statement ended, RDAREA name="REG_BASE"
KFPX24225-I Processing of create rdarea statement ended, RDAREA name="REG_KEY_VALUE"
KFPX24226-I Processing of create rdarea statements ended return code=0
KFPX24200-I DB modification ended, return code=0
KFPX24601-I Pdreginit command for ended return code=0 at XX:XX:XX on YYYY/YY/YY
Rdarea(for registry) initialize completed
Push enter key to main menu > |
(6) Creating user RDAREAs and user LOB RDAREAs
Next, create a user RDAREA and user LOB RDAREAs for storing the SGML documents and plug-in index.
This example creates one user RDAREA and two user LOB RDAREAs.
- Create new rdarea menu screen
![[Figure]](figure/ga210060.gif)
To create a user RDAREA and user LOB RDAREAs:
- At Enter 1-12 or o-q > on the last line of the Master menu screen, enter r, then press the Enter key.
The Create new rdarea menu screen is displayed.
- To create an RDAREA, enter 1 at Enter 1-7 or o-q > on the last line of the Create new rdarea menu.
1: Rdarea name: is displayed on the last line.
- Enter USR1 corresponding to item 1 in Table 22-9, then press the Enter key.
- In the same manner as in steps 2 and 3 above, at Enter 1-7 or a-q > enter the values corresponding to items 2-7 in Table 22-9.
- When values have been set for items 1-7, enter a at Enter 1-7 or a-q > to add two more RDAREAs, then repeat steps 2-4.
- When one user RDAREA and two user LOB RDAREAs have been added, enter q at Enter 1-7 or a-q >.
The following message is displayed:
Rdarea are added. You have to restart HiRDB to use the area.
Restart now?(Y/N) >
- Enter N, then press the Enter key.
Addition of user LOB RDAREAs is now complete, and the Master menu is displayed again.
The values listed in Table 22-9 are applicable to construction of a HiRDB system by means of the simple installation procedure. When a database is designed in detail, reference should be made to 17. Determining RDAREA Size for the appropriate size estimates.
Table 22-9 Information to be set for RDAREAs
No. | Information to be set | User RDAREA USR1 | User LOB RDAREA |
---|
1 | RDAREA name | USR1 | ULOB1 | ULOB2 |
2 | Size of RDAREA [MB] | 1 | 40 | 40 |
3 | Segment size for RDAREA [pages] | 10 | 1 | 1 |
4 | Page size for RDAREA [KB] | 4 | 8 | 8 |
5 | Type of RDAREA | Table | Blob | Blob |
6 | Size of global buffer to be allocated to RDAREA | 350 | 350 | 350 |
7 | Absolute path name of HiRDB file that is a component of RDAREA | /opt/HiRDB_S/ rdfiles | /opt/HiRDB_S/ rdfiles | /opt/HiRDB_S/ rdfiles |