SQLCODE = -551



IBM's flagship relational database management system

SQLCODE = -551

Postby maxcc » Mon May 10, 2010 4:50 pm

When I'm trying to create a table I get the following error

SQLCODE = -551, ERROR: DIV23 DOES NOT HAVE THE PRIVILEGE TO PERFORM
OPERATION CREATE TABLE ON OBJECT DSNDB04

My admin says that Create your table by using UHGDE and UHGTF

What does this mean?
maxcc
 
Posts: 28
Joined: Fri Apr 30, 2010 12:50 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SQLCODE = -551

Postby swd » Mon May 10, 2010 5:32 pm

If your admin guy says to create your table using these....why not ask him what they are and perhaps provide an example for you. Personally I've never heard of them.
User avatar
swd
 
Posts: 109
Joined: Wed Feb 18, 2009 9:18 pm
Location: UK
Has thanked: 0 time
Been thanked: 0 time

Re: SQLCODE = -551

Postby enrico-sorichetti » Mon May 10, 2010 5:59 pm

My admin says that Create your table by using UHGDE and UHGTF
What does this mean?


How do You expect us to know?
ask Your admin 8-)
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: SQLCODE = -551

Postby maxcc » Mon May 10, 2010 7:05 pm

He replied that he has no idea about programming. probably he looked some database and copy pasted...

Probably some one experience(DB2) or dealt with this error message should be able to help here.. or give an idea what it could mean...

This is what I had coded earlier..

create table div1.divya
(lastname char(20) not null,
firstname char(20) not null,
address char(45) not null with default)
maxcc
 
Posts: 28
Joined: Fri Apr 30, 2010 12:50 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SQLCODE = -551

Postby enrico-sorichetti » Mon May 10, 2010 7:20 pm

He replied that he has no idea about programming.

since the IDtenT declared him/herself as a db2 admin he/she should know
that ... create table is a cross-function task

for the testing environment also the application programmer might be authorized to do it
for the production environment the admins are supposed to do it
and they should know the meaning of a -551 SQLCODE

nothing we can do from here
get in touch with somebody less stupid and ask him/her about the authorizations
of the application developers concerning table creation

the DSNDB04 ( IIRC ) is the default database where things get created when
a database is not explicitly chosen

or ask Your peers about the same issue
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: SQLCODE = -551

Postby dick scherrer » Mon May 10, 2010 11:40 pm

Hello,

He replied that he has no idea about programming.
And is less valuable because of this ignorance. . .

My admin says that Create your table by using UHGDE and UHGTF
If the admin says to use these, the admin should also know what they are or where to find them. . . CREATE TABLE is not a programming issue. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: SQLCODE = -551

Postby GuyC » Tue May 11, 2010 3:13 pm

a table must reside in a database and a tablespace (with an underlying VSAM).

If you don't specify "IN dbname.tsname" or "IN DATABASE dbname" on your Create table DB2 will try to create the table in an implicit created tablespace; in DSNDB04 before DB2 V9 ; in DSN00001-DSN10000 since DB2 V9.

If you want to create a table you must have creatab authority in at least one database, and that is something your dba should know. ask in which databasse you are allowed to create tables and specify that on your create statement.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: SQLCODE = -551

Postby dick scherrer » Wed May 12, 2010 1:10 am

Hello,

My admin says that Create your table by using UHGDE and UHGTF
I wonder if those are the database and/or tablespaces programmers are supposed to use. . .

Rather a shame that the dba will not provide more useful answers. . .

Unless this is described in some local documentation that has not been shared/used :?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: SQLCODE = -551

Postby GuyC » Wed May 12, 2010 7:48 pm

maxcc wrote:He replied that he has no idea about programming.

one of the best blogs I've read lately :
http://datatechnologytoday.wordpress.co ... evelopment
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: SQLCODE = -551

Postby maxcc » Wed May 12, 2010 8:14 pm

Thanks GuyC!
maxcc
 
Posts: 28
Joined: Fri Apr 30, 2010 12:50 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post