Up Prev Next
From: "Jason L dot Froebe" <jason at froebe dot net>
Subject: Re: DBD::Sybase and extended sysprocesses columns
Date: Mar 26 2007 5:53PM
--- Matthew Persico wrote:
> In Sybase 12.5 (don't know about earlier versions) there are three
> columns in sysprocesses:
> clientname varchar 30 NULL NULL 1 NULL NULL NULL
> clienthostname varchar 30 NULL NULL 1 NULL NULL NULL
> clientapplname varchar 30 NULL NULL 1 NULL NULL NULL
> that are much longer than the "normally" used ones for this info:
> hostname char 10 NULL NULL 0 NULL NULL NULL 0
> program_name char 16 NULL NULL 0 NULL NULL NULL 0
> Any chance that we can fill in the longer columns with DBD::Sybase?
> I've checked my sysprocesses table and it looks like NONE of the
> various clients we use around here fill those fields. DBD::Sybase
> would be a good start.
> Matthew O. Persico
These are set at the ASE server not at the client connection
ct_connect() (v12.0 and higher). So.. it would be nice for Michael to
add them as part of the standard 'after connect' processing but we do
have a workaround until then. :)
User settable process information
The set command includes options that allow you to assign each client
an individual name, host name, and application name. This is useful for
differentiating among clients in a system where many clients connect to
Adaptive Server using the same name, host name, or application name.
The partial syntax for the set command is:
set [clientname client_name | clienthostname host_name | clientapplname
Where client_name is the name you are assigning the client, host_name
is the name of the host from which the client is connecting, and
application_name is the application that is connecting to Adaptive
Server. These parameters are stored in the clientname, clienthostname,
and clientapplname columns of the sysprocesses table.
For more information, see Chapter 10, “Managing Adaptive Server Logins
and Database Users” in the System Administration Guide.
Michael, could this go into the next version?
Jason L. Froebe
Help find a cure for breast cancer! Net proceeds benefit the Susan G. Komen Breast Cancer Foundation and the National Philanthropic Trust. Help by donating at http://www.the3day.org/chicago07/jfroebe - I'm walking 60 miles in 3 days in August 2007. (The day I return from TechWave is the first day of the Walk)
Tech log http://www.froebe.net/blog
Froebe Fibers http://www.froebe-fibers.com