Hi,
I am getting following error while using DB2 EE stage.
>##E TNDB 000312 10:35:38(001) <DB2_UDB_Enterprise_3> Error Idx = 1;
>DB2 Driver Embedded SQL: -552;
>sqlcode = 42502;
>sqlstate = SQL0552N "GRAYT" does not have the privilege to perform operation "IMPLICIT
>CREATE SCHEMA". SQLSTATE=42502
>
>##E TNDB 000000 10:35:38(002) <DB2_UDB_Enterprise_3> Program not bound to database
>Attempting to bind to the database /DataStageApp/Ascential/DataStage/PXEngine/bin/db2esql.bnd ....failed
>
I have specified the instance, database name and user/pass details properly. The same details work in DS API stage. Instance name and other details are taken from DB2's command like get instance and all.
ray.wurlod wrote:Did you extract "GRAYT" does not have the privilege to perform operation "IMPLICIT CREATE SCHEMA" from the first error? Check with your DBA.
It seems you are trying to create a table in your stage in a new schema.
To do so - meaning to be able to create a new schema in the database by just creating a table and without a create schema command before you need special rights in DB2: the IMPLICIT_SCHEMA right.
Actually I'm getting this error on doing a select. Not trying to create a schema. Perhaps there is some privilege issues for the id on the instance/server parameters ie db2 instance (server) and client instance. :?
Could your SELECT statement DML be triggering this implicit creation? According to the Connectivity Guide to IBM DB2 Databases, you need
Listed below are the required IBM DB2 privileges:
SELECT privilege on any tables from which to read data.
INSERT privilege on any existing tables to be updated.
TABLE CREATE privilege to create any new tables.
INSERT and TABLE CREATE privileges on any existing tables to be replaced.
DBADM privilege on any database written by using the LOAD method.
I have the required SELECT privilege. I can execute same query using API stage but I need to do a sparse lookup. DB2 Enterprise stage has not been in use in this installation as they have been using server edition and have recently migrated to 8.1 parallel edition, where again they were using API stage.
piyu wrote:Did anyone find a solution to this problem?
Did you at least try searching about Implicit Create Schema online? A simple search yielded me this from the IBM website:
IBM wrote:Implicit schema authority (IMPLICIT_SCHEMA) considerations
When a new database is created, PUBLIC is given IMPLICIT_SCHEMA database authority. With this authority, any user can create a schema by creating an object and specifying a schema name that does not already exist.
Pay heed to the last sentence. Are you giving a schema name that is invalid on that database?
Vivek Gadwal
Experience is what you get when you didn't get what you wanted
>##E TNDB 000000 10:35:38(002) <DB2_UDB_Enterprise_3> Program not bound to database
>Attempting to bind to the database /DataStageApp/Ascential/DataStage/PXEngine/bin/db2esql.bnd ....failed
Just have your DBA's rebind the package in the DB and you will be good to go. This usually happens after a DB upgrade.
Nothing at all to do with partitioned tables etc..., but it is related to the EE stage.