DSXchange

Hi, I am using DB2 Connector stage to update and insert records. I am getting The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation. But same id is working fine when I use API stage, I am able to update and insert records using API stage.

Please suggest

Check, double check and triple check the authorization in your Connector, or in the Data Connection object that it uses (and possible in the Parameter Set associated with that).

Test by manually overriding the user name and password with the correct values.

Perhaps the connector stage requires some additional system privileges, such SELECT on certain DB2 system tables/views to collect metadata.