DSXchange

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

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:
That should show all current. You can also get information from netstat, something like:
May need to refine that some, but that would include orphaned connections as well.

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.

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. Note that this technique will not work in version 8 and later. However, you can still execute

chulett wrote:

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:

Or the more traditional and perhaps easier to grok: