Absence of distribution key in the design schema
Posted: Mon Mar 30, 2015 6:58 am
I have a simple parallel job with the below design:
Dataset--------->copy--------->DB2 connector(running in partition type as DB2 connector)
In the above design in the DB2 connector I'm updating a table(Assuming T1).Now T1 is hash partitioned(DPF in DB2) on the basis of C1 in the DB2 level. Now I'm updating T1 (C2,C3) on the basis of C4.
The job is aborting with the following message in one environment:
Unable to locate a schema field that can be associated with column C1. This field must be present in the schema, because this column belongs to the partitioning key, which must be obtained for the partitioning algorithm to function. (CC_DB2Partitioner::initPartKeyObjects, file CC_DB2Partitioner.cpp, line 687)
But the same job ran fine in the different environment.
Please note that in the different datastage environment it's point to different database server.
In the first environment it seems that it was not able to get the DB partition details without the distribution key in the schema
Is it happenig due to Datastage or database?
Dataset--------->copy--------->DB2 connector(running in partition type as DB2 connector)
In the above design in the DB2 connector I'm updating a table(Assuming T1).Now T1 is hash partitioned(DPF in DB2) on the basis of C1 in the DB2 level. Now I'm updating T1 (C2,C3) on the basis of C4.
The job is aborting with the following message in one environment:
Unable to locate a schema field that can be associated with column C1. This field must be present in the schema, because this column belongs to the partitioning key, which must be obtained for the partitioning algorithm to function. (CC_DB2Partitioner::initPartKeyObjects, file CC_DB2Partitioner.cpp, line 687)
But the same job ran fine in the different environment.
Please note that in the different datastage environment it's point to different database server.
In the first environment it seems that it was not able to get the DB partition details without the distribution key in the schema
Is it happenig due to Datastage or database?