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.
Use the set command to configure clientname, clienthostname, clientapplname. See the Reference Manual: Commands.
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 |
|
KTID |
int |
ID of the kernel task |
|
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 |