DSNT408I SQLCODE -551 invoking XP Execution Procedures from Database Analyzer main menu

Products

• Database Analyzer for DB2 for z/OS

Issue/Introduction

Received the following Db2 SQL-551 error message upon invoking XP for Execution Procedures from the Database Analyzer for Db2 for z/OS (PDA) main menu:

DSNT408I SQLCODE = -551, ERROR: <userid> DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION
                  SELECT ON OBJECT PTI.RAEP_PROC_1105
DSNT418I SQLSTATE = 42501 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXOSC SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -10 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFFF6' X'00000000' X'00000000' X'FFFFFFFF'
                  X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

<Userid> is the package owner of all the Database Management Solutions packages. What other authorizations that are needed for PDA?

Resolution

Grant <userid> SELECT, UPDATE, DELETE and INSERT to table PTI.RAEP_PROC_1105 and all the PDA tables which can be located in hlq.CDBASKL0(PDADDL) and make certain the <userid> has authorization to the PDA plans which can be completed through the Product Authorization option which is option A under General Facilities from the Database Management Solutions for Db2 for z/OS main menu.