SQL -551 Authorization error when running utility

Document ID : KB000123438
Last Modified Date : 24/12/2018
Show Technical Document Details
Issue:
A CA Fast Load job fails with a -551 SQL error on the PTDB Restart table :

DSNT408I SQLCODE = -551, ERROR: auth-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION SELECT ON OBJECT PTI.PTGL700_RESTART2

The submitter of the job has SYSADM. The authorization ID reported in the SQL error is a different ID.
Cause:
The auth-id reported in the message is the Plan Owner for the PUT General Utilities Plan, DGLPLN01= as defined the CDBPARM(PLANSxx) member. This ID is the Install SYSADM ID that was used to execute the DB2 catalog customization tasks on this subsystem. The -551 SQL error indicates that this ID no longer has the required authority to perform the operation, in this case a SELECT against PTI.PTGL700_RESTART2.
Resolution:
To resolve this error, either grant SYSADM to this auth-ID, or re-execute the Bind Product Packages and Plans task, CDBASAMP(ssid0002) using a userid with SYSADM authority. You can also specify the id to be used as the Plan Owner by specifying it in the PLANOWN parameter in the CDBAPARM(SETUPnn) member for the relevant subsystem definition.
Additional Information:
https://docops.ca.com/ca-database-management-solutions-for-db2-for-z-os/20/en/installing/complete-product-configuration/execute-db2-catalog-customization-tasks/installation-related-and-general-tasks/bind-product-packages-and-plans

https://docops.ca.com/ca-database-management-solutions-for-db2-for-z-os/20/en/installing/complete-product-configuration/setup-global-and-product-parmlib-members/configure-global-parmlib-members/create-a-setup-global-parmlib-member