Sunday, 29 May 2016

How to unlock a Datastage job


When a user is compiling a Datastage job,They are getting below message
This job is locked by user username.

Even if user has closed that job,this error is still coming.

OR

User aborted a running sequence in between and then getting below error while trying to compile the sequence again.

Cannot get exclusive access to executable file for job Job name-Job may be being monitored.


Solution:
1.Click on Tools and then Run Director from designer.
2.Select the job/Sequence and click on job from top and choose cleanup resources.



















3.If this option is not available or visible to you,then open Datastage administrator.
4.Select that project and go to Properties.Please check marked checkbox.











5. Now click on the clean up resource from director.
6.Now try to compile the job to see if the issue is fixed.
7.If the issue still persist,Then click the session of that user from Infosphere.
8.Click on administration.
9.Click on Session management.
10.Click on Active session and select that user and click on Disconnect.

How to remove security alerts from Datastage client window


When we are trying to login into Datastage designer from client machine getting below security Popup.When we click on Yes,It disappears and we are able to login into Datastage designer.

But we try to run multiple projects simultaneously,It is really annoying.Please follow the below steps to get ride of this Popup.It will disappear.







Solution:

Please follow below steps.

1.To view the security certificate, Click on "View Certificate".
2.Click the "Certification Path" tab, and then select the "Root Certificate".
3.Click on "View Certificate".
4.Click on "Install Certificate", and then click "Next".
5.Select "Place all certificates in the following store".
6.Click "Browse", and then select "Trusted Root Certification Authorities".
7.Click "Next", and then click "Finish" to import the certificate.
Now the security Popup will disappear.