7.7.2 Example

This example assumes that the database load utility terminated while loading three million entries of data in the batch index creation mode with one million line numbers with synchronization points.

Organization of this subsection
(1) Checking the messages
(2) Using the pdrorg command to create the plug-in index in batch mode
(3) Reexecuting data loading
(4) Making a backup of the target data storage RDAREAs
(5) Using the pdrels command to release the target data storage RDAREAs from shutdown status

(1) Checking the messages

The following messages are output:

KFPL00800-I Loading until 2000000​th row committed

KFPL00710-I Index information file assigned, index=k87m271."INDX01",
RDAREA="LOB02", file=/pdrorg/INDX01_2

KFPL00715-I Index load started at bes2, index=k87m271."INDX01", RDAREA="LOB02"

Explanation:
  • The KFPL00800-I message indicates that two million data entries have already been loaded.
  • The KFPL00715-I message indicates that the creation of the plug-in index has begun, but a completion message corresponding to this message (KFPL00716-I) has not been output.
This indicates that the utility terminated abnormally while creating the plug-in index for one to two million entries.

(2) Using the pdrorg command to create the plug-in index in batch mode

Use the database reorganization utility to create the plug-in index for one million (one to two million) entries in batch mode.

pdrorg -k ixmk -t TABLE1 /pdrorg/rorg01

Explanation:
-k: Specifies ixmk to create the plug-in index in batch mode.
-t: Specifies the name of the table.
/pdrorg/rorg01:
Specifies the name of the control statement file for the pdrorg command. The contents of the control statement file are shown as follows. The index information file that is specified in the control statement file is indicated in the KFPL00710-I message, which was output in (1).

index INDX01 LOB02 /pdrorg/INDX01_2

(3) Reexecuting data loading

pdload TABLE1 /pdload/load01

Explanation:
There is no need to change the option specification.

(4) Making a backup of the target data storage RDAREAs

Make a backup of the target data storage RDAREAs. For details about making backups in units of RDAREAs, see the manual HiRDB Version 8 System Operation Guide.

(5) Using the pdrels command to release the target data storage RDAREAs from shutdown status

Enter the pdrels command to release the table and index storage RDAREAs from shutdown status.

pdrels -r DATA01,DATA02,DATA03,INX01,INX02,INX03,LOB01,LOB02,LOB03

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 8 Command Reference.