3

I am trying to create a new schema on a database that I created at IBM Data Studio but I get error:

"DB2ADMIN" does not have the privilege to perform operation "CREATE SCHEMA".. SQLCODE=-552, SQLSTATE=42502, DRIVER=3.67.28.

How can I do it on command line?

Thanks!

Sal00m
  • 2,938
  • 3
  • 22
  • 33
furbymely
  • 33
  • 1
  • 5

1 Answers1

2

It is just because the user that you are using to connect to the database does not have the DBADM authority.

Possible duplicate of this question: create db2 schema using jdbc

Please check the documentation: create db2 schema using jdbc

AngocA
  • 7,655
  • 6
  • 39
  • 55