Jani Tamminen wrote:
When I try to drop a database or list the applications, I get the
following error:
SQL1092N: dbsys does not have the authority to perform this command.
I checked:
db2 get dbm cfg|grep SYSADM_GROUP and I got the o/p as SYSAMIN group.
I (dbsys) is part of the SYSADMIN group.
I am looking for some suggestions on what I should try next?
Connect to the database as user DBSYS and run GET AUTHORIZATIONS. If it
doesn't show up there that you have SYSADM privileges, then something
doesn't match as it should.
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
