DB2/EE Stage load failure
Posted: Sun Oct 08, 2006 11:01 pm
Hi,
I have a simple job that loads to a DB2 database using the DB2/EE stage. When the job runs it aborts and the following error is shown:
main_program: Fatal Error: There are irreconcilable constraints on the number of
partitions of an operator: parallel DB_STG_CustCupe_ins_EE.
The number of partitions is already constrained to 1,
but an eSame partitioned input virtual dataset produced by
parallel APT_TransformOperatorImplV0S58_STG_xxxx_Load_ins_ee_TR_AppendStats in TR_AppendStats has 4.
Is this a DB2 issue meaning the DBAs have not partitioned the tables or is this a DS config issue ? Being a developer I am not sure where the problem lies so any advice is much appreciated.
Thx,
Chin
I have a simple job that loads to a DB2 database using the DB2/EE stage. When the job runs it aborts and the following error is shown:
main_program: Fatal Error: There are irreconcilable constraints on the number of
partitions of an operator: parallel DB_STG_CustCupe_ins_EE.
The number of partitions is already constrained to 1,
but an eSame partitioned input virtual dataset produced by
parallel APT_TransformOperatorImplV0S58_STG_xxxx_Load_ins_ee_TR_AppendStats in TR_AppendStats has 4.
Is this a DB2 issue meaning the DBAs have not partitioned the tables or is this a DS config issue ? Being a developer I am not sure where the problem lies so any advice is much appreciated.
Thx,
Chin