By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,727 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

problem with db2 authentification

P: n/a
Hi

after a long hot (litteraly ... really hot in Paris today) harrowing
week , I'm a stuck on a minor/major issue (depends on the point of view
....) with db2 .

I'm trying to create a bufferpool with the following command :

create bufferpool plantestpool size 500 pagesize 32768;

instead of a sql command successful , i get that messsage :

SQL0552N "DB2INST2" does not have the privilege to perform operation
"CREATE
BUFFERPOOL". SQLSTATE=42502

So i'm looking for some stuff on the internet and i find this :

db2 => select * from syscat.schemaauth;

GRANTOR
GRANTEE

GRANTEETYPE SCHEMANAME

ALTERINAUTH CREATEINAUTH
DROPINAUTH
--------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------
-----------
--------------------------------------------------------------------------------------------------------------------------------
----------- ------------ ----------
SYSIBM
PUBLIC

G NULLID

N Y N

SYSIBM
PUBLIC

G ASN

N Y N

SYSIBM
DB2INST2

U COOL

G G G

SYSIBM
PUBLIC

G REP_TARG

N Y N

SYSIBM
PUBLIC

G REPTRG

N Y N

As you can see db2inst2 has a granteetype = U .

Questions :

What does it mean ?

How can I change that in order to be able to create a bufferpool ?

TIA,
Andy the beginner in DB2.

Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Andy K wrote:
Hi

after a long hot (litteraly ... really hot in Paris today) harrowing
week , I'm a stuck on a minor/major issue (depends on the point of view
...) with db2 .

I'm trying to create a bufferpool with the following command :

create bufferpool plantestpool size 500 pagesize 32768;

instead of a sql command successful , i get that messsage :

SQL0552N "DB2INST2" does not have the privilege to perform operation
"CREATE
BUFFERPOOL". SQLSTATE=42502
Does "db2inst2" have SYSCTRL or SYSADM authority as is required for the
CREATE BUFFERPOOL statement?
http://publib.boulder.ibm.com/infoce...n/r0000912.htm
So i'm looking for some stuff on the internet and i find this :

db2 => select * from syscat.schemaauth;


The schema privileges are not relevant here.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #2

P: n/a
In article <d9**********@fsuj29.rz.uni-jena.de>, Knut Stolze
(st****@de.ibm.com) says...

Does "db2inst2" have SYSCTRL or SYSADM authority as is required for the
CREATE BUFFERPOOL statement?


A quick way to find out: 'db2 get authorizations'
(after connecting to the database)
Nov 12 '05 #3

P: n/a
CREATE BUFFERPOOL requires you to be SYSADM or SYSCTRL. In general,
you can check the authorization requirements where the command is
documented (SQL Reference, in this case).

/T

Nov 12 '05 #4

P: n/a
Bufferpool is meant for the database as a whole. So schemaauth has
nothing to do with bufferpool creation. Schemaauth show the privileges
with respect to particular schema. SYSADM and SYSCTRL authority are
assigned through groups. Make sure that you belong to the group and try
this command.

Correct me if i am wrong.

Cheers,
Thiru.
Wa***********@gmail.com

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.