Load Process Report

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.

Load Process Report

The Load Process Report displays the following information:

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:

Row Details

Information is provided for each table:

Save the Report

To save the report to a file, click File > Save As to open the Windows Save dialog.

Print the Report

To print the report, click File > Print to open the Windows Print dialog.

Redisplay the Report

If you close the report and want to refer to it again, click File > Redisplay Results, 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.