Error in executing SYSPROC.ALTOBJ procedure

[db2adm1]

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

[Shashi Mannepalli]

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

cheers...
Shashi Mannepalli
db2adm1 wrote:

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

[db2adm1]

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
Shashi Mannepalli wrote:

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

cheers...
Shashi Mannepalli
db2adm1 wrote:

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

[Serge Rielau]

db2adm1 wrote:

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

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

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

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

[db2adm1]

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

Serge Rielau wrote:

db2adm1 wrote:

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

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

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

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

[mike]

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.

[db2adm1]

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...

mike wrote:

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.

[Gert van der Kooij]

In article <11**********************@s13g2000cwa.googlegroups .com>,
ri*********@yahoo.com says...

>
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.