License issue: Connection issues related to licenses

[yaminids]

Friends,

I am getting the following error when I tried to connect to DataStage Designer. I have checked on the server and found no active connections.
Any idea why I am getting the error?

Error: All available licenses in use:84336-DSDES Limit=5

Thanks in advance
Yamini

[chulett]

Then I would assume you've got at least 5 dead / zombie ones. No clue how that all changed in the 8.x release, however.

[yaminids]

Craig,

How can I remove the dead/zombie processes from the server?

Thanks
Yamini

[chulett]

If I knew that, I would have posted the answer. Perhaps wrong, but I'm assuming the process isn't the same anymore in the 8.x release, something I don't have access to.

I'm sure someone else will wander along and help out. If no-one does, then open a case with your official support provider and post back here what the 8.x version of the process is.

ps. How did you check on the server? Did you grep for dsapi processes and found none?

[vmcburney]

I think you can view Information Server connections through the Information Server console. You should be able to kill them off from there.

[vmcburney]

I think you can view Information Server connections through the Information Server console. You should be able to kill them off from there.

[yaminids]

Craig,

I mistakenly mentioned that we have 8x version but in fact the version on our server is 7.5.
Can you please list the steps to kill the zombie session on 7.5

Thanks
Yamini

[chulett]

In that case, a search for "All available licenses in use" should answer your questions.

[yaminids]

Craig,

I have searched the forum and found some useful information. The following is the output of the command uv -admin -info

Details for DataStage Engine release 7.5.1.2 instance "ade"
===============================================================================
Install history : Installed by root (admin:dsadm) on: Nov 27 2007 20:59:42
Instance tag : ade
Engine status : Running w/active nls
Engine location : /opt/Ascential/DataStage/DSEngine
Binary location : /opt/Ascential/DataStage/DSEngine/bin
Impersonation : Enabled
Administrator : dsadm
Autostart mode : enabled
Autostart link(s) : /etc/rc.d/init.d/ds.rc
: /etc/rc.d/rc2.d/S999ds.rc
: /etc/rc.d/rc3.d/S999ds.rc
: /etc/rc.d/rc4.d/S999ds.rc
: /etc/rc.d/rc5.d/S999ds.rc
Startup script : /opt/Ascential/DataStage/DSEngine/sample/ds.rc
Cache Segments : 0 active
User Segments : 33 active

33 printer segments abandoned!
DSnum Uid Pid Ppid C Stime Tty Time Command


The output says there are 33 User segments but doesn't list any of them.
Is there any other way to list the PIDs of all the user segments?

Thanks in advance
Yamini

[chulett]

Those are shared memory segments, not processes. Assuming a standard itag installation such as yours, you should be able to find them with this:

Code: Select all

ipcs -mop |grep ade

Still curious what you see when you grep all processes for client connections?

Code: Select all

ps -ef |grep -v grep |grep dsapi

[yaminids]

The first command (ipcs -mp |grep ade) didn't list any thing and the second command (ps -ef |grep -v grep |grep dsapi) listed only one process
dstage 32410 32409 0 17:14 ? 00:00:01 dsapi_slave 8 7 0

Am I doing anything wrong?

Yamini

[chulett]

Hmmm. What operating system you gots?

[yaminids]

The first command (ipcs -mp |grep ade) didn't list any thing and the second command (ps -ef |grep -v grep |grep dsapi) listed only one process
dstage 32410 32409 0 17:14 ? 00:00:01 dsapi_slave 8 7 0

Am I doing anything wrong?

Yamini

[chulett]

Hmmm. What operating system you gots?

(sorry, couldn't resist)

[ray.wurlod]

Search for dslictool - it has a cleanup mode.