SQL -551 authorization error when executing Database Management for Db2 for z/OS utility
search cancel

SQL -551 authorization error when executing Database Management for Db2 for z/OS utility

book

Article ID: 123438

calendar_today

Updated On: 03-13-2025

Products

Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS Database Management for DB2 for z/OS - Utilities Suite Quick Copy for DB2 for z/OS Fast Recover for DB2 for z/OS

Issue/Introduction

A Fast Load for Db2 for z/OS (PFL) 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, hlq.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