create db2 schema using jdbc

Question

What is the correct syntax or what are the correct steps for creating a schema in DB2 using JDBC?

When running create schema test1 or create schema test1 authorization db2admin as db2admin, I consistently get DB2 SQL Error: SQLCODE=-552, SQLSTATE=42502, SQLERRMC=DB2ADMIN;CREATE SCHEMA, DRIVER=3.64.106

The exact same command works fine using the DB2 command-line tools.

Axel Fontaine · Accepted Answer · 2012-12-24 14:32:38Z

9

I found it.

It turns out that for some reason DB2 Express-C does not grant the DBADM privilege to db2admin by default.

This can be fixed by connecting to the DB and then issuing

GRANT DBADM ON DATABASE to db2admin

Thanks Ian Bjorhovde for providing the inspiration spark!

answered Dec 24, 2012 at 14:32

Axel Fontaine

35.4k19 gold badges110 silver badges144 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

the_marcelo_r · Accepted Answer · 2012-12-21 15:45:51Z

1

Looks like it is not a matter of Syntax but authentication, you have to check the credentials that you are passing through JDBC:

-552 authorization-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION operation

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z9.doc.codes%2Fsrc%2Ftpc%2Fn552.htm

answered Dec 21, 2012 at 15:45

the_marcelo_r

1,85623 silver badges36 bronze badges

8 Comments

Axel Fontaine Over a year ago

As I said, the user is DB2Admin and has all the rights. This same user can execute the statement with the DB2 command-line tools without problems.

the_marcelo_r Over a year ago

I would try to narrow down the root cause, can you use another DB2 client and try to perform some DDL with the same credentials? java-source.net/open-source/sql-clients

Axel Fontaine Over a year ago

Already did that. I also tried 3 different versions of the jdbc driver: an older one and the newest jdbc3 and jdbc4 ones. No luck.

the_marcelo_r Over a year ago

So the next steps would be to try the same code against a fresh DB server and see what happens, it might give you some clues: www-01.ibm.com/software/data/db2/express-c/download.html

Ian Bjorhovde Over a year ago

Please post the results of the query select dbadmauth from syscat.dbauth where grantee = current user when you are connected to the database as the user that is trying to execute CREATE SCHEMA

|

Collectives™ on Stack Overflow

create db2 schema using jdbc

2 Answers 2

Comments

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related