Who is connected to a project?

bcarlson · Post by **bcarlson** » Fri May 18, 2007 9:14 am

If we need to do some maintenance to a project, is there a way to check to see if anyone is connected to it?

For example, UV commands like DS.REINDEX ALL or DS.CHECKER require exclusive access to the project. How can I tell if anyone is using the project?

Brad.

RobertScarbrough · Post by **RobertScarbrough** » Fri May 18, 2007 10:04 am

Try to run the following command

netstat -a |grep dsrpc

For us it shows the machine number in use by the developer. That will show everyone using DataStage on that machine, not project. Gives you a place to start at least.

chulett · Post by **chulett** » Fri May 18, 2007 10:58 am

You also need to investigate the use of the LIST.READU function, which is also available from the command like as 'list_readu' in the bin directory.

ray.wurlod · Post by **ray.wurlod** » Fri May 18, 2007 5:26 pm

From the operating system issue the command $DSHOME/bin/list_readu and pipe the result through grep filtering for the project name.

Every connected client takes a shared lock project&!DS.ADMIN!& so that the Administrator client (or you) can rapidly determine whether there are any clients connected to that particular project.

If the report is empty, there are none.