(a) Create a directory for the index information files

A directory for the index information files must be created. The index information files are created in this directory.

Hint

• Index information files become very large. Create this directory on a disk that has sufficient free space. For details about the size of index information files, see 14.8.4(1) Index information files.
• To avoid duplication of file names, no other files (other than index information files) should be placed in this directory.
• Because HiRDB creates and deletes files in this directory, the HiRDB administrator must have write privilege for this directory.

(b) Specify the pd_plugin_ixmk_dir operand

Correct the HiRDB system definition. First, terminate HiRDB normally.

HiRDB single server configuration

The name of the directory created in (a) is specified in the pd_plugin_ixmk_dir operand of the single server definition.

HiRDB parallel server configuration

The name of the directory created in (a) is specified in the pd_plugin_ixmk_dir operand in the back-end server definition for the back-end server that contains the table that is to be processed. If the table is row-partitioned and stored in multiple servers, the pd_plugin_ixmk_dir operand must be specified in the back-end server definition of each such back-end server.

(c) Specify PDPLGIXMK=YES in the client environment definition

PDPLGIXMK=YES must be specified in the client environment definition (for details of the PDPLGIXMK operand, see the HiRDB Version 9 UAP Development Guide).

(a) Create a HiRDB file system area for the index information file

 
pdfmkfs -n 50 -l 256 -k UTL -e 60000 /hd001/ixdir
 

Explanation

• -l option specifies the number of RDAREAs (number of RDAREAs in the server) that will store the plug-in indexes to be updated by this facility.
• -k option specifies UTL.
• -e option specifies 60000.
• The HiRDB file system area created here must be used only for index information files to be used in delayed batch creation of plug-in indexes.
• Create the HiRDB file system area in a character special file on the shared disk.
• Index information files become very large. Create this directory on a disk that has sufficient free space. For details about the size of index information files, see 14.8.4(1) Index information files.
• To avoid duplication of file names, do not store any files other than index information files in this HiRDB file system area.
• Creation and deletion of files in the HiRDB file system area created here are performed by HiRDB. Therefore, the HiRDB administrator's write privilege is required for this HiRDB file system area.

(b) Specify the pd_plugin_ixmk_dir operand

Correct the HiRDB system definition. First, terminate HiRDB normally.

HiRDB single server configuration

Specify the name of the HiRDB file system area created in step (a) in the pd_plugin_ixmk_dir operand of the single server definition; specify this name as an absolute path name.

HiRDB parallel server configuration

Specify the name of the HiRDB file system area created in step (a) in the pd_plugin_ixmk_dir operand of the back-end server definition for the back-end server in which the target table is located; specify this name as an absolute path name. If the table is row-partitioned between servers, specify the pd_plugin_ixmk_dir operand in the back-end server definition of each such back-end server.

(c) Add operands to the client environment definition

Specify the following operands in the client environment definition (for details of these operands, see the HiRDB Version 9 UAP Development Guide):

Guideline for estimating the number of updatable plug-in indexes

If the PDPLGPFSZ and PDPLGPFSZEXP operands are omitted, 8,192 KB is used as the default for both operands. The number of updatable plug-in indexes in such a case will be as follows:

Plug-in used	Without incremental increases	With incremental increases
HiRDB Text Search Plug-in	215,000 indexes	5,160,000 indexes

Specification example of the PDPLGPFSZ and PDPLGPFSZEXP operands

Shown below is a specification example of the above operands when multiple plug-in indexes are updated.

Example

• File size of plug-in index 1: 10,240 KB
• File size of plug-in index 2: 81,920 KB

Example of specifying the PDPLGPFSZ and PDPLGPFSZEXP operands for this case:

 
   PDPLGPFSZ=10240
   PDPLGPFSZEXP=10240
 

With these specifications, the file size of plug-in index 2 is increased seven times, and file areas can be used without any waste of space. Note that each file can be increased in size up to 23 times.