It turns out user used “chown -R instanceUsername:anotherGroupname sqllib”, thus changed lots of permissions.
Tried to reset permission using “/opt/IBM/db2/V9.5/instance/db2iupdt -k instanceUsername”, but still not working after that.
The workaround, per IBM, is to:
1. Uncatalog database;
2. Drop instance;
3. Create instance;
4. Catalog database again;
so as instance owner (note: I got the same error: instance owner does not have authority .. This step can be skipped .. ):
db2 uncatalog database db1
db2 uncatalog database db2
as root:
/opt/IBM/db2/V9.5/instance/db2idrop instanceUsername
/opt/IBM/db2/V9.5/instance/db2icrt -u db2fenc1 instanceUsername
as instance owner:
db2 catalog database db1 as db1
db2 catalog database db2 as db2
db2 terminate
