DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
vikas gupta
Participant



Joined: 24 Mar 2004
Posts: 30

Points: 333

Post Posted: Fri Jul 15, 2016 6:23 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Server
OS: Unix
Hi,

Suddenly I checked in all server jobs in all project has limits to stop stage set 50 instead of no limit.
Please give suggestion to set again for no limit.
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42765
Location: Denver, CO
Points: 220367

Post Posted: Fri Jul 15, 2016 7:03 am Reply with quote    Back to top    

Funny, my clients always ran theirs with a limit of 1, thousands of jobs over many years. There's no reason for a Server job to ever throw an error unless something is really wrong and it needs to stop. IMHO. Wink

Now, how are you running them? Does it matter if they are started manually from the client side via Director or Designer or all these all scheduled or run via an Enterprise Scheduler or command like via a script or ... ?? Just trying to get a handle on where the limit might have gotten reset.

_________________
-craig

Research shows that 6 out of 7 dwarves aren't happy
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42765
Location: Denver, CO
Points: 220367

Post Posted: Fri Jul 15, 2016 7:31 am Reply with quote    Back to top    

Also note that I am assuming you meant they stop after 50 warnings rather than 50 rows. Please correct any invalid assumptions on my part.

_________________
-craig

Research shows that 6 out of 7 dwarves aren't happy
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54400
Location: Sydney, Australia
Points: 295062

Post Posted: Fri Jul 15, 2016 5:27 pm Reply with quote    Back to top    

Server jobs can also be run with a row limit, looks like these have been set for the OP's project. The solution is to set these values to 0 ( = no limit ). Parallel jobs can also be row limited ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne (especially seeking good business analysts)
Rate this response:  
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours