Hi , I am trying to run a WLM_REFRESH stored procedure (calling the proc via a program) to refresh an application environment on db2 v9 on z/os.The program completes with return code zero. However getting the following error. The stored procedure(WLM_REFRESH) is called with the correct parameters for this application environment. Another userid can run this job without an error , which was setup long time ago. Hence I suspect that I have missed something in my privilege settings.
'DSNT542I SQL ID userid1 IS NOT AUTHORIZED TO REFRESH WLM ENVIRONMENT DBPRWLM '
So far I have granted RACF and DB2 privillegs as below (based on an IBM Redbook) but having the same error.
1) RDEFINE DSNR (DBPR.WLM_REFRESH.DBPRWLM)
PE DBPR.WLM_REFRESH.DBPRWLM +
CLASS(DSNR) ID(userid1) ACCESS(READ)
2) GRANT EXECUTE ON PROCEDURE SYSPROC.WLM_REFRESH TO userid1;
Have I missed anything and could you please shade some light ? Many thanks in advance.