Unix pid of the processes connecting to sybase dataserver

[Jatinder Pal Gupta]

Hi ALL,

Is there any way to find out exactly which are the processes
making connections making to sybase dataserver.

sp_who does give some output but not exactly the unix processes.
Also sometime sysprocesses table also sometime shows nothing
under hostprocess.

IS THERE ANY OTHER WAY TO FIND OUT EXACTLY THIS?

Thanks in advance
Jatinder

[Anthony Mandic]

Jatinder Pal Gupta wrote:

> Is there any way to find out exactly which are the processes
> making connections making to sybase dataserver.
>
> sp_who does give some output but not exactly the unix processes.
> Also sometime sysprocesses table also sometime shows nothing
> under hostprocess.
>
> IS THERE ANY OTHER WAY TO FIND OUT EXACTLY THIS?

Its up to the client to pass the information to the server.
If the client doesn't set it the server doesn't know.

-am © 2002

[Phil Houstoun]

>

Perhaps you could hack the output of netstat (under Linux, netstat -ap
will give you
PIDs), i.e. grep on your dataserver's port number and awk|sed|cut out
the PID/process
name?

--

Phil Houstoun
Email: pjh...@canada.com
-----------------------------------------------------------------------

[Anthony Mandic]

Phil Houstoun wrote:

> Perhaps you could hack the output of netstat (under Linux, netstat -ap
> will give you
> PIDs), i.e. grep on your dataserver's port number and awk|sed|cut out
> the PID/process name?

Although this won't help you link that data to an ASE spid.

-am © 2002

[Rene van Leeuwen]

In article <ah8lei$3...@nntpa.cb.lucent.com>, Jatinder Pal Gupta wrote:

in isql do:
select spid, hostprocess, cmd from master..sysprocesses

in unix do:
ps aux|grep nnn or
ps -ef|grep nnn
depending on your flavour of unix, nnn being the pid=hostprocess from
the above select

--
groeten, Rene van Leeuwen
___ _
| _ \___ _ _ ___//
| / -_) ' \/ -_)
|_|_\___|_||_\___|