The CURRENTSQL procedure generates a text-formatted report
that summarizes currently running activities.
Syntax
>>-MONREPORT.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);
DB2 10.5 for Linux, UNIX, and Windows