psListProcesses

Description

     This program lists all the processes (spids) currently running on
a Sybase ASE database server.  You must be the 'sa' to run this program.
You can just list the current processes, or you can sort them by
specifying a 'top' number of spids.  You can list the top processes
by CPU usage, memory usage and physical I/Os.

Syntax

psListProcesses -Sserver -Uusername -Ppassword
-Lprocess_login_names -Dprocess_databases -Cprocess_client_programs
-Tnumber_of_top_processes -Iiterations -Nseconds_between_iterations
-Ooptions -Foutput_file

-S

Sybase Server Name

-U

Sybase User Name

-P

Sybase User's Password

-L

Sample processes owned by these Sybase login names [%]

-D

Sample processes using these databases [%]

-C

Sample processes created by these client programs [%]

-T

Show only this many top users of the resource [All]

-I

The number of iterations [1]

-N

The number of seconds between polling [0]

-F

Name of output file [standard output]

-O

Options

c

CPU

m

Memory

i

Physical I/O

DSQUERY

When -S is not specified

SYB_USER

When -U is not specified

SYB_PASS

When -P is not specified

PS_SYSMSG_FILE

Name of the tool's messages file