COPY PLAN AUTHORIZATIONS MISSING GRANT STATEMENTS - QI172W

book

Article ID: 7045

calendar_today

Updated On:

Products

CA RC Compare for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

COPY PLAN AUTHORIZATIONS MISSING GRANT STATEMENTS - QI172W

Cause

After the execution of the INS Copy Authorization job SSID003, many ID's were lacking Execution on plans that had execution on the previous plans. There were many QI172W messages coming out of the job and many grants were not done or missing.  

Environment

DB2 V10, V11, and V12 on Release R18, R19 and R20.

Resolution

After more consideration to the message QI172W - it appears the Copyauth job is working as designed. The product is designed to grant execution per level or tier. 
Primary ID one granted several ID's Execution on certain plans and that worked, but it also granted another ID Grant Authority. So primary ID is the first tier, and the other ID is the 2nd Tier and it granted several IDs execution on certain plans, these were the ID's missing from the initial execution of the Copyauth job. By re-submiting the Copyauth job again you'll see the grant execution on the plans for the 2nd tier.