WLM_REFRESH stored procedure



IBM's flagship relational database management system

WLM_REFRESH stored procedure

Postby p19689 » Fri Jul 06, 2012 2:49 pm

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.
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: WLM_REFRESH stored procedure

 

Re: WLM_REFRESH stored procedure

Postby Robert Sample » Fri Jul 06, 2012 5:46 pm

Did you sign off TSO and log back on after issuing the RACF commands?
Robert Sample
Global moderator
 
Posts: 3367
Joined: Sat Dec 19, 2009 8:32 pm
Location: East Dubuque, Illinois
Has thanked: 1 time
Been thanked: 222 times

Re: WLM_REFRESH stored procedure

Postby p19689 » Fri Jul 06, 2012 7:57 pm

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 ?
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: WLM_REFRESH stored procedure

Postby Robert Sample » Fri Jul 06, 2012 8:00 pm

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.
Robert Sample
Global moderator
 
Posts: 3367
Joined: Sat Dec 19, 2009 8:32 pm
Location: East Dubuque, Illinois
Has thanked: 1 time
Been thanked: 222 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post