CURRENTSQL procedure - Generate a report that summarizes activities

The CURRENTSQL procedure generates a text-formatted report that summarizes currently running activities.

Syntax

Read syntax diagramSkip visual syntax diagramMONREPORT.CURRENTSQL( member)

Parameters

member
An input argument of type SMALLINT that determines whether to show data for a particular member or partition, or to show data summed across all members. If this argument is not specified (or if null is specified), the report shows values summed across all members. If a valid member number is specified, the report shows values for that member.

Authorization

The following privilege is required:
  • EXECUTE privilege on the MONREPORT module
The following examples demonstrate various ways to call the CURRENTSQL procedure. The first example produces a report that shows activity metrics aggregated across all members:
call monreport.currentsql;
The next example produces a report that shows activity metrics specific to the activity performance on member number 4.
call monreport.currentsql(4);