Page 1 of 1

DB2 Enterprise

Posted: Mon Nov 15, 2004 11:21 am
by srikanthd1978
hello all,

i am using the DB2 Enterprise ( write, append) to insert data into an empty table.

My PX Job aborts with the following message..

Error when checking operator: Operator of type "APT_DB2WriteOperator": The input partitioner attached to port 0 was destroyed

any ideas ??

Thanks.

Posted: Mon Nov 15, 2004 11:45 pm
by mandyli
Check you have all the permission for that table and also with your DB2 dba that table db2 level partition.

Thanks
man

Posted: Thu Nov 18, 2004 11:53 am
by srikanthd1978
thanks for ur inputs .
but can you be more specific.. by permissions ' what permissions are we talking about and what about the db2 level partition'

thanks

Posted: Mon Nov 29, 2004 8:28 pm
by T42
Contact your DBA administrator and ask them to ensure that you have all necessary access rights on the DB2 server.

Contact your UNIX administrator and ask them to ensure that the DB2 server is exactly the same as your DataStage server in terms of PX installation.

Contact Ascential Support if you need further instructions on how to get a DB2 setup working correctly.