Problem using DB2 UDB Enterprise stage
Posted: Tue Mar 06, 2007 8:25 am
While trying to use 'DB2 UDB Enterprise stage', I am getting the following error :
##I TFSC 000001 09:20:08(005) <main_program> APT configuration file: /DataStage/751A/Ascential/DataStage/Configurations/default.apt
>##E TNDB 000000 09:20:09(001) <DB2_UDB_Enterprise_0> Error Idx = 1;
>DB2 Driver Embedded SQL message: SQL0552N "DSWORLD" does not have the privilege to perform operation "BIND".
>SQLSTATE=42502
>;
>sqlcode = -552;
>sqlstate = 42502
>##E TNDB 000000 09:20:09(002) <DB2_UDB_Enterprise_0> Program not bound to database
>Attempting to bind to the database /DataStage/751A/Ascential/DataStage/PXEngine/bin/db2esql.bnd ....failed
However I am able to run the same query using a DB2 API stage.
What could be the reason.
##I TFSC 000001 09:20:08(005) <main_program> APT configuration file: /DataStage/751A/Ascential/DataStage/Configurations/default.apt
>##E TNDB 000000 09:20:09(001) <DB2_UDB_Enterprise_0> Error Idx = 1;
>DB2 Driver Embedded SQL message: SQL0552N "DSWORLD" does not have the privilege to perform operation "BIND".
>SQLSTATE=42502
>;
>sqlcode = -552;
>sqlstate = 42502
>##E TNDB 000000 09:20:09(002) <DB2_UDB_Enterprise_0> Program not bound to database
>Attempting to bind to the database /DataStage/751A/Ascential/DataStage/PXEngine/bin/db2esql.bnd ....failed
However I am able to run the same query using a DB2 API stage.
What could be the reason.