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
Error-irreconcilable constraints on the number of partitions
Moderators: chulett, rschirm, roy
Hi Kumar,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.
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