DSXchange

Hi,

I have a datastage px job like

dataset --> Copy -->DB2. The loading method in DB2 is Upsert.

While running the job, i am getting a fatal error like

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/EDWC/SZ/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)

Kindly Help me

Hi,
How many nodes availble in server?
How many are configured? Is it running in sequential mode?
What is the partition mentiond in copy and target db2.

kumar_s wrote:Hi,
How many nodes availble in server?
How many are configured? Is it running in sequential mode?
What is the partition mentiond in copy and target db2.

Hi Kumar,

My dataset is coming from previous job which has 4 nodes. Each node contains 7 lacks of rows. When i am runnign the jobs with only 7 lacks rows, the job is ruuning succesfully. When i am running with more than 7 lacks rows, the above error is throwing.

The partioning method is "Auto" in copy and "DB2" in Db2 stages.

I am running the current job also with 4 nodes and everything is runnign parallely.

Kindly help me

What if you try SAME partition on both copy and DB2 stage?

kumar_s wrote:What if you try SAME partition on both copy and DB2 stage?

Hi Kumar, I have given the SAME partition on both copy and DB2 stages. Still i am getting the same problem.

Please help me