Incident: SQLCODE -551 in the branch fee report
Job BRRPT (user BRPT01) failed: DSNT408I SQLCODE = -551, ERROR: BRPT01 DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION SELECT ON OBJECT DBADM1.BRANCH_FEE Change CHG4490 created table BRANCH_FEE yesterday and added it to the report
The branch report job BRRPT runs under the batch user BRPT01. Yesterday change CHG4490 created a new table, DBADM1.BRANCH_FEE, and changed the report to read it. This morning the report failed with SQLCODE -551. Site standard: report users get read access through the group RPTGRP (BRPT01 is in it), never one by one and never through PUBLIC. You are LEARNER, a member of the database administration group DBADM1, which owns BRANCH_FEE. Find out what is missing and put it right, giving no more access than the report needs.
What you will do
- Read the -551
- Compare the grants on the report's tables with the new table
- Grant what is missing to the right group, and prove it
Simulated: the Lab runs entirely in your browser on a simulated, fictional z/OS system. Nothing is sent to or run on a real mainframe.
Free, no account needed.
Your work is saved on this device; sign in to keep it in your account.