Copy plan authorizations missing GRANT statements QI172W for Database Management tools
search cancel

Copy plan authorizations missing GRANT statements QI172W for Database Management tools

book

Article ID: 7045

calendar_today

Updated On:

Products

Database Management for DB2 for z/OS - Administration Suite Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - Recovery Suite Database Management for DB2 for z/OS - SQL Performance Suite Database Management for DB2 for z/OS - Utilities Suite DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

Database Management for Db2 for z/OS Post Install copy plan authorizations processing missing GRANT statements - QI172W.

Cause

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.

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 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.