Provides identifying information about each process on the server. See “monProcessActivity” for statistics about the activity of each process.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monProcessLookup are:
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
SPID |
smallint |
Session process identifier |
|
InstanceID |
int |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
|
KPID |
int |
Kernel process identifier |
|
Login |
varchar(30) |
Null |
Login user name |
Application |
varchar(30) |
Null |
Application name |
ClientHost |
varchar(30) |
Null |
Host name of client |
ClientIP |
varchar(24) |
Null |
IP address of client |
ClientOSPID |
varchar(30) |
Null |
Client application’s operating system process identifier |
ClientName |
varchar(30) |
Null |
Value of the clientname property set by the application |
ClientHostName |
varchar(30) |
Null |
Value of the clienthostname property set by the application |
ClientApplName |
varchar(30) |
Null |
Value of the clientapplname property set by the application |
Use the set command to configure clientname, clienthostname, clientapplname. See the Reference Manual: Commands.
