SQL0443N even after binding db2schema.bnd

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Troels Arvin - 24 Jan 2007 15:25 GMT

Hello,

DB2 installation: V. 8.1 LUW, fixpak 10.

In certain situations, I get strange error messages. Example: I want to
add a NOT NULL constraint to a column. Through db2cc, I try to do what
corresponds to
CONNECT TO SOMEDB;
CALL SYSPROC.ALTOBJ ( 'APPLY_CONTINUE_ON_ERROR', 'CREATE TABLE
TRA_TEST.FOOBAR ( K INTEGER NOT NULL , C VARCHAR (50) ) IN WHATEVER ',
-1, ? ); ;
CONNECT RESET;

However, DB2 responds with:
[IBM][CLI Driver][DB2/6000] SQL0443N Routine "ALTOBJ" (specific
name "") has returned an error SQLSTATE with diagnostic text
"SQL0551 Reason code or token: TRA|BIND|NULLID.ALTOBJ_S
". SQLSTATE=38553

I've tried following the steps from
http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&dc=D600&uid=swg212
15626&loc=en_US&cs=UTF-8&lang=en
I.e.:
db2 terminate
db2 connect to <database-name>
db2 bind <path>/db2schema.bnd blocking all grant public sqlerror continue
db2 terminate

However, that doesn't help.

I'm running out of ideas. Suggestions?

Signature

Regards,
Troels Arvin <troels@arvin.dk>
http://troels.arvin.dk/

Reply to this Message

Knut Stolze - 24 Jan 2007 18:18 GMT

> Hello,
>
[quoted text clipped - 14 lines]
> "SQL0551 Reason code or token: TRA|BIND|NULLID.ALTOBJ_S
> ". SQLSTATE=38553

$ db2 "? SQL0551"

SQL0551N "<authorization-ID>" does not have the privilege to
perform operation "<operation>" on object
"<name>".

<authorization-ID> = TRA
<operation> = BIND
<name> = NULLID.ALTOBJ_S

Are you working as DBA?

Signature

Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Reply to this Message

Troels Arvin - 25 Jan 2007 09:20 GMT

> <authorization-ID> = TRA
> <operation> = BIND
> <name> = NULLID.ALTOBJ_S
>
> Are you working as DBA?

No, but I have all permissions on the table, e.g. I could even drop the
table.

When I perform the same action with as a SYSADM user, db2cc pops up
a window called "Alter Table" with an arrow on a step called "Find
dependent objects and generate SQL statements"; this step seems to take a
very long time, even for a dummy table with two simple columns and two
rows.

Signature

Regards,
Troels Arvin <troels@arvin.dk>
http://troels.arvin.dk/

Reply to this Message

Knut Stolze - 25 Jan 2007 10:00 GMT

>> <authorization-ID> = TRA
>> <operation> = BIND
[quoted text clipped - 4 lines]
> No, but I have all permissions on the table, e.g. I could even drop the
> table.

Do you have the BIND privilege as the error message indicates?

Signature

Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Reply to this Message

Troels Arvin - 26 Jan 2007 08:45 GMT

On Thu, 25 Jan 2007 09:20:05 +0000, I wrote:

> When I perform the same action with as a SYSADM user, db2cc pops up
> a window called "Alter Table" with an arrow on a step called "Find
> dependent objects and generate SQL statements"; this step seems to take a
> very long time, even for a dummy table with two simple columns and two
> rows.

Tried again this morning, and now it worked. There was probably a locking
situation.

Signature

Regards,
Troels Arvin <troels@arvin.dk>
http://troels.arvin.dk/

Reply to this Message