Datastage Sequencer problem

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

That's the generated OSH, which does not show partitioning or, indeed, anything about parallelism because the latter is not determined until run time.

I asked for you to dump and post the score.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
rumu
Participant
Posts: 286
Joined: Mon Jun 06, 2005 4:07 am

Post by rumu »

ray.wurlod wrote:That's the generated OSH, which does not show partitioning or, indeed, anything about parallelism because the latter is not determined until run time.

I asked for you to dump and post the score. ...
Ray,

the job is aborted ,i got the following information only(APT_DUMP_SCORE
is enabled in the project)

main_program: IBM WebSphere DataStage Enterprise Edition 8.0.1.4943
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved
main_program: The open files limit is 2048; raising to 4096.
main_program: orchgeneral: loaded
orchsort: loaded
orchstats: loaded
Surrogate_Key_Generator_0: Error when checking operator: Input data set on port 0 has a partition method, but the operator is not parallel.

rumu
Nagaraj
Premium Member
Premium Member
Posts: 383
Joined: Thu Nov 08, 2007 12:32 am
Location: Bangalore

Post by Nagaraj »

Use Operator combinablity option in advanced tab and let me know what happens.
abc123
Premium Member
Premium Member
Posts: 605
Joined: Fri Aug 25, 2006 8:24 am

Post by abc123 »

You need to set Combinability Mode as "Do Not Combine" and set $APT_DUMP_SCORE to True. Default is False. This will dump the score in the log.

You can also set $APT_DISABLE_COMBINATION to True and that should override the Combinability Mode setting.
Nagaraj
Premium Member
Premium Member
Posts: 383
Joined: Thu Nov 08, 2007 12:32 am
Location: Bangalore

Post by Nagaraj »

Did you try something with operator combinability?
Post Reply