SQLCODE -551
search cancel

SQLCODE -551

book

Article ID: 97562

calendar_today

Updated On:

Products

Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS

Issue/Introduction

User received the following error message upon invoking the XP  Execution Procedures from the PDA  Main Menu:
********************************* TOP OF DATA *********************************
DSNT408I SQLCODE = -551, ERROR: DBPSTS2 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
******************************** BOTTOM OF DATA *******************************
Userid DBPSTS2 is the package owner of all the CA packages. What other authorizations that are needed for PDA? 

Environment

Release:
Component: PDA

Resolution

1- Either grant userid DBPSTS2 SELECT, Update, Delete and Insert to PTI.RAEP_PROC_1105 and all the PDA tables which you can find in CDBASKL0(PDADDL) or
2-Make sure that userid DBPSTS2 has autorization to the PDA PLANS. which can  be done thru Product Authorization option which option A under General Facilities (_ A Product Authorizations)