writing to DB2 UDB Enterprise stage

tejaswini · Post by **tejaswini** » Thu Aug 26, 2004 6:05 am

I need to write to a DB2 UDB Enterprise stage.

Input properties are:
write method : upsert
and
upsert mode : Auto-generated Update & Insert

But on running the job i get a fatal error:
DB2_UDB_Enterprise_67: Error when checking operator: Operator of type "APT_Db2UpsertOperator": The input partitioner attached to port 0 was destroyed

Help me.....
Thanks,
Teju

afssekar · Post by **afssekar** » Thu Aug 26, 2004 8:24 am

Hi

We are using same DB2 UDB Enterprise stage with following properties but we can able to insert.

Write method: upsert
upsert mode: Auto-generated Update & Insert.
Check your $APT_configure file for DB2 setup or set DB2 partitioning.

Please try this.

vbeeram · Post by **vbeeram** » Thu Aug 26, 2004 8:38 am

Hi,
I am using the upsert method it's working well,check the partition type and excecution mode.

Regards,
...Thirupath Reddy

mandyli · Post by **mandyli** » Sun Aug 29, 2004 9:40 pm

Hi

Some time DB2 stage DB2 partition method will give some problem, so change the execution mode parallel to sequential mode then set the Auto partition method.

Please try this.

Thanks
Man

vbeeram · Post by **vbeeram** » Mon Aug 30, 2004 8:56 am

Hi,

In Transformer Stage select Preserve partition type as Set and also change the execution mode then try.

Regards
Thirupathi Reddy