REPORT (Generate Reports) › Statistics and Diagnostics Area (PXX) Report › Information Available for Reporting

Information Available for Reporting

All information physically in the PXX is available to print since the MUF was last enabled or the last time the PXX was cleared. If the PXX becomes full, no new information is added until after it is cleared. Job and system statistic information in the report is available based upon the PXXSTATS Multi-User startup options. If PXXSTATS is set to DETAIL (or allowed to default), the MUF writes the information at every URT close where the PXX was not currently full. If PXXSTATS is set to EOJPRT, the MUF writes the summary statistics to the MUF EOJ report instead of to the PXX. If PXXSTATS is set to EOJ, the MUF writes one set of statistics to the PXX during the EOJ of the MUF where it is available until the next time the MUF is enabled.

Specifying PXXSTATS EOJ results in the MUF statistics record being written only one time and only at EOJ. This means that if the MUF is abended or canceled and there is no EOJ, those statistics are not available to the DBUTLTY function REPORT AREA=PXX. Attempts to use the REPORT function to print those statistics therefore generates DATABASE NOT ENDED error messages instead of written statistics.

If the MUF ends normally with PXXSTATS EOJ specified, at EOJ a single set of statistical records are written to the PXX. Running the DBUTLTY REPORT AREA=PXX function then gives different results depending on the combinations of options you specify. With PXXSTATS EOJ we recommend using the following:

DBUTLTY REPORT AREA=PXX,SYSSTAT=SUMMARY,JOBSTAT=SUMMARY

This gives SYSTEM summary STATS (database requests down to requests pending) plus JOBSTAT summaries (AREA and TABLE requests and I/O statistics). Other possible option specifications include the following:

1. DBUTLTY REPORT AREA=PXX,SYSSTAT=SUMMARY gives SYSTEM summary STATS but not JOBSTAT summaries.
2. DBUTLTY REPORT AREA=PXX,SYSSTAT=DETAIL gives one copy of SYSTEM summary STATS with a jobname matching the MUF, plus JOBSTAT summaries for the same jobname, then the SYSTEM summary STATS again, then JOBSTAT summaries again. In this case, statistics are unnecessarily duplicated.

For detailed information about Multi-User startup options, see the CA Datacom/DB Database and System Administration Guide.

In addition to the statistics and diagnostic information routinely generated by CA Datacom/DB, use the DBUTLTY COMM ALTER function to request that CA Datacom/DB generate trace information, dumps, and messages to assist in problem determination. See COMM ALTER (Modify Error Table) for details on the COMM ALTER function.