Locking a logon id. 1

[vertinias]

I wish to be able to tell if a Tera logon id is in use. I have multiple ids for my jobs.....I wish to write a check routine to randomly assign the next available userid so more than one process at a time does not occur and blow my spool space..

Does anyone know of a way.....I would check current spool....but that may be iffy.....since the id could be in use before spool is utilized.....or least I believe this to be the case.

Help.

Vert

 

[dnoeth]

Hi Vert,

select distinct username from dbc.sessioninfo;

Dieter

 

[vertinias]

Thank you Dieter.......I should have know this already.....

thank you again.