How to check how many clients are connected to the project?

[Bilwakunj]

Hi,
Before exporting the job/project how to determine is anybody else is connected to it or not? Is it done through the UNIX command or datastage has that routine/Macro for it?

Thanks in advance!!

[kcbland]

There's no exact way. "ps -ef |grep dsapi" will tell you of any clients connected on that server, there's no way to tell the project that they are in.

[Sainath.Srinivasan]

You can try 'netstat -na | grep 31538'

It must not return any rows.

[ray.wurlod]

Actually, being connected will not prevent an export; it's only when they have objects open for editing that that object is skipped by the export process. It is sufficient, therefore, to check for locked design objects (though safer not to have any user connected).

You can determine both using the command

Code: Select all

$DSHOME/bin/list_readu

This will show you who's connected, the identification of their client machine, and whether they have any design objects open for editing. To see just the latter, use

Code: Select all

$DSHOME/bin/list_readu | grep RU | grep -v :

[kcbland]

Actually, being connected will not prevent an export; it's only when they have objects open for editing that that object is skipped by the export process. It is sufficient, therefore, to check for locked design objects (though safer not to have any user connected).

You can determine both using the command

Code: Select all

$DSHOME/bin/list_readu

This will show you who's connected, the identification of their client machine, and whether they have any design objects open for editing. To see just the latter, use

Code: Select all

$DSHOME/bin/list_readu | grep RU | grep -v :

And all of these commands will STILL NOT tell you which project. Since a job can be locked in project A, but you're exporting in project B, you will be unable to distinguish whether you need this lock release or not.

[T42]

You can try 'netstat -na | grep 31538'

It must not return any rows.

That will not work with certain versions of DataStage. 'netstat -na |grep dsrpc' will work better. You only wish to have a single listener.

Ray and Ken also have great advices. Further steps are to go into uvsh, but this is an advanced option, and should not be trifled with without care (and ability to search the forums for detailed explainations.)

[ray.wurlod]

The devno and inode columns in the list_readu report can be decoded from a map of such information gathered by regular monitoring with utilities such as ACCOUNT.FILE.STATS (that's the one that I use). This also contains the project (account) name if collected globally across all projects.