Session ID -> Process ID

In article <428408593wnr@scottw.demon.co.uk>,
Scott   wrote:
>
>Does anyone know of a way to map an Ingres session Id to a Unix PID?
>
>I know you can get a tty number, but the processes I want to identify 
>appear as 'batch' (because they have no tty!).
>
>-- 
>---------------------------------------------------------------------------
>| Scott in the wardrobe                                                   
>---------------------------------------------------------------------------
>

User sessions in Ingres are threads of the iidbms process owned by 'ingres'.
Connections thru the Ingres Net process iigcc are also multi threaded. If
you want to do anything with the threads you have to use the supplied 
utilities like 'iimonitor'. Ingres architecture is different from the Oracle
background spawned process type architecture used with Oracle 6 and Oracle 7
(when not using the  multi threaded option).
 
Henry Zabokrzycki

email: henryz@nt.com
Ingres Q & A
To William's Home Page
Email William