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
How to find the number of users logged into Data Stage?
Moderators: chulett, rschirm, roy
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.
Code: Select all
ps -ef |grep dsapi
Code: Select all
netstat -a |grep dsr
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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;
Code: Select all
${DSHOME}/bin/list_readu | grep '&!DS.ADMIN&!' | wc -l
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
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:chulett wrote:Code: Select all
ps -ef |grep dsapi
Code: Select all
ps -ef |grep [d]sapi
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant
Or the more traditional and perhaps easier to grok:
Code: Select all
ps -ef |grep dsapi |grep -v grep
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers