Nonstop Database, HiRDB Version 9 System Operation Guide
![[Contents]](FIGURE/CONTENT.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
24.7.3 Procedure when an error occurs during data loading
(1) When executing in the log acquisition mode or the pre-update log acquisition mode
- Procedure
- 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.
- 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.
- 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
- Use the pdrstr command and a backup made before data loading was executed to recover the RDAREA that stores the audit trail table.
- 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.
- Re-execute the pdload command. If file=all is specified, specify the control information file to be data loaded in the file operand.
All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.