DSNT753I   csect-name DISPLAY PROFILE REPORT FOLLOWS:

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.

Information about pushouts

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