Verifying the process which are being executed on Sysbase
Verifying the process which are being executed on Sysbase
select convert(char(8), suser_name(suid)), spid, physical_io, cpu,
"procedure" = convert(char(8),object_name(id, dbid)),
linenum, blocked, cmd, status, hostname,
program_name, tran_name, hostprocess, execlass, enginenum,
memusage
from master..sysprocesses
where dbid > 0
and suid > 0
and cmd <> "AWAITING COMMAND"
and status <> "recv sleep"
go