monProcessLookup

Description

Provides identifying information about each process on the server. See “monProcessActivity” for statistics about the activity of each process.

NoteYou need not enable any configuration parameters for this monitoring table to collect data.

Columns

Name

Datatype

Attributes

Description

SPID

smallint

Session process identifier

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