COPY PLAN AUTHORIZATIONS MISSING GRANT STATEMENTS - QI172W

Document ID : KB000007045
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

COPY PLAN AUTHORIZATIONS MISSING GRANT STATEMENTS - QI172W

Environment:
DB2 V10, V11, and V12 on Release R18, R19 and R20.
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.  

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.