Additional info :

If i'm logged on windows as usera and connect to db2 with userb,
EXECUTION_ID=windows logon/usera
AUTH_ID=db2 connect to ... user /userb

PM

"Joachim Klassen" <JoKlassen@email.com> a écrit dans le message de
news:b5788ff3.0312092338.42a075ea@posting.google.c om...
> In DB2 V8:
>
> SELECT * FROM TABLE(SYSPROC.SNAPSHOT_APPL_INFO(CURRENT SERVER,-1)) as
> SNAPSHOT_APPL_INFO WHERE EXECUTION_ID = 'your_user'
>
> To force:
> SELECT 'force application (' concat char(agent_id) concat ')' FROM
> TABLE(SYSPROC.SNAPSHOT_APPL_INFO(CURRENT SERVER,-1)) as
> SNAPSHOT_APPL_INFO WHERE EXECUTION_ID = 'your_user'
> Pipe the output to a skript and execute it via DB2 CLP
>
> HTH
> Joachim
>
> briggs@lsmp.com (Ray) wrote in message
news:<f3c3a1a3.0312080755.bf50bf6@posting.google.c om>...
> > DB2 V7.2
> > Is it possible to list applications connected to a node by Auth ID?
> > Is it possible to force applications connected to a node by Auth ID or
> > am I forced to use App. Handle?
> >
> > Thanks,
> > Ray