How to find the number of users logged into Data Stage?

[LNarayan]

Hi all,

I would like to find out how many users are currently logged into the datastage server and how many processes are currently in the running state.

Is there any datastage or unix command to find out this?

Thanks for your help in advance.

Regards
Lakshmi Narayan

[chulett]

Sure... a couple of ways off the top of my head. You could grep for "dsapi", the process that is created by a connected client:

Code: Select all

ps -ef |grep dsapi

That should show all current. You can also get information from netstat, something like:

Code: Select all

netstat -a |grep dsr

May need to refine that some, but that would include orphaned connections as well.

[kcbland]

Jobs running should have either an osh process or a phantom process. Do a "ps -ef|grep phantom" to see what's out there running. As for connected Clients, look for dsapi as Craig has shown. You'll have to get the userid's from those processes.

[ray.wurlod]

Open Director. Disable (in View menu) display of categories. Sort by Status and find all the running jobs by that means.

To find the connected clients, open a Command window in DataStage Administrator client and execute the following query.

Code: Select all

SELECT COUNT(*) FROM DS_LICENSE;

Note that this technique will not work in version 8 and later. However, you can still execute

Code: Select all

${DSHOME}/bin/list_readu | grep '&!DS.ADMIN&!' | wc -l

[PhilHibbs]

Code: Select all

ps -ef |grep dsapi

When running a grep on ps I always put the first character in square brackets so that it does not match the grep command itself:

Code: Select all

ps -ef |grep [d]sapi

[chulett]

Or the more traditional and perhaps easier to grok:

Code: Select all

ps -ef |grep dsapi |grep -v grep