All available licenses in use

NSIT-DVP-01 · Post by **NSIT-DVP-01** » Fri Dec 14, 2012 8:30 am

I am having the same problem as noted in this post but with the DataStage 7.5 installed on Windows server, so the grep command doesn't work. What should I do? Please, any suggestion?

chulett · Post by **chulett** » Fri Dec 14, 2012 8:57 am

<split to your own post>

Unless all you have is the Server version, the Enterprise version comes with the MKS Toolkit which brings 'UNIX' commands to Windows, so more than likely you do have grep... or something grep-like.

Help us out and post the details of your problem.

NSIT-DVP-01 · Post by **NSIT-DVP-01** » Fri Dec 14, 2012 9:35 am

thank you, sorry about not opening my own topic.

I guess I have the Enterprise version, but I am not sure how to verify, I'll google it.

Otherwise, could you please tell me where to type the grep command? I am typing it in the command line on the server side, and it says - the command is not recognized.

The problem is: the maximum number of licences is 2. I guess my DataStage Clients did not close properly, so they stay open on the server side and I am unable to connect to DataStage by opening a new session.

NSIT-DVP-01 · Post by **NSIT-DVP-01** » Fri Dec 21, 2012 7:17 am

Please help me, have only 2 licenses available, and both are in use by phantom session, that have not been closed properly. I have access to the server side, the server is on Windows. How can I kick off those sessions that are still there although all the clients are closed?

chulett · Post by **chulett** » Fri Dec 21, 2012 8:12 am

Well... you can alway try stopping and restarting DataStage. Worst case reboot the server itself. Otherwise, I've used DS.TOOLS in the past but don't have any access so examples will have to be off the top of my head.

From the command line:

Code: Select all

cd $DSEngine
bin/uvsh
(you should have a TCL prompt ">" now)
LOGTO <YourProjectName>
DS.TOOLS

Hopefully that gets you there. Then you should see options to manage processes and from there a way to list them and log them out by process id. Give that a shot and let us know any specific issues or questions you have. I'll look to see if a better post exists with details of the process...

ray.wurlod · Post by **ray.wurlod** » Fri Dec 21, 2012 1:46 pm

This is where it's vital to know the version. There are scripts to clean up defunct licences, but the names of the scripts are different in different versions.

chulett · Post by **chulett** » Fri Dec 21, 2012 2:57 pm

As noted in the initial post, this is 7.5 which I don't recall coming with any such scripts. Could be wrong, of course, but don't remember any such.

ray.wurlod · Post by **ray.wurlod** » Sat Dec 22, 2012 12:26 am

In 7.5 you can run the dsdlockd program with -p option. You need to be logged in with local Administrator privilege.

chulett · Post by **chulett** » Sat Dec 22, 2012 1:05 am

True.

NSIT-DVP-01 · Post by **NSIT-DVP-01** » Thu Jan 03, 2013 9:58 am

chulett wrote:From the command line:
Code: Select all
cd $DSEngine
bin/uvsh
(you should have a TCL prompt ">" now)
LOGTO <YourProjectName>
DS.TOOLS

Hello, and Happy New Year! Thank you very much for your kind replies, so back to work with the same problem, I am trying the above commands first. When lauching uvsh, I am getting a prompt: "This directory is not set up for DataStage. Would you like to set it up? Y/N?" So I chose N since I am not sure what it would do, and the program quit. Should I chose Y instead?

NSIT-DVP-01 · Post by **NSIT-DVP-01** » Thu Jan 03, 2013 10:07 am

ray.wurlod wrote:In 7.5 you can run the dsdlockd program with -p option. You need to be logged in with local Administrator privilege.

I have just launched this to see what happens

for the moment it is still running, I guess.

chulett · Post by **chulett** » Thu Jan 03, 2013 10:44 am

NSIT-DVP-01 wrote:
ray.wurlod wrote:In 7.5 you can run the dsdlockd program with -p option. You need to be logged in with local Administrator privilege.
I have just launched this to see what happens for the moment it is still running, I guess.

It's a "deamon" which means it runs constantly. One of the configuration options tells it how often to wake up and check for deadlocks... I think the default is 15 minutes... unless you use the -p option, of course.

chulett · Post by **chulett** » Thu Jan 03, 2013 10:47 am

NSIT-DVP-01 wrote:Should I chose Y instead?

There's no reason to ever answer 'Y'. And it wouldn't have asked the question if you were truly in the $DSEngine directory or one of the Project directories when you launched uvsh or dssh. Can you confirm exactly what steps you followed?

ray.wurlod · Post by **ray.wurlod** » Thu Jan 03, 2013 1:55 pm

dsdlockd -p is a "probe" and should finish fairly quickly.

chulett · Post by **chulett** » Thu Jan 03, 2013 2:09 pm

Noted.

DSXchange

All available licenses in use

All available licenses in use

same problem again