The Load Process generates a Load Process Report that provides
general information and statistics about the Load Process.
Here is an example of the Load Process Report.
The Load Process Report
displays the following information:
- Name of the Load Request (or “Untitled” if not saved).
- Name of the Server or Local, for client workstation.
- Directory path and name of the Source File used
as input to the process.
- Directory path and name of the Control File specified
in the Load Request.
- Name of the Table Map or LOCAL, as specified in
the Load Request.
- User IDs of the user requesting the Load Process.
- Date and time the process started.
- Date and time the process finished.
- Elapsed time for the Load Process to complete.
- The status of the Load Process.
Note: The Time Started, Time Finished, and Elapsed Time refer
to the conversion phase of the process only.
Errors
If any
errors or warnings occur during processing, a list of the errors or
warnings is provided. Review the list of errors that caused processing
to stop. For example, an internal error condition exists when the
process exceeds the discard row limit or if you are not authorized
to access a particular database table.
Load Process Informational Messages
Informational messages are displayed in the Load Process
Report if you specified FTP options on the DB Alias tab
for the MVS™ S390
loader. Each message includes the name of the dataset transmitted
to the S390, whether the dataset was transmitted successfully, and
the table(s) for which the dataset was transmitted. For example:
‘PSTDJH.LOAD02.fulldemo.X001' was successfully
sent to FTP Server S390QA for table PSTDSNY.PSTDJH.CUSTOMERS.
The last qualifier of the transmitted dataset indicates
the type of dataset:
- .Xnnn
- A file in TSO Transmit/Receive format.
- .Snnn
- A file containing the Load SQL statement to load
the table.
- .Innn
- A file in DB2® IXF
format, received by the TSO Receive command.
- .JCL
- A file containing the JCL to submit to the S390.
The JCL receives, loads, and deletes the transmitted datasets. This
message also indicates the job number.
Process Summary
Statistics
are provided for data preparing to load:
- Total number of Tables Processed.
- Total number of Rows Extracted.
- Total number of Rows Converted.
- Total number of Rows with Errors.
Row Details
Information
is provided for each table:
- Number of extracted rows.
- Number of converted rows.
- Number of failed rows.
- List of tables used in the Load Process. The tables
are listed in the same order as in the Source File. If a table was
selected on the Fast Load Confirmation dialog,
the table name is underscored.
Save the Report
To
save the report to a file, click to open the Windows
Save dialog.
Print the Report
To
print the report, click to open the Windows
Print dialog.
Redisplay the Report
If you close the report and want to
refer to it again, click , and then
click Current to redisplay the report from
the last Load Process run, or click All to
display a list of all retained Load Process reports. For details about
retaining process reports, see the Common Elements Manual.