DB2 Enterprise

srikanthd1978 · Post by **srikanthd1978** » Mon Nov 15, 2004 11:21 am

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.

mandyli · Post by **mandyli** » Mon Nov 15, 2004 11:45 pm

Check you have all the permission for that table and also with your DB2 dba that table db2 level partition.

Thanks
man

srikanthd1978 · Post by **srikanthd1978** » Thu Nov 18, 2004 11:53 am

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

T42 · Post by **T42** » Mon Nov 29, 2004 8:28 pm

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.