Measure Reference Manual

SQLPROC entity-spec [,entity-spec] ...
SQLPROC
collects information about one or more SQL processes on the local system.
entity-spec
is specified as:
{ * }
{ $process-name [ ( pid ) ] }
{ disk-filename [ ( pid ) ] }
{ "pname" [ ( pid ) ] }
{ pid }
where:
*
measures all SQL processes on the local system.
$process-name
is the name of the SQL process to be measured.
pid
is a process identifier. The process identifier identifies the owner of the SQL process to be
measured. Specify pid as:
{ cpu,pin }
cpu
is the number of the CPU on which the SQL process is running .
pin
is the process identification number of the SQL process. To indicate all PINs, use an
asterisk (*).
disk-filename
is the name of the object file that contains the SQL/MP code to be measured. This file must
be the object file of a running process. Specify the disk-filename as one of:
{ [ \system.]$device.subvol.filename[:crvsn] }
{ subvol.filename[:crvsn] }
{ filename[:crvsn] }
\system
is the system name. To indicate all devices, use an asterisk (*). The default is the current
default system.
$device
is the volume (device) name. To indicate all volumes, use an asterisk (*). The default is
the current default volume.
subvol
is the subvolume name. To indicate all subvolumes, use an asterisk (*). The default is
the current default subvolume.
filename
is the file name. To indicate all files (except temporary files), use an asterisk (*).
:crvsn
(Measure G09 and later PVUs) is the timestamp, creation version serial number (CRVSN),
or file name extension, necessary to form a unique file name. Use this option to
guarantee file name uniqueness. The CRVSN is available from the Measure report and
the LISTGNAME command.
336 Entities and Counters