search cancel

Fastload : PUT6304E SQL ALTER failed with SQLCODE -551 in CSECT UTAGLPBX

book

Article ID: 257100

calendar_today

Updated On:

Products

Fast Load for DB2 for z/OS

Issue/Introduction

Message: DSNT408I SQLCODE = -551, ERROR:  authid DOES NOT HAVE THE PRIVILEGE TO
         PERFORM OPERATION ALTER TABLE ON OBJECT creator.tablename

The tablespace is "partition by growth". MAXPARTITIONS was large enough to allow for more partitions. I haven't used ALTER OBJECT to add a partition to the PBG tablespace but that appears to be what was going on. The job is used by an application team and we do not grant them ALTER ability. Is there a resolution to this problem.

We got out of the problem in this case by  increasing the DSSIZE.

 

 

Environment

Release : 20.0

DB2 for Z/OS

Resolution

Look at the FASTLOAD Verify Required Authorizations

you will see:

"If you are loading a partition-by-growth (PBG) tablespace and you have LOAD authority (and no higher-level Db2 authorization) for the database, you must have ALTER authority on the loaded table when Fast Load instantiates a new partition to the PBG tablespace."

Therefore ensure that the authid referenced in the message has the ability to ALTER the PBG so that the tablespace can be altered as it grows. Ensure that the SYSADM userid has the authority to update the DB2 catalog in this case that table. 

The workaround of increasing the DSSIZE would have prevented the need to instantiate a new partition and therefore no need to do an ALTER of the PBG avoiding the -551. Consider carefully what value DSSIZE for this PBG should be set at depending on its usage profile.  

Additional Information

FASTLOAD Verify Required Authorizations