Page 1 of 1

WLM_REFRESH stored procedure

PostPosted: Fri Jul 06, 2012 2:49 pm
by p19689
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.

The Error:
'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)
END

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.

Re: WLM_REFRESH stored procedure

PostPosted: Fri Jul 06, 2012 5:46 pm
by Robert Sample
Did you sign off TSO and log back on after issuing the RACF commands?

Re: WLM_REFRESH stored procedure

PostPosted: Fri Jul 06, 2012 7:57 pm
by p19689
Yes Robert , I did. But I had noticed that WLM_REFRESH in different application environment to the application environment that I need to refresh. Above RACF command should I need to issue for the both application environments ? The one with WLM_REFRESH as well as the application environemt that I need to refresh ?

Re: WLM_REFRESH stored procedure

PostPosted: Fri Jul 06, 2012 8:00 pm
by Robert Sample
It never hurts to check the simple things first -- failure to log off and back on is easy to forget.

I would expect you to need to issue the RACF commands for both.