-DISPLAY PROFILE command (Db2)

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

Abbreviation: -DIS PROFILE

Environment

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

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

Read syntax diagramSkip visual syntax diagramDISPLAY PROFILE

Examples

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

-DISPLAY PROFILE

Output

Message DSNT753I indicates the beginning of the output of the command.