DSXchange

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?

Hi ewartpm

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

Martin

ewart,

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

Did u mean going to administrator and command button Arnd?

Thank you very much.

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

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

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.

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

Thanks very much guys.

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