Nonstop Database, HiRDB Version 9 System Operation Guide

[Contents][Index][Back][Next]

24.7.3 Procedure when an error occurs during data loading

This section explains the procedure when an error occurs during data loading.

Organization of this subsection
(1) When executing in the log acquisition mode or the pre-update log acquisition mode
(2) When executing in the no-log mode

(1) When executing in the log acquisition mode or the pre-update log acquisition mode

Procedure
  1. Check the progress of data load processing. Because a commit occurs for each audit trail file during data loading, data loading is completed when the KFPL00800-I message is output for an audit trail file.
    Use the pdls -d aud command to check the audit trail file status. Files for which data loading has been completed enter data load completed status.
  2. Check whether the KFPL23202-E message has been output. Data loading has been completed for an audit trail file for which the KFPL23202-E message is output, but the file's status failed to change. Therefore, such files remain in data load waiting status, which means that if the pdload command is re-executed the data might be recorded again. For this reason, you should use the pdaudrm command to delete such files before re-executing the pdload command.
  3. Re-execute the pdload command. There is no need to change the option specifications or the control information file specification.

(2) When executing in the no-log mode

Procedure
  1. Use the pdrstr command and a backup made before data loading was executed to recover the RDAREA that stores the audit trail table.
  2. Audit trail files for which data loading has been completed enter data load completed status. Therefore, even if the pdload command is re-executed, these files in data load completed status will not be data loaded. In this case, specify mode=force and re-execute the pdload command.
  3. Re-execute the pdload command. If file=all is specified, specify the control information file to be data loaded in the file operand.