Error in executing SYSPROC.ALTOBJ procedure

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

db2adm1 - 10 Jul 2006 19:58 GMT

I am getting the following error while trying to alter a table's
column...I am trying to increase the decimal length of the column from
5 to 6 using altobj procedure.

SQL0443N Routine "SYSPROC.ALTOBJ" (specific name "ALTOBJ") has
returned an
error SQLSTATE with diagnostic text "DBA7904, DBAD". SQLSTATE=38553

I looked up the error details, but no much help... Can anyone tell me
what "DBA7904, DBAD" means? Thanks.
RF

Reply to this Message

Shashi Mannepalli - 10 Jul 2006 21:05 GMT

Try these

1. db2updv8
2. cd $instance/sqllib
chmod 777 tmp

cheers...
Shashi Mannepalli

> I am getting the following error while trying to alter a table's
> column...I am trying to increase the decimal length of the column from
[quoted text clipped - 7 lines]
> what "DBA7904, DBAD" means? Thanks.
> RF

Reply to this Message

db2adm1 - 10 Jul 2006 22:23 GMT

I executed 'db2updv8 -d dbname' and then ran the SYSPROC.ALTOBJ, but I
am getting the same error. 'tmp' folder in instance's sqllib folder is
already in 777 mode. Any idea on what is going on? It would be great
help if I can make this procedure run, otherwise, I have to go through
the pain of backing up data, drop table, recreate everything, load
data...there should be a easy way to increase the decimal length...any
idea, please?
Thanks

> Try these
>
[quoted text clipped - 16 lines]
> > what "DBA7904, DBAD" means? Thanks.
> > RF

Reply to this Message

Serge Rielau - 10 Jul 2006 23:57 GMT

> I am getting the following error while trying to alter a table's
> column...I am trying to increase the decimal length of the column from
[quoted text clipped - 3 lines]
> returned an
> error SQLSTATE with diagnostic text "DBA7904, DBAD". SQLSTATE=38553

SQL0443 long text refers to the db2diag.log. Anything in there?

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

db2adm1 - 11 Jul 2006 19:10 GMT

Yes, something writen there:

FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
DATA #1 : Hexdump, 136 bytes
0x027CBAE4 : 5351 4C43 4120 2020 0000 0088 FFFF FE45 SQLCA
.......E
0x027CBAF4 : 0023 5359 5350 524F 432E 414C 544F 424A
.#SYSPROC.ALTOBJ
0x027CBB04 : FF41 4C54 4F42 4AFF 4442 4137 3930 342C
.ALTOBJ.DBA7904,
0x027CBB14 : 2044 4241 4420 2020 2020 2020 2020 2020 DBAD
0x027CBB24 : 2020 2020 2020 2020 2020 2020 2020 2020
0x027CBB34 : 2020 2020 2020 2020 5351 4C45 5246 5250
SQLERFRP
0x027CBB44 : 0000 0000 0000 0000 0000 0000 0000 0000
................
0x027CBB54 : 0000 0000 0000 0000 2020 2020 2020 2020 ........
0x027CBB64 : 2020 2033 3835 3533 38553

what is it saying..? Thanks

> > I am getting the following error while trying to alter a table's
> > column...I am trying to increase the decimal length of the column from
[quoted text clipped - 15 lines]
> IOD Conference
> http://www.ibm.com/software/data/ondemandbusiness/conf2006/

Reply to this Message

mike - 12 Jul 2006 06:46 GMT

Perhaps you could post the DDL of the table that you are attempting to
modify, plus any of its indexes,constraints,triggers,views and
foreign-keys for that table, and the exact parameters that you are
passing to sysproc.altobj.

Reply to this Message

db2adm1 - 12 Jul 2006 14:39 GMT

Well, this time, I took an example from publib:

CALL SYSPROC.ALTOBJ('VALIDATE', CAST (NULL AS VARCHAR(2048)), 123, ?)

I ran it and I get the same error:

SQL0443N Routine "SYSPROC.ALTOBJ" (specific name "ALTOBJ") has
returned an
error SQLSTATE with diagnostic text "DBA7904, DBAD". SQLSTATE=38553

BTW, sometime I get diagnostic text as "SQL0669" in the above error
message. These messages lead to nowhere...I don't know how db2 throw a
diagnostic text which is not given in any of the documents! Anyways,
looks like none have idea about using this procedure...I just take
alternate way to get my things done...
Thanks for your time...

> Perhaps you could post the DDL of the table that you are attempting to
> modify, plus any of its indexes,constraints,triggers,views and
> foreign-keys for that table, and the exact parameters that you are
> passing to sysproc.altobj.

Reply to this Message

Gert van der Kooij - 12 Jul 2006 23:10 GMT

> SQL0443N Routine "SYSPROC.ALTOBJ" (specific name "ALTOBJ") has
> returned an
> error SQLSTATE with diagnostic text "DBA7904, DBAD". SQLSTATE=38553

c:\>db2 ? dba7904

DBA7904N The user does not have "<authority name>" authority,
which is required to run the SYSPROC.ALTOBJ stored
procedure.

Explanation:

Both DBADM and LOAD authorities are required to run the
SYSPROC.ALTOBJ stored procedure.

User Response:

Obtain the necessary authorities before running the stored
procedure.

Reply to this Message