How many users can DataStage handle at a time?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 18
- Joined: Mon Nov 25, 2002 3:23 am
- Location: Switzerland
How many users can DataStage handle at a time?
Hello everybody,
We run a configuration of DataStage 6 for 5 users. Quite often we find that although less than 5 people are connected through the Designer or the Manager no one can open a new session.
Is there a way to check and list all the open sessions?
Thanks for any input you might bring.
Jean-Pierre
We run a configuration of DataStage 6 for 5 users. Quite often we find that although less than 5 people are connected through the Designer or the Manager no one can open a new session.
Is there a way to check and list all the open sessions?
Thanks for any input you might bring.
Jean-Pierre
When you say that "no one can open a new session", what exactly does that mean? Do you get an error, does it tell you your license limit is at its max, something else?
There's no simple way to get a list of all licenses in use. The 'session' question can be answered by searching the forum for the use of the LIST.READU command (or list_readu from UNIX in the engine's bin directory) which will give you the information you are looking for.
There's no simple way to get a list of all licenses in use. The 'session' question can be answered by searching the forum for the use of the LIST.READU command (or list_readu from UNIX in the engine's bin directory) which will give you the information you are looking for.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 18
- Joined: Mon Nov 25, 2002 3:23 am
- Location: Switzerland
Thanks Craig
Yes the error message says that the license limit is reached but a simple head count in our office shows that there are not 5 sessions.
Yes the error message says that the license limit is reached but a simple head count in our office shows that there are not 5 sessions.
chulett wrote:When you say that "no one can open a new session", what exactly does that mean? Do you get an error, does it tell you your license limit is at its max, something else?
Hi,
Use to check total number of connection made from client to server with the identification of IP address in it.
You can find the uniqe IP address to estimate the total number of client connected at the poin of time.
-Kumar
Use
Code: Select all
netstat -a | grep 'dsrpc'
You can find the uniqe IP address to estimate the total number of client connected at the poin of time.
-Kumar
The list_readu should show you similar information. You'll see entries for each connection with a long string of "-" separated numbers. Near the end is the machine name, a colon and the pid of that connection. Each unique machine name should count as one license in use.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 18
- Joined: Mon Nov 25, 2002 3:23 am
- Location: Switzerland
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
My memory of version 6 is that it counts licenses differently. If you open one client app., then use Tools - Run... to start another, it uses the same license. However, if you just run another client, it uses another license. I'm told now v7+ looks at IP addresses and only uses one license per connected machine regardless of how you start them - haven't had a chance to verify this though.
John
John
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Client licensing is now being enforced, where it wasn't prior to version 7.
Licensing is checked in three different locations, only two of which can be "hacked", so forget about trying to defeat it.
There can be a problem of licences being held by defunct (abnormally terminated or killed) connections. These will be cleaned up in the fullness of time by the deadlock daemon if you have it running.
One way on the server to determine how many client connections exist isThis works because each connected client sets a sharable lock to indicate to the Administrator client that the latter can not gain exclusive access to the project.
Similarly,will show one process in a LISTEN state (this is the RPC daemon itself) and one ESTABLISHED connection for each active connection. If there are any connections in other states, such as SLEEP_WAIT, these are probably defunct connections.
From the Administrator client Command window you can query the DS_LICENSE file to determine even more information.
This is useful sometimes in games of "spot the culprit" - you can associate the pid of the agent process (dsapi_slave) on the server with the client machine name.
Licensing is checked in three different locations, only two of which can be "hacked", so forget about trying to defeat it.
There can be a problem of licences being held by defunct (abnormally terminated or killed) connections. These will be cleaned up in the fullness of time by the deadlock daemon if you have it running.
One way on the server to determine how many client connections exist is
Code: Select all
$DSHOME/bin/list_readu | grep DS.ADMIN | wc -l
Similarly,
Code: Select all
netstat -a | grep dsrpc
From the Administrator client Command window you can query the DS_LICENSE file to determine even more information.
Code: Select all
SELECT F1 AS LICENSE, F2 AS LIMIT, F3 AS EXPIRY, F4 AS CLIENT FMT '60L', F5 AS PID FROM DS_LICENSE USING DICT VOC;
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.