John Penney writes



Paul:

I do think you are correct: each Pin is a unique "thread" for that
particular SQL inquiry, no more and no less, and when it has completed, it's
'gone'-  in which case what I'm attempting to do is futile. The Pin I guess
simply identifies the process. Maybe I'll need to add some functionality to
the application login to help me track the users?

Back to you-all.

Thanks!

JP

>>> "PAUL,GUY (HP-Boise,ex1)" <[log in to unmask]> 05/09/02 12:31PM >>>
Since you are using an ODBC listener all you get will be
a PIN and IP address. The clients connecting to the listener
do not "logon" as in session.

Do a showconn job=job# of ODBCLNSE job.

To get rid of the offending process you should be able to use abortproc,
available with the right patches.
-------------------------------------------------------------
No need to change applications to identify who's doin' what and who's
screwing you up.  Just use the already provided tools that brung you to the
dance.  First, go to each desk and go into the odbc setup for odbclink/se.
In the session id field type in a unique identifier for each user.  Next on
the 3000 run sqlmon
:sqlmon
set dbenv yourdbe name
p  for program

REFRESH = 10                   OVERVIEW PROGRAM                  SESSIONS =
32
   CID   PIN  USER@ACCT                   STATUS          XID  ISO  PRI
LABEL

PROGRAM NAME = ODBCLNSE.ODBCSE.SYS

     1  1432  ARCELCL ,MGR@HS47            Idle

     2  1230  FELICBE ,MGR@HS47            Idle

     3   566  ARCELCL ,MGR@HS47            Idle

     4   438  ARCELCL ,MGR@HS47            Idle

     5  1098  LAURAPA ,MGR@HS47            Idle

     6   307  KELLYLO ,MGR@HS47            Idle

     7   193  CHRISHA ,MGR@HS47            Idle

     8   360  JOHNYU  ,MGR@HS47            Idle

     9   733  LAURAPA ,MGR@HS47            Idle

    10   721  LAURAPA ,MGR@HS47            Idle

    11  1257  ANGELRA ,MGR@HS47            Idle

    12   622  JOSELO  ,MGR@HS47            Idle

    13   818  JENNIBU ,MGR@HS47            Idle

    14   572  MICHELA ,MGR@HS47            Idle

    15   230  MICHELA ,MGR@HS47            Idle

    16  1211  MICHELA ,MGR@HS47            Idle

    17  1360  OLIVIAVE,MGR@HS47            Idle

    18   602  ARASHSO ,MGR@HS47            Idle

    19   434  FELICBE ,MGR@HS47            Idle

Now that you know what name goes with what pin, feel free to berate,
exterminate or congratulate the employee of your choosing.  Use this pin
with glance to see what files their working on.  Have a ball.

Mike Berkowitz
Guess? Inc.

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *