DSMTOP failed during start with insuficient privileges for SYSDBA user

Question

recently we upgraded our DB2 v10.5.8 to v11.1.4. We sucessfully upgraded all instances (check via db2 get dbm cfg) and then run command db2updv111 -d dbname to upgrade databases. Unfortunately it seems, that it was not fully successful. When I try to run dsmtop I see the following error.

When I try to explicitly grant EXECUTE privilege to user I receive error message, that the object does not exist.

I tried to run it under user db2admin which is instance user with SYSADM role. When I create a new database I can run dsmtop successfully. This problem is related only to upgraded databases.

Is there any way how to bind some package or run anything which can fix the privileges? Something like reset the database to the default of that database version.

Thank you.

score 0 · Answer 1 · answered Jul 15 '19 at 20:22

0

Try this

$ db2 "grant execute on function SYSPROC.ENV_GET_SYSTEM_RESOURCES() TO public"

DB20000I  The SQL command completed successfully.

answered Jul 15 '19 at 20:22

Paul Vernon

139

Thanks for an advice Paul, but the result is the same. – Ondřej Žižka Jul 17 '19 at 06:40
Did the grant run without error? What error message do you now get in dsmtop? – Paul Vernon Jul 17 '19 at 08:21
You might be best raising a case with IBM Support – Paul Vernon Jul 17 '19 at 08:22
There were no error when I run the GRANT command. I will contact IBM support. Thank you. – Ondřej Žižka Jul 18 '19 at 09:22

DSMTOP failed during start with insuficient privileges for SYSDBA user

1 Answers1