I think it is an authorization issue, since I can successfully run dmhcleardb on my personal install of RAA, where my userid has all priviledges.
On this customer's RAA installation, users are assigned to a DB2 group which has these priviledges:
- CONNECT to database;
- SELECT, INSERT, UPDATE, DELETE against all tables;
- and EXECUTE on the utility plans.
With these settings, users of this group can use RAA's web interface and they can run the dmh6000 utility. I think dmhClearDB.rexx is different in that it uses dynamic SQL, which may require other DB2 authorization settings.
What additional db2 security settings are required for running dmhClearDB.rexx?