Page 1 of 1
DB2 EE stage
Posted: Fri Jun 17, 2005 3:42 am
by Kirtikumar
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.
Has any one faced this kind of error?
Posted: Fri Jun 17, 2005 6:09 am
by elavenil
Are you using DB2 Partitioned database?
I think DB2 EE can be used if you have DB2 partitioned database.
Regards
Saravanan
Posted: Fri Jun 17, 2005 6:21 am
by Kirtikumar
We are using DB2 SDK 8.1.5 version of DB2. I am not sure whether this is parallel version or not.
Regards,
Kirtikumar.
Posted: Fri Jun 17, 2005 7:28 am
by ray.wurlod
Did you extract "GRAYT" does not have the privilege to perform operation "IMPLICIT CREATE SCHEMA" from the first error? Check with your DBA.
Posted: Fri Aug 20, 2010 1:41 am
by piyu
Did anyone find a solution to this problem? :(
Posted: Fri Aug 20, 2010 1:53 am
by MT
Hi,
Ray already pointed to the root cause:
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.
Get it or work with other schemas.
kind regards
Michael
Posted: Fri Aug 20, 2010 2:32 am
by piyu
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. :?
Posted: Fri Aug 20, 2010 2:39 am
by ArndW
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.
Posted: Fri Aug 20, 2010 2:52 am
by piyu
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.
Posted: Fri Aug 20, 2010 9:06 am
by vivekgadwal
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?
Posted: Fri Aug 20, 2010 12:34 pm
by mhester
>##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.
Posted: Fri Aug 20, 2010 12:57 pm
by chulett
Wow... Michael Hester... long time no see.
Posted: Fri Aug 20, 2010 2:25 pm
by mhester
Wow... Michael Hester... long time no see.
Every now and again I might be able to answer something :D