DSNT753I csect-name DISPLAY PROFILE REPORT FOLLOWS:

Explanation

This message displays output from the DISPLAY PROFILE command.

csect-name
The name of the control section that issued the message.

The output from the command consists of one or more of the following sections, in the indicated order.

Current profiling status

The output contains information about the current profiling status:

STATUS=profile-status
STATUS profile-status
The profiling status. Expected values are:
ON
Profiling is active.
OFF
Profiling is inactive.
SUSPENDED
Profiling was active but is now suspended because of an error. For example, the maximum push-out limit was reached or the table space is full.
STARTING
Profiling is being started but is not yet complete.
STOPPING
Profiling is being stopped but is not yet complete.

Information about when profiling started

If the profile status is ON or SUSPENDED, the output contains information about when profiling started:

TIMESTAMP=profile-timestamp
TIMESTAMP profile-timestamp
The date and time when the profiling status started. This information is displayed in the formatYYYY-MM-DD-HH.MN.SS.NNNNNN.

Explanation

The output contains information about reports that were issued for monitored SQL statements:

PUSHOUT=current-pushouts OUT OF maximum-pushouts
PUSHOUT current-pushouts
The current number of reports that were issued for all monitored SQL statements since the profile was started. This value is applicable only for profiles that monitor SQL statements. This value is reported only when the profile status is ON or SUSPENDED.
OUT OF maximum-pushouts
The maximum number of total reports that are allowed for all (normal and exception) statement monitoring during the lifetime of a monitor profile.

End of output

The output normally ends with the following message:

DISPLAY PROFILE REPORT COMPLETE

System action

Processing continues.

System programmer response

Take the action that is indicated for the profile-status value:

ON
No action is required. To stop profiling, issue STOP PROFILE.
OFF
No action is required. To start profiling, issue START PROFILE.
STARTING or STOPPING
Wait until the command execution is complete.
SUSPENDED
Correct the problem that is causing the suspension of profiling activities, then stop or restart profiling.