Previous Topic: Length of Time to ExecuteNext Topic: Generating a PXX Report


How to Use

To obtain a Statistics and Diagnostics Area Report, execute the REPORT function with the following command format:

►►─ REPORT AREA=PXX ─┬─────────────────────────┬─┬─────────────────────┬──────►
                     └─ ,DUMPS= ─┬─ FULL ────┬─┘ └─ ,JOBNAME=jjjjjjjj ─┘
                                 ├─ REQUEST ─┤
                                 └─ TRACE ───┘

 ►─┬───────────────────────────┬─┬───────────────┬────────────────────────────►
   └─ ,JOBSTAT= ─┬─ DETAIL ──┬─┘ └─ ,RTNCODE=nn ─┘
                 ├─ DETAILX ─┤
                 └─ SUMMARY ─┘

 ►─┬───────────────────────────┬──────────────────────────────────────────────►◄
   └─ ,SYSSTAT= ─┬─ DETAIL ──┬─┘
                 ├─ DETAILX ─┤
                 └─ SUMMARY ─┘

Command

REPORT

Invokes the function to produce a report.

Required Keywords

Note: You must include at least one of the keywords:DUMPS, JOBSTAT, or SYSSTAT.

AREA=PXX

Requests the Statistics and Diagnostics Area Report.

,DUMPS=

Specifies that formatted dumps are to be printed.

FULL

Dumps Master List, buffer areas, Request Area, and Compound Boolean Selection Facility (CBS) Diagnostic Report.

The process of producing dumps has changed. Dumps are produced using new (in Version 12.0) and faster memory management methods that support 64-bit addressing. Because of this enhanced processing and to simplify it, the following changes were made:

Dump Addresses Format Changes

The formatting of dumps has changed in Version 12.0 to show addresses in 64-bit memory that start with one byte, followed by an underscore, then the address within 64-bit memory. This new way of formatting dump addresses appears in both the DBUTLTY REPORT AREA=PXX and in the Master List dump output directed to the PXXML by the SYSOUT Multi-User startup option.

STATBFR Startup Option Removed

You are not, in Version 12.0, allowed to specify STATBFR in the Multi-User startup. The STATBFR Multi-User startup option was previously used to specify the size of the buffer that accumulates system and job statistics, but STATBFR was removed in Version 12.0. Complete statistics are now always provided when requested.

.ECSA Changes

The Master List in the ECSA is now labeled DB_ML_ECSA. If a communication area exits for DB_ML_ECSA, its label is COMMECSA.

Message DB02406I Changed

To support the change in dump processing in Version 12.0, message DB02406I has changed. The message text could previously contain a variable, replaced with a ML or a BFR, that could possibly be separated by another PXX dump. The multiple parts of the process, and the variable in the message for ML or BFR, have been removed in Version 12.0. The process now has a single completion. In addition, text describing the error has been added to the end of the message. For details, see the CA Datacom/DB Message Reference Guide.

REQUEST

Prints only the Request Area portion of the dumps.

TRACE

Produces only the Compound Boolean Selection Facility (CBS) Diagnostic Report and the SQL trace information requested through the DBUTLTY COMM ALTER function. See Reporting on the Compound Boolean Selection Facility and COMM ALTER (Modify Error Table).

Valid Entries:

FULL, REQUEST, TRACE

Default Value:

No dumps are printed.

,JOBSTAT=

Indicates that a job statistics report is to be printed.

Note: To get JOBSTAT information, either comment out the PXXSTATS Multi-User startup option or specify it as PXXSTATS DETAIL. Detailed information about Multi-User startup options can be found in the CA Datacom/DB Database and System Administration Guide.

DETAIL

Performs a top of form and prints JOBSTAT detail, causing each JOBSTAT to start on a new page.

DETAILX

Skips three lines and prints JOBSTAT detail, causing JOBSTAT information to print on the same page with other information.

SUMMARY

Performs a top of form and prints only the summary information from each job close.

Valid Entries:

DETAIL, DETAILX, or SUMMARY

Default Value:

No JOBSTAT information is printed.

,SYSSTAT=

Indicates that system statistics information is to be printed. The value you code for this keyword specifies the format of the Statistics Report. System statistics are in the Report Area (PXX) for each CLOSE request. These statistics are cumulative and reflect information from the time the system begins running.

Note: The frequency at which MUF statistics records are written (if any), are controlled by URT closings and the PXXSTATS Multi-User startup option. For detailed information about Multi-User startup options, see the CA Datacom/DB Database and System Administration Guide.

DETAIL

Performs a top of form and prints system statistics for each CLOSE request.

DETAILX

Skips three lines and prints system statistics for each CLOSE request, causing SYSSTAT information to print on the same page with other information.

SUMMARY

Performs a top of form and prints the system statistics from the last CLOSE record in the Report Area (PXX).

Valid Entries:

DETAIL, DETAILX, SUMMARY

Default Value:

No SYSSTAT information is printed.

Note: When you request a PXX report with JOBSTAT DETAIL that specifies either a JOBNAME= or RTNCD= keyword, be aware that both job and summary statistics are generated.

Optional Keywords

,JOBNAME=

Specifies the name of the job for any dumps and statistics that are to be reported.

Valid Entries:

Any valid job name

Default Value:

Statistics and dumps are printed for all jobs.

,RTNCODE=

Specifies that dumps are to be printed only if the named return code is found in the Request Area. The RTNCODE= parameter is active when the DUMPS=FULL or DUMPS=REQUEST keyword. If DUMPS=TRACE is specified, RTNCODE= is ignored.

Valid Entries:

Any CA Datacom/DB return code (2-character numeric)

Default Value:

(No default)