Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
tejaswini
Participant
Posts: 19 Joined: Thu Aug 26, 2004 5:40 am
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
Participant
Posts: 11 Joined: Fri Apr 23, 2004 10:24 am
Location: chennai
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
Participant
Posts: 63 Joined: Fri Apr 09, 2004 9:40 pm
Contact:
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
Premium Member
Posts: 898 Joined: Wed May 26, 2004 10:45 pm
Location: Chicago
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
Participant
Posts: 63 Joined: Fri Apr 09, 2004 9:40 pm
Contact:
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