Jobs-SQL Tables Report

This report shows for each job, all the SQL tables accessed based on the usage of the related programs.

To generate this report, go to Explore Projects view and select Mainframe Reports list. Select Where Used Reports, then double-click the desired report to display the report wizard.

The Available Jobs area displays the resources available for report generation and allows the user to select the resources to be included in the report. Use the Name field to filter the contents of the list. In Report generation options area, the selection indicates that the report appendix is displayed by default. Choose what additional data to include in the appendix: show input details in appendix. Use the arrow buttons to move the resources between the Available and Selected lists then click Finish to generate the report.

The Report summary section presents two charts presenting SQL tables usage ratio and Used SQL tables distribution.

The Report details section presents for each job the SQL tables that are accessed through the selected job as well as the name of the entity using the job to access the SQL table and the number of occurrences.