DB2/EE Stage load failure

Chuah · Post by **Chuah** » 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

Kirtikumar · Post by **Kirtikumar** » Mon Oct 09, 2006 1:03 am

Whats the partitioning type set on the input of the DB2 EE stage?

Nageshsunkoji · Post by **Nageshsunkoji** » Mon Oct 09, 2006 2:43 am

Hi Chuah,

Presently, in your job config file is set for 4 nodes. But, your output database is set for single partition. Problem is your Dataset is created for 4 nodes and it is trying to load the data in a single node constraint partition database. To get out of this problem we can do one thing, just select the option of Clear in the Advanced tab of Dataset. Then Try to load, it will work and it will load the data. But, sure to know the reason from DBA, Y ? your database is constrained to single partition and ask for new settings.

Chuah · Post by **Chuah** » Sun Oct 15, 2006 10:15 pm

Nageshsunkoji wrote:Hi Chuah,

Presently, in your job config file is set for 4 nodes. But, your output database is set for single partition. Problem is your Dataset is created for 4 nodes and it is trying to load the data in a single node constraint partition database. To get out of this problem we can do one thing, just select the option of Clear in the Advanced tab of Dataset. Then Try to load, it will work and it will load the data. But, sure to know the reason from DBA, Y ? your database is constrained to single partition and ask for new settings.

Hi Nagesh,
Thanks for the tip. The Clear bit made it work but I think you're right in that the DB needs to be changed.Does that mean changing the APT_CONFIG for DB2 too to include more nodes ?

Rgds,
Chin

Nageshsunkoji · Post by **Nageshsunkoji** » Tue Oct 17, 2006 10:20 am

Hi Chin,

I am not sure about DB2 level changes. As per my knowledge, DBA have to remove the constraint on Database level.

Regards
Nagesh.