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



Joined: 31 Mar 2013
Posts: 1
Location: Chennai
Points: 12

Post Posted: Sun Mar 31, 2013 6:34 am Reply with quote    Back to top    

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

What is the use of this $Apt_disable_combination Variable. Why we are Enabling this.

Thanks,

_________________
Karthikeyan.M
anandsivan
Participant



Joined: 21 Sep 2011
Posts: 8
Location: Karnataka
Points: 119

Post Posted: Sun Mar 31, 2013 10:46 am Reply with quote    Back to top    

If this environment variable is set to true Datastage will disable the operators combination within a step.
Operator combining is DataStage’s default behavior, in which two or more (in fact any number of) operators within a step are combined
into one process where possible.

Also note that disabling combining generates more UNIX processes, and hence requires more system resources and memory.
It also disables internal optimizations for job efficiency and run times.


___________________
Thanks
Anand
Rate this response:  
Not yet rated
WBlaustein



Group memberships:
Premium Members

Joined: 28 Oct 2011
Posts: 24

Points: 226

Post Posted: Mon Jul 16, 2018 11:12 am Reply with quote    Back to top    

Why not just post the link to the IBM documentation, which also does not answer the question as to "WHY".
Rate this response:  
Not yet rated
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2822
Location: USA
Points: 21387

Post Posted: Tue Jul 17, 2018 6:26 am Reply with quote    Back to top    

Why enable? Because you need to debug a problem. After you resolve the problem, set it back to False again.

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
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: 42796
Location: Denver, CO
Points: 220596

Post Posted: Tue Jul 17, 2018 7:16 am Reply with quote    Back to top    

The "why" of it has been discussed here in the past but not recently from what I recall. There are several core APT variables that people have identified as ones you should include in every job. Sorry that I don't remember the full set but this is definitely one of them. As noted, it allows you to simply set it to TRUE if you ever need to debug a job with a generic "CombinedOperator" error without having to go back to the design (and promotion process) to add it.

Perhaps we can morph this conversation around to that topic. General question to the home audience: what APT variables are you setting up in every job as a best practice?

_________________
-craig

"I don't mind you comin' here and wastin' all my time time"
Rate this response:  
Not yet rated
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2822
Location: USA
Points: 21387

Post Posted: Wed Jul 18, 2018 6:04 am Reply with quote    Back to top    

We do not include any APT environment variables on every job. If we hit some sort of unusual problem, then we will create a copy of the job for debugging purposes and start narrowing down the problem as needed. That process may or may not require special APT environment variables to be added.

We do, as a standard practice, set APT_DUMP_SCORE=True at the project level on every project, via Administrator.

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
Rate this response:  
Not yet rated
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