PL/I · DB2 SQLCODE
What does SQLCODE +551: Authorization ID Lacks the Required Privilege mean in PL/I?
The authorization ID the PL/I program runs under (its own ID, or the plan/package owner depending on bind options) lacks the DB2 privilege the statement needs — commonly hit right after a new program is deployed before its ID has been granted SELECT, INSERT, UPDATE, or EXECUTE on the tables or plan it uses.
The authorization ID the PL/I program runs under (its own ID, or the plan/package owner depending on bind options) lacks the DB2 privilege the statement needs — commonly hit right after a new program is deployed before its ID has been granted SELECT, INSERT, UPDATE, or EXECUTE on the tables or plan it uses.
Have the DBA GRANT the missing privilege to the authorization ID (or a group/role it holds), then rebind the plan/package so it stops taking the dynamic-bind penalty.