SQL0443N Routine "SYSPROC.ALTOBJ" (specific name "ALTOBJ") has returned an error SQLSTATE with diagnostic text "DBA7904, DBAD". SQLSTATE=38553.
I got this error when I wished to make alter table operation, after digging for a while at the problem. I reached the following.
To solve this error :
you should add to your DB2 user account both DBADM and LOAD authorities.
How to do this :
1. Start DB2 with a DB2 administrative account (other than your DB2 user account).
2. Open the control center, then right-click the database and select authorities.
3. select the user and add (DBADM and LOAD) authorities to. Check the screenshot below.
