Page 1 of 1

SQLCODE = -551

PostPosted: Mon May 10, 2010 4:50 pm
by maxcc
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?

Re: SQLCODE = -551

PostPosted: Mon May 10, 2010 5:32 pm
by swd
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.

Re: SQLCODE = -551

PostPosted: Mon May 10, 2010 5:59 pm
by enrico-sorichetti
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-)

Re: SQLCODE = -551

PostPosted: Mon May 10, 2010 7:05 pm
by maxcc
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)

Re: SQLCODE = -551

PostPosted: Mon May 10, 2010 7:20 pm
by enrico-sorichetti
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

Re: SQLCODE = -551

PostPosted: Mon May 10, 2010 11:40 pm
by dick scherrer
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. . .

Re: SQLCODE = -551

PostPosted: Tue May 11, 2010 3:13 pm
by GuyC
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.

Re: SQLCODE = -551

PostPosted: Wed May 12, 2010 1:10 am
by dick scherrer
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 :?

Re: SQLCODE = -551

PostPosted: Wed May 12, 2010 7:48 pm
by GuyC
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

Re: SQLCODE = -551

PostPosted: Wed May 12, 2010 8:14 pm
by maxcc
Thanks GuyC!