No Select Privilege for PTI.PTMGB_APTABLE_0100 in RC/Migrator
book
Article ID: 116265
calendar_today
Updated On:
Products
RC Compare for DB2 for z/OSDatabase 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
While analyzing a strategy, it fails with: DSNT404I SQLCODE = 4726, WARNING: THE STATEMENT WAS SUCCESSFULLY PREPARED, BUT IT CANNOT BE EXECUTED BECAUSE HARPEM2 DOES NOT HAVE SELECT PRIVILEGE ON OBJECT PTI.PTMGB_APTABLE_0100.
Environment
Release: Component: RCM
Resolution
There are three ways to resolve this "SELECT PRIVILEGE" error a. Grant Select for this user to: PTI.PTMGB_APTABLE_0100. b. Rebind package; RMA$APM1 with DYNAMICRULES(BIND) c. Rebind the plan; RCMPLN02 with DYNAMICRULES(BIND) . Either one of these options will resolve the problem.