Err - All available licenses in use : 77478-DSDES Limit=20

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
sriramjagannadh
Participant
Posts: 7
Joined: Tue Dec 06, 2005 3:14 am

Err - All available licenses in use : 77478-DSDES Limit=20

Post by sriramjagannadh »

When i am opening a project in the Designer
i encountred this issue , but No other user is using the DS at this time.
I tried again after shuting down my system, no use.
OS : Client -Windows , Server -AIX and DS 7.5

Any environment settings i need to change, pl help.

Regards
Sriram.
Thanks & Regards
Sriram.
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Licenses are held in a table/file server side. Your issue is that you must have at least 20 sessions logged in right now, or at least have that many defunct logins with active sessions.

Consider doing a "ps -ef |grep dsapi" to get a look at current attached clients. Consider using kill to knock them off the system, then you can get in.
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
meena
Participant
Posts: 430
Joined: Tue Sep 13, 2005 12:17 pm

Post by meena »

Hi,
Even I faced the same problem. And this is due to license limitations as ken mentioned.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The best command to see what's happening with licences is uv -admin.

uv -admin -lic_report - also available as dslictool - shows server licence usage.

uv -admin -info shows connected clients (and, implicitly, client licence usage).

dslictool clean_lic -a can be used to recover disused licence seats.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I'm curious if these commands actually work for anyone. :?

The -lic_report always shows the following information regardless of usage:

0 license seats are in use
8 license seats are available

Note: we're licensed for 22 seats. The -info command seems a little more useful but shows active 'User segments', a count of all phantom and dsapi_slave processes. We haven't found anything that simply says 'X of your Y seats are currently in use'... except when they are all in use, of course.

Would be nice.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Each connected client takes a shared lock on a non-existent record.

Code: Select all

list_readu | grep DS.ADMIN
should give you a list of connected clients. Pipe through wc -l to get a count of connected clients.

The DS_LICENSE table has five fields, though only one is defined in its dictionary.
Field 1 - client licence serial number
Field 2 - number of clients licensed for
Field 3 - expiry date
Field 4 - identity of connected client machine
Field 5 - process ID of agent process (dsapi_slave) on server

The identity of the connected client machine consists of two parts; the MAC address and the machine name. The machine name is the final field in a string delimited by "-" characters.

For example

Code: Select all

SELECT BREAK ON LICENSE, EVAL "@RECORD<5>" COL.HDG 'PID' FMT '10R',
       EVAL "FIELD(@RECORD<4>, '-', COUNT(@RECORD<4>, '-') + 1, 1)" COL.HDG 'Client'
FROM   DS_LICENSE
ORDER BY 1,2;
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply