Who is logged on DataStage

ewartpm · Post by **ewartpm** » Tue Apr 19, 2005 9:50 am

Hi All

We have a 10 user development license. When I try to login, I often get the message stating all 10 development licenses are already in use.

How do I find out which users are logged into DataStage i.e. is there some kind of log in the DataStage engine (Universe database) where I could simply run a select statement to get this information?

martin · Post by **martin** » Tue Apr 19, 2005 10:23 am

Hi ewartpm

Try LISTU or LIST.U Universe command, This command display DataStage Users Sharing System.

Martin

ArndW · Post by **ArndW** » Tue Apr 19, 2005 10:43 am

ewart,

to add to what Martin said, go into the DEVELOPER and select some project and execute the "command" button, then the LISTU statement.

kollurianu · Post by **kollurianu** » Tue Apr 19, 2005 11:13 am

Did u mean going to administrator and command button Arnd?

Thank you very much.

martin · Post by **martin** » Tue Apr 19, 2005 11:25 am

Hi ewartpm,

From DS Admin -> Select Project -> Command line -> run LISTU / LIST.U / STSTUS.

Or

Using Telnet logon to DataStage Project and you can excute Universe commands

Martin

martin · Post by **martin** » Tue Apr 19, 2005 11:28 am

Sorry.......... Its STATUS not STSTUS

ray.wurlod · Post by **ray.wurlod** » Tue Apr 19, 2005 6:03 pm

If you execute LIST.READU instead you can get more information.

Each connected client has a type "RL" lock on an artificial record called !&DS.ADMIN_project&! and a type "RU" lock on a record whose name is made up of the Windows identifier of the client machine then the host name of that machine, followed by a colon and the process ID of its agent process (dsapi_server) on the server machine. The RU locks give you the ability to work out from where each client is connected.

This advice relates to version 7.x, as per the poster's specification. It may not work in earlier versions.

ArndW · Post by **ArndW** » Wed Apr 20, 2005 12:29 am

kollurianu wrote:Did u mean going to administrator and command button Arnd?

Thank you very much.

Oops, sorry, I did mean the ADMINISTRATOR and no the DESIGNER. I should never mix cough medicine, Vodka and operating DataStage

ewartpm · Post by **ewartpm** » Wed Apr 20, 2005 2:10 am

Thanks very much guys.

trokosz · Post by **trokosz** » Wed Apr 20, 2005 10:55 pm

Do a ps -ef | grep ds and there they are or as people said in Administrator command do a LIST.READU EVERY