How to make the GRANT?s in the corresponding plan for the userid?

Products

• CA RC/Migrator
• CA Endevor SCM Interface
• DB2 Administration
• CA RC Compare for DB2 for z/OS
• CA RC Extract for DB2 for z/OS
• CA RC/Query
• CA RC Secure for DB2 for z/OS
• CA RC Update for DB2 for z/OS
• CA Database Analyzer for DB2 for z/OS
• CA Fast Unload for DB2 for z/OS
• CA Fast Check for DB2 for z/OS
• CA Fast Index for DB2 for z/OS
• CA Fast Load for DB2 for z/OS
• CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

When you encounter SQL -551 error message for a product plan

DSNT408I SQLCODE = -551, ERROR: USERID DOES NOT HAVE THE PRIVILEGE TO PERFORM Product Planxxx

.DSNT418I SQLSTATE = 42501 SQLSTATE RETURN CODE

.DSNT415I SQLERRP = DSNXEAAL SQL PROCEDURE DETECTING ERROR

How to make the GRANT’s in the equivalent plan for the userid? 

Environment

Release:
Component: GEN

Resolution

The SQLCODE -551 error is telling you that DB2 does not have the correct GRANT's to execute the plan for authid USERID.

In the CA Database Management for DB2 for z/os  main menu you have this menu item.

General Facilities

_A Product Authorization

 

Look for example for Report Facility Menu after you select it and use the "E" line command.

E__ Report Facility Menu

 

afterwards the screen expand as follows:

___ Report Facility Menu

D__ PRF Product Plan

D__ QMF to PRF Conversio

 

Use "D" on the two above to see the grant.

GRANT EXECUTE ON PLAN PRFRRxxx

GRANT EXECUTE ON PLAN PRFQRxxx

where xxx represent the used product release.

 

Grant execute for the authid USER1 to the two PRF plans you have in your hlq.CDBAPARM(PLANS00)

PRFPLN01=PRFRRxxx PRF Product Plan

PRFPLN02=PRFQRxxx QMF to PRF Conversion Plan

 

GRANT EXECUTE ON PLAN yourRRxxx plan TO USER1 GRANT EXECUTE ON PLAN yourQR171plan TO USER1

Package PRFWSTR is part of collection PRFRRxxx_COM bound into PLAN PRFRRxxx.