4.1.2 System generator operation

Steps (1) through (17) as follows explain the system generator operating procedure.

Because the system generator displays the commands that are used to construct HiRDB, a screen log should be collected.

Organization of this subsection
(1) Change the current directory
(2) Start the system generator (pdgen)
(3) HiRDB/Single Server License selection menu is displayed
(4) Master menu is displayed
(5) Display the Detail option setting menu
(6) Detail option setting menu (1/2) is displayed
(7) Detail option setting menu (2/2) is displayed
(8) Master menu is displayed
(9) Start the HiRDB environment setup
(10) Message is displayed
(11) Master menu is displayed
(12) Create new rdarea menu is displayed
(13) Master menu is displayed again
(14) Master menu is displayed
(15) Plug-in Setup menu is displayed
(16) Master menu is displayed again
(17) Master menu is displayed again

(1) Change the current directory

Enter the OS's cd command to set the HiRDB directory as the current directory.

$cd HiRDB-directory-name

(2) Start the system generator (pdgen)

Enter the pdgen command to start the system generator.

$pdgen

(3) HiRDB/Single Server License selection menu is displayed

Specify the HiRDB's license type.

[Figure]

Select the HiRDB's license type.

  1. Select this item if you have a license based on the number of concurrent connections.
    The following message is displayed:
    Enter number of your licenses (2-[licenses])>
    Enter the number of licenses purchased. If your HiRDB server consists of multiple machines, specify the number of licenses purchased divided by the number of machines.
  2. Specify if you have a number of CPU licenses.

To quit execution of the system generator, enter q. When the following message is displayed, enter Y:

Really terminate system generation ? (Y/N) > Y

(4) Master menu is displayed

This menu is used to set basic information about the HiRDB system.

First enter 1, then enter appropriate information in response to the message displayed. Repeat in the same manner for items 2-5.

[Figure]

The messages that are displayed when each of items 1-5 is entered are explained as follows:

1: Enter HiRDB directory name >
Default: Current directory during the execution of pdgen
Specify the absolute pathname of the HiRDB directory.
2: Enter HiRDB port no (5001-65535) >
Default: 20000
Specify the port number of this HiRDB. This must not be the same port number specified for any other HiRDB or program.
Enter HiRDB system id (xxxx) >
Default: HDBS (for HiRDB/Single Server)
Specify the identifier of this HiRDB. This must be a unique HiRDB identifier.
3: Enter number of concurrently execute user (1-xxx [User]) >
Specify the number of concurrently executable users.
  • If you selected Connection License from the HiRDB/Single Server License selection menu, the number of licenses purchased is displayed as xxx. If there are more than 1025 licenses, 1024 is displayed as xxx.
  • If you selected CPU License from the HiRDB/Single Server License selection menu, 1024 is displayed.
4: Enter number of access tables per user (4-32000 [tables]) >
Default: 16
Specify the maximum number of tables that can be accessed simultaneously by a UAP.
5: Enter quantity of database update per day (0-2048 [MB]) >
Default: 100
Specify the volume of database updating per day.

(5) Display the Detail option setting menu

When items 1-5 have all been set, choose o to display the Detail option setting menu.

[Figure]

Items o-q are explained as follows:

o: Select this option to display the Detail option setting menu.
g: Select this option to start HiRDB system creation. HiRDB system creation can be executed after all necessary information has been specified on the Master menu and the Detail option setting menu.
r: Select this option to display the Create new rdarea menu. This option is not available until HiRDB system creation has been completed (by selecting g).
p: Select this option to display the Plug-in Setup menu.
This option is not available until HiRDB system creation has been completed (by selecting g).
t: Select this option to terminate HiRDB.
csh or sh: Select one of these options to transfer control to a shell environment:
csh: Transfers control to the c shell environment.
sh: Transfers control to the b shell environment.
q: Select this option to quit (cancel) system generator execution.

(6) Detail option setting menu (1/2) is displayed

This menu is used to specify information needed to create HiRDB system definitions.

Enter 1-13 and specify the appropriate information in response to the messages displayed. When you have entered all necessary information, choose n to go on to the next page.

[Figure]

The messages that are displayed when each of items 1-13 is entered are explained as follows:

1: Enter table definition buffer size (100-65535 [KB]) >
64-bit mode: (100-2000000 [kB])
Default: 1000
Specify the buffer size for table definition information.
2: Enter view definition buffer size (0-32000 [KB]) >
64-bit mode: (0-2000000 [kB])
Default: 0
Specify the buffer size of view analysis information.
3: Enter type definition buffer size (0 or 100-65535 [KB]) >
64-bit mode: (0 or 100-2000000 [kB])
Default: 100
Specify the buffer size for user-defined information.
4: Enter authorization information buffer size (1-100 [KB]) >
Default: 1
Specify the buffer size for user privilege information.
5: Enter routine definition buffer size (0 or 20-65535 [KB]) >
64-bit mode: (0 or 20-2000000 [kB])
Default: 100
Specify the buffer size for routine definition information.
6: Enter SQL object buffer size (22-256000 [kB]) >
64-bit mode: (22-2000000 [kB])
Default: 2000
Specify the buffer size for SQL objects. If plug-ins are to be used, take into account the size of the SQL objects used with the plug-ins.
7: Enter Global buffer size (4-460000 [buffer pages]) >
64-bit mode: (4-1073741824 [buffer pages])
Default: 350
Specify the size of the global buffer allocated to RDAREAs.
The permitted maximum value is 460,000 pages for 32-bit mode and 1073741824 pages for 64-bit mode, but a large value increases the shared memory size. With some OSs, the supported maximum shared memory size may be exceeded, resulting in an error during HiRDB startup.
For details about the shared memory size to be allocated, see 16.1.5 Formula for size of shared memory used by global buffers. For details about the maximum shared memory size that can be allocated, see the applicable OS documentation.
8: Enter work buffer size (384-1000000 [KB]) >
Default: 1024
64-bit mode: (383-2000000000 [kB])
Specify the buffer size for work tables. For details about how to estimate work table file sizes, see 19. Determining Work Table File Size.
9: Enter max rdarea number (5-8388608 [areas]) >
Default value: 200
Specify the maximum number of RDAREAs.
Enter max file number (5-134217728 [files]) >
Default: 400
Specify the maximum number of HiRDB files.
10: Enter permanent process number (1-XXX [process]) >
Specify the number of resident processes (number of processes for user request processing).
The value (number of concurrently executable users/2), which was specified on the Master menu, is displayed as xxx.
11: Enter lock pool size (1-2000000 [KB]) >
64-bit mode: (1-2000000000 [KB])
Default: 1000
Specify the lock pool size.
12: Enter RDAREA size (for Basic part) (0-1024 [MB]) >
Default: 5
Specify the size of the registry RDAREA. If you do not use the registry facility, specify a value of 0.
Enter RDAREA size (for long key value) (1-1024 [MB]) >
Default: 10
Specify the size of the registry LOB RDAREA. If you do not use the registry facility, specify a value of 0.
13: Enter data dictionary size (Basic part) (4-1024 [MB]) >
Default: 10
Specify the size of the data dictionary RDAREA.
Enter data dictionary size (for Procedure source) (1-1024 [MB]) >
Default: 10
Specify the size of the data dictionary LOB RDAREA for storing the source. If you do not use a stored procedure or stored function, specify a value of 0.
Enter data dictionary size (for Procedure object) (1-1024 [MB]) >
Default: 30
Specify the size of the data dictionary LOB RDAREA for storing the object. If you specified 0 as the size of the data dictionary LOB RDAREA for storing the source, this query is not displayed.
n: Select this option to go on to the next page.
q: Select this option to return to the Master menu.

(7) Detail option setting menu (2/2) is displayed

Enter 14-16 and specify appropriate information in response to the messages displayed. When you have entered all necessary information, choose q to return to the Master menu.

[Figure]

The following explains the messages that are displayed on the screen when you enter each of the numbers:

14: Enter lock wait time (0-32767 [second]) >
Default: 3600
Specify the lock-release wait time.
15: Enter sync point dump interval (100-32000 [logs]) >
Default: 1000
Specify the synchronization point dump interval. A synchronization point dump is obtained when the specified number of blocks of system log information have been output since the last effective synchronization point dump.
Enter sync point dump interval time (0 or 10-1440 [minute]) >
Default: 60
Specify the synchronization point dump interval. A synchronization point dump is obtained when the specified amount of time has elapsed since the last effective synchronization point dump. If 0 is specified, HiRDB will not obtain synchronization point dumps based on elapsed time.
16: Use assign list? (Y/N) >
Default: N
Specify whether or not to use a narrowed search.
To use a narrowed search, specify Y, in which case the following message is displayed:
Enter max list users number (1-32767 [users]) >
Specify the number of users for whom lists are to be created.
Enter max list count per user (1-32767 [lists]) >
Specify the number of lists that can be created per user.
b: Select this option to go back to the previous page.
q: Select this option to return to the Master menu.

(8) Master menu is displayed

Enter 6-12 and specify the appropriate information in response to the messages displayed. These items let you specify information about system files and RDAREAs here.

[Figure]

The messages that are displayed when each of items 6-12 is entered are explained as follows:

6: Select file type for system file
1: Raw 2: UNIX
Enter no >
Default: UNIX
Specify the number that indicates the file type of the HiRDB file system area for system files:
  • Raw: Character special file
  • UNIX: Regular file
For ease of construction, the default is regular file. To construct a highly reliable system, character special file should be selected.
7:
This option displays the Log option setting menu.
[Figure]
This option lets you set up an environment for the system log files.
Enter 1-3 and specify the appropriate information in response to the messages displayed. When you have entered all necessary information, choose q to return to the Master menu.
The following explains the messages that are displayed on the screen when you enter each of the numbers:
1: Use dual log file? (Y/N) >
Default: N
Specify whether or not to use dual log files. To use dual log files, specify Y. Dual system log files should be used to improve system reliability. For details about dual system log files, see 9.3.1 Designing system log files.
2: Check log unload status? (Y/N) >
Default: Y
Normally specify Y.
If you specify N, the system does not check the log's unload status. This operation mode may result in an error that makes database recovery impossible. For details about the operation mode that releases unload status checking, see the manual HiRDB Version 8 System Operation Guide.
3: Enter log file size (1-2048 [MB]) >
Default: MAX (1024, (a + 1) 1.5 )
a: The database update size specified with Master menu item 5.
Specify the size of one system log file.
HiRDB creates multiple system log files based on this size for a single system log file. The number of system log files to be created depends on the number of HiRDB file system areas and whether or not you use dual system log files.
q: Select this option to return to the Master menu.
8:
The HiRDB file system area for system files is initialized and then system files are created in that area. Enter appropriate information in response to the applicable message shown as follows:
Character special file

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.
The path name must be a character special file because Raw file system are selected.
(ex) /dev/dsk/rhd00301
Please type the file name carefully because all the data will lose in the special file.
The size of HiRDB-file-system-area will more than XXX [MB].

Enter file name with completely path > aa....aa
Enter HiRDB-file-system-area size
(=partition size of this character special file) [MB] > bb....bb

  • XXX
    Displays the size required for the HiRDB file system area for system files. Specify in aa...aa a character special file whose size is greater than this value.
  • aa...aa (path-name-of-character-special-file)
    Specify the absolute path name of the character special file to which the HiRDB file system area for system files is to be allocated.
    If the file name is symbolically linked, specify the symbolic link name. Symbolically linking a file name simplifies hard disk exchange in the event of hard disk failure. For details about symbolic linkage of file names, see 2.3.6 Preparing to create the HiRDB file system area.
    If an invalid name is specified, the corresponding character special file area is damaged; care must be taken to ensure that the correct name is specified.
  • bb...bb (partition-size)
    Specify in Mbytes the partition size for the character special file specified in aa...aa. If the specified size is greater than the actual partition size, an error results during system generation. If it is less than the actual partition size, no error results, but the remaining area is treated as invalid area because the system uses no more than the specified size of area.
Regular file

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 XXX [MB].
The HiRDB-file-system-area creates as UNIX file with specified size.

Enter file name with completely path > aa....aa
Enter HiRDB-file-system-area size [MB] > bb....bb

  • XXX
    Displays the size required for the HiRDB file system area for system files. Specify in aa...aa a regular file whose size is greater than this value.
  • aa...aa (path-name-of-regular-file)
    Default: Regular file named sysfiles under the HiRDB directory
    Specify the absolute path name of the regular file (name beginning with /) to which the HiRDB file system area for system files is to be allocated.
    If the file name is symbolically linked, specify the symbolic link name. Symbolically linking a file name simplifies hard disk exchange in the event of hard disk failure. For details about symbolic linkage of file names, see 2.3.6 Preparing to create the HiRDB file system area.
    If an invalid name is specified, the corresponding regular file area is damaged; care must be taken to ensure that the correct name is specified.
  • bb...bb (size-of-regular-file)
    Specify in Mbytes the size displayed in xxx. If system files are to be added later, add the additional size to xxx. If the specified size is greater than the available UNIX file system area, a shortage occurs. Care should be taken that the specified size of a UNIX file system area is actually available.
9:
Same as 8.
10:
Same as 8.
11: Select file type for RDAREA
1: Raw 2: UNIX
Enter 12>
Default UNIX
Specify the number that indicates the file type of the HiRDB file system area for RDAREAs:
  • Raw: Character special file
  • UNIX: Regular file
For ease of construction, the default is regular file. To construct a highly reliable system, character special file should be selected.
12:
This option initializes the HiRDB file system area for RDAREAs. The system uses this HiRDB file system area to store the RDAREAs that are created by the system generator.
The HiRDB administrator must enter the appropriate information in response to the following messages.
Character special file

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.
The path name must be a character special file because Raw file system are selected.
(ex) /dev/dsk/rhd00301
Please type the file name carefully because all the data will lose in the special file.
The size of HiRDB-file-system-area will more than XXX [MB].

Enter file name with completely path > aa....aa
Enter HiRDB-file-system-area size
(=partition size of this character special file) [MB] > bb....bb

  • XXX
    Displays the size required for the HiRDB file system area for RDAREAs. Specify in aa...aa a character special file whose size is greater than this value.
    Note that this size does not include the size of RDAREAs that are added with the Create new rdarea menu. If you are adding RDAREAs using the Create new rdarea menu, add the size of additional RDAREAs to this size.
  • aa...aa (path-name-of-character-special-file)
    Specify the absolute path name of the character special file to which the HiRDB file system area for RDAREAs is to be allocated.
    If the file name is symbolically linked, specify the symbolic link name. Symbolically linking a file name simplifies hard disk exchange in the event of hard disk failure. For details about symbolic linkage of file names, see 2.3.6 Preparing to create the HiRDB file system area.
    If an invalid name is specified, the corresponding character special file area is damaged; care must be taken to ensure that the correct name is specified.
  • bb...bb (partition-size)
    Specify in Mbytes the partition size for the character special file specified in aa...aa. If the specified size is greater than the actual partition size, an error results. If it is less than the actual partition size, no error results, but the remaining area is treated as invalid area because the system uses no more than the specified size of area.
Regular file

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 XXX [MB].
The HiRDB-file-system-area creates as UNIX file with specified size.

Enter file name with completely path > aa....aa
Enter HiRDB-file-system-area size [MB] > bb....bb

  • XXX
    Displays the size required for the HiRDB file system area for RDAREAs. Specify in bb...bb a regular file whose size is greater than this value.
    Note that this size does not include the size of RDAREAs that are added with the Create new rdarea menu. If you are adding RDAREAs using the Create new rdarea menu, add the size of additional RDAREAs to this size.
  • aa...aa (path-name-of-regular-file)
    Default: Regular file named rdfiles under the HiRDB directory
    Specify the absolute path name of the regular file (name beginning with /) to which the HiRDB file system area for RDAREAs is to be allocated.
    If the file name is symbolically linked, specify the symbolic link name. Symbolically linking a file name simplifies hard disk exchange in the event of hard disk failure. For details about symbolic linkage of file names, see 2.3.6 Preparing to create the HiRDB file system area.
    If an invalid name is specified, the corresponding regular file area is damaged; care must be taken to ensure that the correct name is specified.
  • bb...bb (size-of-regular-file)
    Specify in Mbytes the size displayed in xxx plus the required size for user RDAREA creation area. If the specified size is greater than the available UNIX file system area, a shortage occurs. Care should be taken that the specified size of a UNIX file system area is actually available.

(9) Start the HiRDB environment setup

Specify g to start the HiRDB environment setup. The HiRDB environment is set up on the basis of the information specified so far.

[Figure]

(10) Message is displayed

A message is displayed that reports that the HiRDB system is being created. While the HiRDB system is being created, each command that executes is displayed together with an execution results message:

Start HiRDB system generation
Creating HiRDB deffinition files (/HiRDB/conf)
Definition files are created

Push enter key to main menu >

When creation processing is completed, press the Enter key.

If an error is detected, the corresponding command's message is displayed. The HiRDB administrator must take action appropriate to the displayed message. After all errors have been corrected, terminate the system generator, then re-execute it. To terminate the system generator, enter q on the main menu.

(11) Master menu is displayed

To create a user RDAREA, LOB RDAREA, or list RDAREA, enter r to display the Create new rdarea menu.

[Figure]

(12) Create new rdarea menu is displayed

Set information about the RDAREA that is to be added.

Enter 1-7 and specify appropriate information in response to the displayed messages. When all necessary information has been entered, select a to add the RDAREA.

[Figure]

The messages that are displayed when each of items 1-7 is entered are explained as follows:

1: Enter rdarea name >
Specify with 1-16 upper-case alphanumeric characters the name of the RDAREA to be created.
If the name of an existing RDAREA is specified, an error results.
2: Enter rdarea size (1[MB]) >
Default: 100
Specify the size of the RDAREA.
3: Enter segment size (1-16000 [Pages]) >
Default: 1000
Specify the segment size of the RDAREA.
4: Enter page size (4-30 [KB]) >
Default: 4
Specify the page size of the RDAREA.
5: 1: for Table/Index data
2: for Binary large object data
3: for List
Enter rdarea type (1-3) >
Default: 1
Specify the type of RDAREA to be created.
1: User RDAREA
2: User LOB RDAREA
3: RDAREA for lists
6: Enter Global buffer number for this rdarea (4-460000 [buffer pages] >
64-bit mode: (4-1073741824 [buffer pages])
Default: 350
Specify the size of the global buffer to be allocated for the RDAREA.
The permitted maximum value is 460,000 pages for 32-bit mode and 1073741824 pages for 64-bit mode, but a large value increases the shared memory size. With some OSs, the supported maximum shared memory size may be exceeded, resulting in an error during HiRDB startup.
For details about the shared memory size to be allocated, see 16.1.5 Formula for size of shared memory used by global buffers. For details about the maximum shared memory size that can be allocated, see the applicable OS documentation.
7: Enter HiRDB file system area name for this rdarea (complete path name) >
Default: $PDDIR/rdfiles
Specify the absolute path name of the HiRDB file system area for RDAREAs (name beginning with /). The specified HiRDB file system area must be one of the following:
  • HiRDB file system area for RDAREAs that was specified on the Master menu.
  • HiRDB file system area for RDAREAs that was specified with the pdfmkfs command.
If any other HiRDB file system area is specified, an error occurs when the RDAREA is added (when a is selected).
a: Select this option to add the RDAREA.
l: Select this option to display a list of RDAREAs that have been created.
Following is an example:
[Figure]
q: Select this option to return to the Master menu.

(13) Master menu is displayed again

To add another RDAREA, repeat step (12).

When all RDAREAs have been added, enter q to return to the Master menu.

[Figure]

When an RDAREA has been added, the following message is displayed:

Rdarea are added. You have to restart HiRDB to use the area.
Restart now ? (Y/N) >

To use the added RDAREA immediately, enter Y to restart HiRDB.

To use it later (the next time HiRDB is started), enter N (in which case HiRDB will not be restarted).

(14) Master menu is displayed

To set up and register a plug-in, enter p to display the Plug-in Setup menu.

[Figure]

(15) Plug-in Setup menu is displayed

This menu is used to set information about a plug-in that is to be set up and registered.

Enter 1-4 and specify appropriate information in response to the displayed messages, then enter s to set up and register the plug-in.

[Figure]

The messages that are displayed when each of items 1-4 is entered are explained as follows:

1: Select Plugin for Setup
1: Text Search Plug-in
2: Image Search Plug-in
3: Spatial Search Plug-in
o: Other Plugin
Enter no >
Specify the number that indicates the plug-in to be set up.
If you choose o, specify the name of the plug-in.
2: Enter Plugin PP installed directory name >
Specify the directory in which the plug-in is installed.
If you choose 1, 2, or 3 at item 1, the message Assume by pdgen is displayed on the screen.
3: Enter Plugin definition file name >
Specify the name of the plug-in definition file.
If you choose 1, 2, or 3 at item 1, the message Assume by pdgen is displayed on the screen.
4: Enter Plugin PIC file name >
Specify the name of the PIC file.
If you choose 1, 2, or 3 at item 1, the message Assume by pdgen is displayed on the screen.
s: Select this option to set up the plug-in.
l: Select this option to display a list of plug-ins that have been set up. Following is an example:
[Figure]
q: Select this option to return to the Master menu.

(16) Master menu is displayed again

To set up and register another plug-in, repeat step (15).

When all plug-ins have been set up and registered, enter q to return to the Master menu.

[Figure]

When a plug-in has been set up and registered, the following message is displayed:

Plugin are setup. You have to restart HiRDB to use the Plugin.
Restart now ? (Y/N) >

To use immediately the plug-in that has just been set up and registered, enter Y to restart HiRDB. To use it later (the next time HiRDB is started), enter N (in which case HiRDB will not be restarted).

If plug-in setup or registration fails, determine the cause of the failure, then terminate HiRDB (if it is active) by specifying t on the Master menu. If HiRDB is engaged in termination processing, also terminate the system generator. When the system generator is terminated, use pdsetup -d to cancel the registration in the OS, and then reexecute pdsetup. In this case also, the plug-in registration authorization identifier is MASTER.

(17) Master menu is displayed again

System construction by the system generator is now complete, and the system generator can be terminated. HiRDB has already been started at this point.