Database Analyzer for DB2 for z/OSFast Unload for DB2 for z/OSFast Check for DB2 for z/OSFast Index for DB2 for z/OSRapid 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)