Hi All,
I have an issue on the datstage conncetivity.
Issue:
Iam connecting to a remote server through VPN.
When I leave the job opened and idle for some 15 mins the datastage connection breaks and the job is locked.
I have to release the job only through the administrator.
This has a huge impact on the development.
Query:
1.Is there a way where I can prevent the datastage conncection not to break?
2.Is there a way I can increase the session time out for the connectivity?
Datastage Connection breaks out
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 36
- Joined: Wed Aug 09, 2006 12:18 am
- Location: Chennai
-
- Participant
- Posts: 36
- Joined: Wed Aug 09, 2006 12:18 am
- Location: Chennai
Just want to add...chulett wrote:You set the Inactivity Timeout in the Adminstrator for the server instance, and must be 'dsadm' (or equivalent) to change it. ...
You will have to recycle DataStage engine for new Inactivity Timeout to take effect.
Also if a job is locked you can try unlock it yourself. In most cases you should be able to unlock the job. Follow following Cleanup Procedure:
1. Logon to your project using DataStage Director.
2. From the menu click on Jobs --> Cleanup Resources. Wait for Job Resources window to popup.
3. Select "Show All" option (option 1) for the Processes box (By default "Show by job" is selected).
4. Find and select PID# in the Processes box for your job.
5. Once you click on PID# in the Processes box, "Show by Porcess" option (Option 3) will be enabled in Locks box.
6. Select "Show by Porcess" option (Option 3) from the Locks box.
7. If you see any Locks for the selected PID# in the Locks box, click on "Release All" button to cleanup locks.
8. Remember PID# and select it one more time and Click on "Logout" button in the Processes box to clean up process.
Note: The user who was working on the locked job should try this unlocking procedure...
Hope it helps.......
Assume everything I say or do is positive
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Just want to add...csrazdan wrote: In most cases you should be able to unlock the job. Follow following Cleanup Procedure:
1. Logon to your project using DataStage Director.
2. From the menu click on Jobs --> Cleanup Resources. Wait for Job Resources window to popup.
Required setting - Job Administration in Director should be enabled in Administrator
![Exclamation :!:](./images/smilies/icon_exclaim.gif)
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
It is on the General tab of your DataStage Administrator client. You can also set it to "Do not Timeout" - which may not be a good idea.Sakthi_Sst wrote:Hi Craig,
Sorry for my ignorance!
Is that in the Environment variables of the Administrator do I find the Inactivity Timeout?
If yes where in the Environment variables?
If no where in Adminsitrator?
This is engine level setting and will effect for all projects. Do not forget to recycle engine.
Hope it helps...
Assume everything I say or do is positive