dbload command status reporting
The dbload command returns status codes when it finishes running.
The status
codes are as follows:
- 0
- The load was successful. All input records were inserted.
- 1
- The load failed. No records were inserted, because of an error or errors during the load.
- 2
- The load was successful. The system found errors in input that did not exceed the error threshold (as specified by the -maxErrors option), so good records were inserted.
The dbload command writes high-level errors to the terminal (stderr), *.log file, and *.bad file. You can specify the *.log and *.bad file names on the command line or by using a control file.
To free up disk space, periodically delete log files.