No Select Privilege for PTI.PTMGB_APTABLE_0100 in RC/Migrator
search cancel

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/OS 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

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.