How to GRANT plan execution for the Database Management Solutions

Products

• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Database Management for DB2 for z/OS - Utilities Suite
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

Encounter SQL -551 error message for a Database Management Solution for Db2 for z/OS product plan:

DSNT408I SQLCODE = -551, ERROR: USERID DOES NOT HAVE THE PRIVILEGE TO PERFORM Product Planxxxx
DSNT418I SQLSTATE = 42501 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXEAAL SQL PROCEDURE DETECTING ERROR

How to execute the GRANTs for the equivalent plan for the user.

Resolution

The SQLCODE -551 error is indicating that Db2 does not have the correct GRANTs to execute the plan for authid USERID.

In the Database Management for Db2 for z/OS main menu please note the following menu item:

 

General Facilities
_A Product Authorization


Grant Product Authorizations