DSXchange

Hi,

I have two jobs. First job will create a dataset, which is the source of the second job.

My sencond job looks like

Dataset --> Copy --> DB2. I am unsing Upsert menthod in DB2 stage.

When i ran the job with 1 node it is runnig succewsfully. When i ran with 4 nodes it is throwing the following error

main_program: Fatal Error: There are irreconcilable constraints on the number of
partitions of an operator: parallel Db2udb_SCR_TYPE_REAS_W.
The number of partitions is already constrained to 1,
but an eSame partitioned input virtual dataset produced by
parallel Copy_Recds has 4.
This step has 3 datasets:
ds0: {/work/EDWCST/WHSE/working/ds_TEDSZ06002JB_00001.ds
[pp] eSame=>eCollectAny
op0[4p] (parallel Dset_TEDSZ06002JB_00001)}
ds1: {op0[4p] (parallel Dset_TEDSZ06002JB_00001)
[pp] eSame#>eCollectAny
op1[4p] (parallel Copy_Recds)}
ds2: {op1[4p] (parallel Copy_Recds)
[pp] eSame>>eCollectAny
op2[1p] (parallel Db2udb_SCR_TYPE_REAS_W)}
It has 3 operators:
op0[4p] {(parallel Dset_TEDSZ06002JB_00001)
}
op1[4p] {(parallel Copy_Recds)
}
op2[1p] {(parallel Db2udb_SCR_TYPE_REAS_W)

Why did you post 2 identical new questions when you already have a current thread on the same error message and same subject? That will not get you any quicker or better answers.

This is the active thread that should be responded to

The other thread has "while" in the subject; this one has a comma.