Database Management for Db2 for z/OS Post Install copy plan authorizations processing missing GRANT statements - QI172W.
After the execution of the INS Copy Authorization job ssid0003, many IDs 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.
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 IDs 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 IDs missing from the initial execution of the COPYAUTH job.
By resubmitting the COPYAUTH job again you will see the grant execution on the plans for the 2nd tier.