Ingres sessions 
Author Message
 Ingres sessions
Does anyone know how to get the Unix pid associated with a database
connection?  I already have a script which removes all database connections
except for ingres owned connections ( I wish Ingres would supply this for
offline checkpointing etc...perhaps in the new releases).  What I would like
to do then is send a HUP/KILL signal to the processes which had the database
connections.  Perhaps this is too much to ask since the process can originate
on a client machine.  Does anyone have any thoughts?

thanks,

--tom



Thu, 01 Jun 1995 03:38:07 GMT
 Ingres sessions


Quote:
(Thomas J Lohman) writes:
> Does anyone know how to get the Unix pid associated with a database
> connection?  I already have a script which removes all database connections
> except for ingres owned connections ( I wish Ingres would supply this for
> offline checkpointing etc...perhaps in the new releases).  What I would like
> to do then is send a HUP/KILL signal to the processes which had the database
> connections.  Perhaps this is too much to ask since the process can originate
> on a client machine.  Does anyone have any thoughts?

The only thought I had would be to use the iimonitor command and the
output from formatting each session.  See the I & O Guide for details.
There _is_ a terminal identifier in there, and that, together with the
"w" or "who" command, might give you the pid of the user.

As you say, if the connection is through INGRES/Net, you're probably out
of luck.  In this case, I think iimonitor calls the terminal "batch".

I'd like to see INGRES/Net and the server connection code enhanced so
that they knew about the pid, username, node, connect time, and database
connection name (including vnode) for all connections.  It would make
some of these administration and debugging tasks much easier.  I'd love
to hear something about what their plans are in these directions.


Graduate School of Business             yellnet:  (312) 702-0328
University of Chicago                   faxnet:   (312) 702-0233
Disclaimer: My opinions are my own and not those of my employer.
Ich bin ein Virus.  Mach' mit und kopiere mich in Deine .signature.



Fri, 02 Jun 1995 01:48:39 GMT
 Ingres sessions

Quote:
>Does anyone know how to get the Unix pid associated with a database
>connection?  I already have a script which removes all database connections
>except for ingres owned connections ( I wish Ingres would supply this for
>offline checkpointing etc...perhaps in the new releases).  What I would like
>to do then is send a HUP/KILL signal to the processes which had the database
>connections.  Perhaps this is too much to ask since the process can originate
>on a client machine.  Does anyone have any thoughts?

>thanks,

>--tom

I've been asking (no pun intended) Ingres about this for years.
In Ingres 6.4 (the one we run anyway)  you can finally track down
the terminal device name associated with an Ingres session using iimonitor
but thats as far as it goes.

In short I'd like to know too.

David Denton
ANSTO
Australia



Fri, 02 Jun 1995 07:13:18 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Ingres sessions via VB 5.0 and ODBC

2. Ingres sessions @ CAWorld???

3. Ingres session ID and Unix PID

4. Ingres session accounting questions

5. Ingres sessions - Please help!

6. Determining in ABF whether Ingres session was dropped.

7. Remote Ingres Sessions via SLIP

8. Ingres sessions via VB 5.0 and ODBC

9. Ingres Session Limit

10. Killing Ingres Sessions

11. removing Ingres sessions

12. Killing Ingres Sessions


 
Powered by phpBB® Forum Software