When invoking RC/Query and RC/Migrator user encouters RC=008 RCODE=0052 user not authorized to execute plan
book
Article ID: 233493
calendar_today
Updated On:
Products
RC/Query for DB2 for z/OSDatabase Management for DB2 for z/OS - Administration SuiteDatabase Management for DB2 for z/OS - Performance SuiteDatabase Management for DB2 for z/OS - Recovery SuiteDatabase Management for DB2 for z/OS - SQL Performance SuiteDatabase Management for DB2 for z/OS - Utilities Suite
Issue/Introduction
User had access to the Db2 for z/OS tools such as RC/Query for Db2 for z/OS and RC/Migrator for Db2 for z/OS via Install SYSADM2.
This user is encountering the following error today: RC=008, RCODE=0052 USER xxxxxxxx IS NOT AUTHORIZED TO EXECUTE PLAN: xxxxxxxx
Resolution
Site had modified the Db2 Install SYSADM2 user for testing and had forgotten to reset the value. Once the Install SYSADM2 value was restored the problem was resolved.