sysprocesses

spid

smallint

Process ID

kpid

int

Kernel process ID

enginenum

int

Number of engine on which process is being executed

status

char(12)

Process ID status. See Table 12-16.

suid

int

Server user ID of user who issued command

hostname

char(10)

Name of host computer

program_name

char(16)

Name of front-end module

hostprocess

char(8)

Host process ID number

cmd

char(16)

Command or process currently being executed. Evaluation of a conditional statement, such as an if or while loop, returns cond.

cpu

int

Cumulative CPU time for process in ticks

physical_io

int

Number of disk reads and writes for current command

memusage

int

Amount of memory allocated to process

blocked

smallint

Process ID of blocking process, if any

dbid

smallint

Database ID

uid

int

ID of user who executed command

gid

int

Group ID of user who executed command

tran_name

varchar(64)

Name of the active transaction

time_blocked

int

Time blocked in seconds

network_pktsz

int

Current connection’s network packet size

fid

smallint

Process ID of the worker process’ parent

execlass

varchar(30)

Execution class that the process is bound to

priority

varchar(10)

Base priority associated with the process

affinity

varchar(30)

Name of the engine to which the process has affinity

id

int

Object ID of the currently running procedure (or 0 if no procedure is running)

stmtnum

int

The current statement number within the running procedure (or the SQL batch statement number if no procedure is running)

linenum

int

The line number of the current statement within the running stored procedure (or the line number of the current SQL batch statement if no procedure is running)

origsuid

int

Original server user ID. If this value is not NULL, a user with an suid of origsuid executed set proxy or set session authorization to impersonate the user who executed the command.

block_xloid

int

Unique lock owner ID of a lock that is blocking a transaction

clientname

varchar(30)

Name by which the user is know for the current session. This parameter is optional

clienthostname

varchar(30)

Name by which the host is known for the current session. This parameter is optional

clientapplname

varchar(30)

Name by which the application is known for the current session. This parameter is optional

sys_id

smallint

Unique identity of companion node

ses_id

int

Unique identity of each client session

loggedindatetime

datetime

Shows the time and date when the client connected to Adaptive Server. See “Row-level access control“ in Chapter 11, “Managing User Permissions” of the System Administration Guide for more information..

ipaddr

varchar

IP address of the client where the login is made. See “Row-level access control“ in Chapter 11, “Managing User Permissions” of the System Administration Guide for more information..

alarm sleep

Waiting for alarm to wake process up (user executed a waitfor delay command)

background

A process, such as a threshold procedure, run by Adaptive Server rather than by a user process

infected

Server has detected a serious error condition; extremely rare

latch sleep

Waiting on a latch acquisition

lock sleep

Waiting on a lock acquisition

PLC sleep

Waiting to access a user log cache

recv sleep

Waiting on a network read

runnable

In the queue of runnable processes

running

Actively running on one of the server engines

send sleep

Waiting on a network send

sleeping

Waiting on a disk I/O, or some other resource (often indicates a process that is running, but doing extensive disk I/O)

stopped

Stopped process

sync sleep

Waiting on a synchronization message from another process in the family