No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

FAQ-How to View the Current Connection Number Used by Sybase Database

Publication Date:  2012-07-24 Views:  15 Downloads:  0
Issue Description
Q:
How to view the current connection number used by Sybase database?
Alarm Information
Null
Handling Process
A:
Run the sp_who [loginame | "spid"] command to view the current connection number. 
View the current connection number of the designated user through parameters.
For example:
Use command sp_who 'sa' to view the current connection number of super users.
$cd /opt/sybase/OCS-12_0/bin
$./isql -Usa -Pn2000n2000 -SN2000DBServer
1>sp_who 'sa'
2>go
 fid    spid   status       loginame     origname     hostname   blk_spid       
         dbname     cmd              block_xloid                                
 ------ ------ ------------ ------------ ------------ ---------- --------       
        ---------- ---------------- -----------                                 
      0    284 running      sa           sa           N2000V2    0              
         master     SELECT                     0                                
Root Cause
Null
Suggestions
Every time a client is started (that is, a database connection), a spid process generates. As long as this client is open, this spid process exists and can have different affair operations in serial mode.
Generally, the following connection status are as follows:
running (running)
recv sleep((waiting for reading from the network)
AWAITING COMMAND (waiting for a command, probably idle connection)
send sleep  (waiting for network sending)
sleeping (dormancy)

END