-DISPLAY PROFILE command (Db2)

The DISPLAY PROFILE command allows you to determine if profiling is active or inactive

Abbreviation: -DIS PROFILE

Environment for -DISPLAY PROFILE

This command can be issued from the z/OS® console, through a batch job or the instrumentation facility interface (IFI). However, in general, this command is intended for use by tools.

Data sharing scope: Member

Authorization for -DISPLAY PROFILE

To execute this command, you must use a privilege set of the process that includes one of the following authorities:

  • SQLADM authority
  • System DBADM authority
  • SYSOPR authority
  • SYSCTRL authority
  • SYSADM authority

Syntax for -DISPLAY PROFILE

Read syntax diagramSkip visual syntax diagramDISPLAY PROFILE

Examples for -DISPLAY PROFILE

The following command displays the status of active and inactive profiling activities.

-DISPLAY PROFILE

Output for -DISPLAY PROFILE

The DSNT753I message displays output from the DISPLAY PROFILE command.

csect-name DISPLAY PROFILE REPORT FOLLOWS:
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 profile 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.

Pushouts information

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 for -DISPLAY PROFILE

The output normally ends with the following message:

DISPLAY PROFILE REPORT COMPLETE