Report-Specification Command Examples

The following examples illustrate the use of report-specification commands. Detailed explanations of the individual commands are in “Report-Specification Commands” in this section. A sample of the report produced by each example is shown in Examples 1 through 9.

Example 1

In the following example, the REPORT command signifies the beginning of the report specifications. The SOURCE command selects the JOBSUMMARY file as the source of information for the report. The OUTPUT command selects the TYPE, MIXNO, JOBNO, NAME, PRIORITY, ORGUNIT, CHARGECODE, PROCESSTIME, and IOTIME file data items to be printed. The END command signifies the end of the report-specification commands.

REPORT
SOURCE IS JOBSUMMARY
OUTPUT ITEMS ARE TYPE, MIXNO, JOBNO, NAME, PRIORITY, ORGUNIT,-
  CHARGECODE, PROCESSTIME, IOTIME
END

The following is the resulting report.

Example 2

In the following example, the REPORT command signifies the beginning of the report specifications. The SOURCE command selects the JOBSUMMARY file as the source of information for the report. The HEADING command specifies LOG SORTED BY TIME to be used as the heading for the report.

The SORT command specifies that the report is sorted by the STARTTIME file data item. The OUTPUT command selects the MIXNO, TYPE, STARTTIME, NAME, USERCODE, PRIORITY, ELAPSEDTIME, and TERMCOND file data items to be printed. The END command signifies the end of the report-specification commands.

REPORT
SOURCE FILE IS JOBSUMMARY
HEADING IS "LOG SORTED BY TIME"
SORT BY STARTTIME
OUTPUT ITEMS ARE MIXNO, TYPE, STARTTIME, NAME, USERCODE,-
  PRIORITY, ELAPSEDTIME, TERMCOND
END

The following is the resulting report.

Example 3

In the following example, the REPORT command signifies the beginning of the report specifications. The SOURCE command selects the JOBSUMMARY file as the source of information for the report.

The BREAK command specifies the USERCODE file data item to act as a control break. Each usercode is printed on a separate line every time the value of the control break item changes.

The SORT command specifies sorting by more than one file data item. The output is sorted in ascending order first by USERCODE and then by MIXNO.

The OUTPUT command selects the TYPE, MIXNO, NAME, LINES, AVGCORECODE, AVGCOREDATA, DATE, PRIORITY, and ORGUNIT file data items to be printed.

The HEADING command causes the heading JOB/TASK/SESSION SUMMARY BY USERCODE to be printed at the top of every page. The PAGE SIZE command specifies that 56 lines are to be printed on each page. The END command signifies the end of the report-specification commands.

REPORT
SOURCE FILE IS JOBSUMMARY
BREAK ON USERCODE
SORT BY USERCODE, MIXNO ASCENDING
OUTPUT ITEMS ARE TYPE, MIXNO, NAME, LINES, AVGCORECODE,-
  AVGCOREDATA, DATE, PRIORITY, ORGUNIT
HEADING IS "JOB/TASK/SESSION SUMMARY BY USERCODE"
PAGE SIZE IS 56
END

The following is the resulting report.

Example 4

In the following example, the REPORT command signifies the beginning of the report specifications. The SOURCE command selects the JOBSUMMARY file as the source of information for the report.

The SORT command specifies sorting by more than one file data item. The output is sorted in ascending order by NAME, USERCODE, and STARTTIME.

The BREAK command specifies the NAME file data item to act as a control break. Each name is printed on a separate line each time the value of the control break item changes.

The INCLUDE and EXCLUDE commands specify that only MCS sessions and jobs of user SITE that do not have a chargecode of SKIP are processed for the report. The HEADING command specifies REPORT FOR USERCODE DBH to be used as the heading for the report.

The OUTPUT command selects the TYPE, MIXNO, NAME, LINES, AVGCORECODE, AVGCOREDATA, DATE, PRIORITY, and ORGUNIT file data items to be printed. The END command signifies the end of the report-specification commands.

REPORT
SOURCE JOBSUMMARY
SORT BY NAME, USERCODE, STARTTIME
BREAK ON NAME
INCLUDE RECORD IF TYPE = "S"
INCLUDE RECORD IF TYPE = "J"
EXCLUDE RECORD IF USERCODE NEQ "SITE"
EXCLUDE RECORD IF CHARGECODE = "SKIP"
HEADING IS "REPORT FOR USERCODE DBH"
OUTPUT ITEMS ARE TYPE, MIXNO, NAME, STARTTIME, ELAPSEDTIME
END

The following is the resulting report.

Example 5

In the following example, the REPORT command signifies the beginning of the report specifications. The SOURCE command selects the JOBSUMMARY file as the source of information for the report.

The INCLUDE command specifies that only MCS sessions are processed for the report. The SORT command specifies the output to be sorted by the USERCODE file data item.

The BREAK command specifies that totals be accumulated and printed for PROCESSTIME and IOTIME each time the value of the control break item (DATE) changes. The HEADING command specifies MCS SESSION SUMMARY to be used as the heading for the report.

The OUTPUT command selects the MIXNO, MCSNAME, LSN, STANAME, LOGONREASON, LOGOFFREASON, PROCESSTIME, IOTIME, and STARTTIME file data items to be printed. The END command signifies the end of the report-specification commands.

REPORT
SOURCE IS JOBSUMMARY
INCLUDE RECORD IF TYPE = "S"
SORT BY USERCODE
BREAK ON USERCODE TOTALING PROCESSTIME, IOTIME
HEADING "MCS SESSION SUMMARY"
OUTPUT ITEMS ARE MIXNO, MCSNAME, LSN, STANAME, LOGONREASON,-
  LOGOFFREASON, PROCESSTIME, IOTIME, STARTTIME
END

The following is the resulting report.

Example 6

In the following example, the REPORT command signifies the beginning of the report specifications. The SOURCE command selects the JOBSUMMARY file as the source of information for the report. The SORT command specifies the output to be sorted first in descending order by the USERCODE file data item, and then in ascending order by the NAME file data item.

The first BREAK command specifies that totals be accumulated and printed for PROCESSTIME and IOTIME each time the value of the control break item (USERCODE) changes. An average for the elapsed time is also printed. The second BREAK command specifies that totals be accumulated and printed for PROCESSTIME, IOTIME, MEMINTCODE, and MEMINTDATA each time the value of the control break item (NAME) changes.

The INCLUDE command specifies that only tasks are processed for the report. The OUTPUT command selects the MIXNO, PROCESSTIME, IOTIME, CARDSREAD, LINES, MEMINTCODE, MEMINTDATA, STARTTIME, and ELAPSEDTIME file data items to be printed. The HEADING command specifies PROGRAM SUMMARY BY USERCODE to be used as the heading for the report.

SUMMARY 1 in the REPORTS command causes totals to be printed for the control break item specified in the first BREAK command (USERCODE). SUMMARY 2 in the REPORTS command causes totals to be printed for the control break item specified in the second BREAK command (NAME). The totals generated by the REPORTS command are printed immediately after a corresponding dashed line is printed. The END command signifies the end of the report-specification commands.

REPORT
SOURCE FILE IS JOBSUMMARY
SORT BY USERCODE DESCENDING, NAME ASCENDING
BREAK ON USERCODE TOTALING PROCESSTIME, IOTIME AVERAGING-
  ELAPSEDTIME
BREAK ON NAME TOTALING PROCESSTIME, IOTIME, MEMINTCODE,-
  MEMINTDATA
INCLUDE RECORD IF TYPE  = "T"
OUTPUT ITEMS ARE MIXNO, PROCESSTIME, IOTIME, CARDSREAD, LINES,-
  MEMINTCODE, MEMINTDATA, STARTTIME, ELAPSEDTIME
HEADING IS "PROGRAM SUMMARY BY USERCODE"
REPORTS ARE DETAILED SUMMARY 1 SUMMARY 2
END

The following is the resulting report.

Example 7

In the following example, the REPORT command signifies the beginning of the report specifications. The SOURCE command selects the STATISTICS file as the source of information for the report.

The HEADING command specifies SUMMARY STATISTICS to be used as the heading for the report. The OUTPUT command selects the TIME, DISK, TAPE, READER, REMOTE, MISCFILES, TASKS, JOBS, HL, MAXTASKS, and MAXJOBS file data items to be printed.

The BREAK command specifies that totals be accumulated and printed for DISK, TAPE, READER, REMOTE, TASKS, JOBS, and HL each time the value of the control break item (DATE) changes. The END command signifies the end of the report-specification commands.

REPORT
SOURCE FILE IS STATISTICS
HEADING IS "SUMMARY STATISTICS"
OUTPUT ITEMS ARE TIME, DISK, TAPE, REMOTE, MISCFILES,-
  TASKS, JOBS, HL, MAXTASKS, MAXJOBS
BREAK ON DATE TOTALING DISK, TAPE, REMOTE, TASKS,-
  JOBS, HL
END

The following is the resulting report.

Example 8

In the following example, the REPORT command signifies the beginning of the report specifications. The SOURCE command selects the FILEIODATA file as the source of information for the report.

The OUTPUT command selects the MIXNO, INTNAME, EXTNAME, USE, KIND, FILEKIND, RETENTION, and IOTIME file data items to be printed. The HEADING command specifies FILE USAGE REPORT to be used as the heading for the report. The END command signifies the end of the report-specification commands.

REPORT
SOURCE FILE IS FILEIODATA
OUTPUT ITEMS ARE MIXNO, INTNAME, EXTNAME, USE, KIND, FILEKIND,-
  RETENTION, IOTIME
HEADING IS "FILE USAGE REPORT"
END

The following is the resulting report.

Example 9

In Example 9, the DRCONLY option indicates that only DRC data is to be collected, the REPORT command signifies the beginning of the report specifications, and the SOURCE command selects the DRCDATA files as the source of information for the report.

The SORT command selects the USERCODE, CHARGECODE, and ASCENDING options. The OUTPUT command selects the USERCODE, PACKNAME, DISKINUSE, MBYTEDAYS, USEDATE, USETIME, and CHARGECODE options as the data items to be printed.

The BREAK command specifies that totals be accumulated and printed for DISKINUSE and MBYTEDAYS each time the value of the CHARGECODE and USERCODE control breaks change. The totals generated by the REPORTS command are printed immediately after a corresponding line of hyphens (-) is printed.

The END command indicates the end of the report-specification commands.

OPTION DRCONLY
REPORT
SOURCE IS DRCDATA
SORT BY USERCODE, CHARGECODE, ASCENDING
OUTPUT ITEMS ARE USERCODE, PACKNAME, DISKINUSE, MBYTEDAYS, USEDATE,
USETIME, CHARGECODE
BREAK ON USERCODE, CHARGECODE TOTALING DISKINUSE, MBYTEDAYS
REPORTS ARE DETAILED SUMMARY 1 SUMMARY 2
END

The following is the resulting report.